Menu
The Amazon RDS FAQ seems to suggest that you can't have more than 5 replicas. Is there any workaround?
382
Replication with Aurora MySQL Each cluster can have up to five read replicas created this way, each in a different Region.
You can create up to 10 read replicas for a single primary instance.
You can create up to 15 read replicas from one source DB instance within the same Region. As of RDS for PostgreSQL 14.1, you can also create up to three levels of read replica in a chain (cascade) from a source DB instance. For more information, see Using cascading read replicas with RDS for PostgreSQL.
You can use Amazon Route 53 weighted record sets to distribute requests across your read replicas. Within a Route 53 hosted zone, create individual record sets for each DNS endpoint associated with your read replicas. Then, give them the same weight, and direct requests to the endpoint of the record set.
No. Amazon only allows you to create up to 5 replicas, and need to be launched one by one.
If You need more than 5 you can create a Master-slave configuration using EC instances, then you can have as many replicas as you want.
113
Currently there is a workaround that allows to have more than 5 read replicas - by creating read replicas of existing read replicas. It's still up to 5 read replicas per DB, and up to 2 layers (so max 30 read replicas in total).
To enable read replica to have read replicas, automated backups must be turned on:
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html#USER_ReadRepl.MySQL
31
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
