Creating read-only replicas for RDS

Amazon Relational Database Service (RDS) provides a functionality to establish read-only replicas, replicating your database for multiple users’ access and efficient data sharing. These replicas can reside in the same region as, or a different one from, the primary one. This proves beneficial when encountering heavy read loads that could potentially impact RDS performance; replicas can accommodate the heavy read loads without impacting the primary instance’s performance. Additionally, you can create a replica in a region that is closer to your users, which can also help in the event of primary region disruption where the replica can be promoted to a standalone instance, thus allowing seamless operation continuation and disaster recovery.

RDS offers two primary replication modes for read replicas:

• In single-primary mode, a single primary RDS instance manages both read and write operations, while one or more read replicas can...