CODEWITHSUNDEEP
mysqlamazon-web-servicesamazon-rds
eric
eric

Reputation: 1473

Is it possible to have more than 5 read replicas in Amazon RDS?

The Amazon RDS FAQ seems to suggest that you can't have more than 5 replicas. Is there any workaround?

Upvotes: 5

Views: 4172

Answers (8)

Bhupendra Pandey
Bhupendra Pandey

Reputation: 358

yes in latest release you can create upto 15 read replica.

https://aws.amazon.com/rds/features/read-replicas/#:~:text=Use%20the%20%22Create%20Read%20Replica,replicas%20to%20each%20DB%20Instance.

Upvotes: 0

Ilmari Kumpula
Ilmari Kumpula

Reputation: 1493

This has now changed, the current status (2023, November) is according to AWS docs:

Amazon RDS for MySQL, MariaDB and PostgreSQL allow you to add up to 15 read replicas to each DB Instance.

Amazon RDS for Oracle and SQL Server allow you to add up to 5 read replicas to each DB Instance.

Upvotes: 0

silverbird
silverbird

Reputation: 1

Check out "Amazon RDS for MySQL, MariaDB and PostgreSQL allow you to add up to 15 read replicas to each DB Instance." under Setup section in RDS feature!

Upvotes: 0

talarczykco
talarczykco

Reputation: 523

10 years later, RDS limits can be lifted. Look for "Yes" in the "Adjustable" column:

The usual caveats apply for measuring performance impact of additional replicas on the primary.

Upvotes: 0

kellyfj
kellyfj

Reputation: 6963

One flavor of RDS Engine type - Aurora (for MySQL / PostgreSQL) supports up to 15 read replicas https://docs.amazonaws.cn/en_us/AmazonRDS/latest/AuroraUserGuide/Aurora.Replication.html

Upvotes: 0

semirami
semirami

Reputation: 299

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

Upvotes: 2

Harish Ganesan
Harish Ganesan

Reputation: 743

Five read replica's are more than enough for most of the times. More than 5 can impact the performance.

Scale up technique: if you are using m1.xlarge, you can scale up to Quadrapule EXL and get better performance with 5 RR itslef.

If your system demands more than 5 you can solve this by refining your architecture in following ways:

P1) Functionally partition the DB and have read replica's accordingly

P2) Offload read traffic to Amazon ElastiCache and DynamoDB

Upvotes: 0

Felipe Rojas
Felipe Rojas

Reputation: 156

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.

Upvotes: 4

Related Questions