Amazon RDS MySQL and Master-master replication

mysql amazon-web-services database-replication amazon-rds multi-master-replication
DmitrySemenov picture DmitrySemenov · Mar 3, 2014 · Viewed 19.2k times · Source

I can't find it from documentation, but it seems Master-Master replication is not supported at this time. Is this correct?

Answer

Mike Brant picture Mike Brant · Mar 3, 2014

That is correct. RDS does not support Master-Master replication currently, so scaling horizontally for writes is not easily achievable, if that is your need. RDS does however support the ability to create multiple "read only" RDS slave instances, so scaling horizontally for reads is possible.

Here is RDS FAQ on replication

http://aws.amazon.com/rds/faqs/#replication

Related questions

AWS RDS MySQL Read Replica Lag Issues

I run a service that needs to be able to support about 4000+ IOPS and keep replica lag <=1 second to function properly. I am using AWS RDS MySQL instances and have 2 read replica's. My service was experiencing giant replica lag …

Read More
Access denied; you need (at least one of) the SUPER privilege(s) for this operation

So I try to import sql file into rds (1G MEM, 1 CPU). The sql file is like 1.4G mysql -h xxxx.rds.amazonaws.com -u user -ppass --max-allowed-packet=33554432 db < db.sql It got stuck at: ERROR 1227 (42000) at line 374: Access …

Read More
MySQL/Amazon RDS error: "you do not have SUPER privileges..."

I'm attempting to copy my mysql database from an Amazon EC2 to an RDS: I successfully did a mysqldump of my database into my root folder using this: root@ip-xx-xx-xx-xx:~# mysqldump my_database -u my_username -p > my_database.…

Read More