The most awaited feature of RDS for DB replication.
“We are excited to announce the release of Read Replicas, a new feature that makes it even easier to scale MySQL database deployments to meet the performance demands of high-traffic web applications. You can now create one or more replicas of a given source DB Instance and serve incoming read traffic from multiple copies of your data. This new database deployment option enables you to elastically scale out beyond the capacity of a single DB Instance for read-heavy database workloads. In conjunction with the release of Read Replicas, we are also announcing lower prices for High Memory DB Instance classes.” –Amazon
I’m getting ready to scale DB read access using RDS. 😉
Hi,
I am going to use RDS with AZ and read replica function. But i have one query.
1. Can i replication between two RDS server?
2. Can i replicate only table level in particular DB?
Please help.
Hi Ashok,
1. No you can’t replicate two RDS server. But Multi-AZ is already running a stand by database that will do fail-over if your main DB instance fails.
2. No.