Menu
I have one server where mysql is running, its a VM. I am currently configuring another mysql in in Amazon RDS. Can I use this RDS database as a slave of the VM database. So I want the VM DB to be the master of the replication and the RDS database be the slave.
Is it at all possible? Or any other option?
872
With Amazon RDS, you can deploy scalable MySQL servers in minutes with cost-efficient and resizable hardware capacity. Amazon RDS for MySQL frees you up to focus on application development by managing time-consuming database administration tasks including backups, software patching, monitoring, scaling and replication.
Amazon RDS doesn't support circular replication. You can't configure a DB instance to serve as a replication source for an existing DB instance. You can only create a new read replica from an existing DB instance.
Yes it is possible, though this would not be a recommended setup.
RDS provides a built in procedure you can call to set this up. Rather than me explaining the procedure here, I will simply link you to the documentation.
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/mysql_rds_set_external_master.html
What this doesn't tell you is that you must have taken a consistent DB dump from the master DB and installed it on the RDS instance. You must also have obviously recorded the binary log position information when taking that consistent dump, so you have that information to use in the procedure.
77
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
