CODEWITHSUNDEEP
mysqlamazon-web-servicesamazon-ec2amazon-rds
JavaGuy
JavaGuy

Reputation: 689

Amazon RDS MySQL replication

I am struggling to setup replica with Amazon RDS. I want to make RDS as my master but for slave I want to setup my server outside of RDS. For now I am setting my slave at EC2. I have checked AWS doc for the information but could not find the exact answer to my question.

However I did found a blog post which have POC for doing it http://www.ruempler.eu/2013/07/07/replicating-aws-rds-mysql-databases-to-external-slaves/

But the problem that I facing is I am getting error

ERROR: Got error reading packet from server: Slave can not handle replication events with the checksum that master is configured to log

I tried to set binlog_checksum = none at RDS but RDS is not letting me change its config file.

Please suggest me folks!!

Upvotes: 1

Views: 2992

Answers (3)

Dilip Kola
Dilip Kola

Reputation: 212

You can use AWS DMS (Data migration service) for this purpose. It will support replication between any 2 MySQL DBs.

Please refer our blog: https://medium.com/tensult/cross-account-and-cross-region-rds-mysql-db-replication-part-1-55d307c7ae65

Upvotes: 1

Charlie Dalsass
Charlie Dalsass

Reputation: 2014

It does not appear to be possible as of now (December, 2017).

Looking at @walter-heck's second link above, it is actually (another) explanation of "... replication between an external master instance and a DB instance on Amazon RDS".

It does not appear you can setup an external replica which connects to a RDS running as master.

AWS does offer this service, of course, however each replica must be within RDS.

With all the service offerings AWS has, one would think this would be possible. However, it may not work well with the AWS business model, because you don't pay based on external replicas - you pay based on RDS size.

Upvotes: 0

Walter Heck
Walter Heck

Reputation: 2526

The question is quite old, but I bumped into it while searching for similar functionality. Amazon supports both replication from an external master and replicating to an external slave these days:

Replication from external master: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.External.Repl.html

Replication to external slave: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Exporting.NonRDSRepl.html

Hope this helps future searchers.

Upvotes: 0

Related Questions