By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

about Migrate from RDS to other RDS

0

current scenario

1 MysqlRDS with 8TB of an instance.

After migrating some application log tables, it was found that:

  • We are allocating an unnecessary 6TB, as the total size of the database is approx. 2TB

AWS does not yet provide means to downsize allocated storage.

what is the need

  • migrates the database to another instance in the same region with the storage already adjusted and thus freeing us from paying for an unnecessary 6TB of storage,

What is the best strategy for a bank with this volume, operating with 2 read replicas, 24 hours a day, 365 days a year.

Topics
Migration & ModernizationAnalyticsDatabase
Tags
Migration & ModernizationAmazon Relational Database ServiceDatabaseMySQL
Language
English
rePost-User-9651737
asked a year ago252 views
2 Answers
0

Currently the best option is to take a backup of your instance with mysqldump. And record the binlog coordinates. Then on a new RDS instance that is sized appropriately, reload the backup and then you can configure this RDS instance to replicate from the original source by using self managed replication with the rds_set_external_master stored procedure.

AWS
MODERATOR
philaws
answered a year ago
  • rePost-User-9651737
    a year ago

    If I were to follow technical steps.

    It would be like this?

    1. Back up the schemas in this source productive instance.

    2. -"record binlog coordinates" , How do I do it?

    3. restore the backup made in step 1 in a new instance already adjusted to its correct size.

    4. Regarding the next step, do you comment that the destination instance should be receiving replicated data from the source instance, would that be it?

    Already in step 5 that he comments on the item rds_set_external_master , you are also telling him to be receiving this configuration, precisely after it, the data that is being received in the source instance, will be replicated to the destination instance.

    Was that the plan?

0

Using DMS would minimize the downtime through replication:

https://aws.amazon.com/premiumsupport/knowledge-center/rds-db-storage-size/ https://docs.aws.amazon.com/dms/latest/userguide/CHAP_GettingStarted.html

AWS
AWS-User-0986812
answered a year ago
  • rePost-User-9651737
    a year ago

    I test. dude, but after restore the backup + DMS, we dispend more than 50 hours to finish with errors ....

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content