Most efficient way to clone an AWS RDS database

0 votes

I have 2 MySQL databases running on a server called X and Y, which both have identical content. A series of updates run throughout the day, which changes the content of X. At the end of the day, a process runs that compares the content of X with the content of Y (for various tables) in order to discover new rows, updated row data etc. Once the updates have been processed, mysqldump is used to dump X and then Y is overwritten with the dump. Both X and Y are now the same again, and the whole process repeats.

I'm investigating the migration of these databases to Amazon RDS. What's the most efficient way to accomplish the process outlined above?

Do I just do what I'm doing now i.e. mysqldump X and restore it to Y, or is there some other method/shortcut that RDS provides?

Apr 19, 2022 in AWS by Soham
• 9,700 points

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In AWS

0 votes
1 answer
0 votes
1 answer

Connect to AWS RDS Postgres database with python

Here my-rds-table-name is the database instance name, ...READ MORE

answered Feb 16, 2022 in AWS by anonymous
0 votes
1 answer

Want to use an AWS Cognito User Pool without putting a password(for an easier approach)

Currently, AWS Cognito is not supporting passwordless ...READ MORE

answered May 4, 2018 in AWS by Cloud gunner
• 4,670 points
0 votes
1 answer

IOPS or Throughput?

Configure your database driver to print statistics ...READ MORE

answered Nov 14, 2018 in AWS by Theodor
• 740 points
0 votes
1 answer
0 votes
0 answers
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP