FAQs On RDS Multi-AZ Deployment
1. Why does the changes which are made in the primary database take some time to get updated in the read replicas?
Since, Read replicas use asynchronous mode of replication the data will be copied to the read replicas only after the changes are being made to the primary database.
2. Is there any cost associated with reading replicas?
If the read replicas between cross-regions then a charge is applied for the replication process. If the read replicas are present in the region where the source DB is present then replication charges are not involved.
3. Does read replicas support write operation?
No, read replicas only support select clause SQL Queries. but, They can be promoted to their own standalone database.
RDS Read Replicas – How It is Different from RDS Multi-AZ Deployment
Amazon RDS (Relational Database Service) is a fully managed service by AWS to deploy and scale relation database systems in the cloud. Amazon RDS supports a lot of relation database engines such as MYSQL, PostgreSQL, Oracle, SQL Server, etc.
Amazon RDS comes with a lot of handy features such as encryption, scaling, snapshotting, disaster recovery, etc. Therefore, the can developer can focus on the development of the application without worrying about the underlying database infrastructure.
Note: RDS supports both horizontal and vertical scaling methodologies.