Amazon RDS Read Replicas

Amazon RDS Read Replicas (Oct 2010)

• Homepage: https://aws.amazon.com/rds/features/read-replicas/

• Amazon RDS Read Replicas, Postgres: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PostgreSQL.Replication.ReadReplicas.html
  • You can create up to 5 read replicas from one source DB instance
  • You can't stop a DB instance that has a read replica, or that is a read replica.

News

• May 2022 - Supports cascaded read replicas for up to 30X more read capacity https://aws.amazon.com/about-aws/whats-new/2022/05/amazon-rds-postgresql-cascaded-read-replicas-30x-capacity/
• Jun 2016 - Amazon RDS for PostgreSQL now supports cross-region read replicas

Commands

• aws rds create-db-instance-read-replica
• aws rds describe-db-instances
• aws rds promote-read-replica

Related

• single AZ, multi AZ
• PostgreSQL replication
• Write-ahead logging (WAL)
• Amazon Aurora replication
• cross region

See also

• Amazon RDS Read Replicas, aws rds [ create-db-instance-read-replica | promote-read-replica | promote-read-replica-db-cluster ]

https://aws.amazon.com/blogs/aws/amazon-rds-announcing-read-replicas/

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_StopInstance.html

https://aws.amazon.com/about-aws/whats-new/2016/06/amazon-rds-for-postgresql-now-supports-cross-region-read-replicas/