Skip to content

Question about creating a read replicated database instance

0

Hi re:Post,

We are reviewing creating a read replicated database instance:

Source db name and Region: "db-demo", Ohio

Replica db name and Region: "db-demo-replica", Oregon

  1. When we create a read replica of the source RDS PostgreSQL database (db-demo), will the read replica (db-demo-replica) be created with the same:
  • Instance configuration (ie instance class)
  • Storage (type and amount)
  • Availability
  • Connectivity
  • Subnet group
  • Public access type
  • VPC Security Group
  • Certificate Authority
  • Database Authentication

as the source database it is replicating ?

  1. At the create read replica steps for Availability/Deployment options for "Multi-AZ DB Instance" - it says, "Creates a primary DB instance and a standby DB instance in a different AZ. Provides high availability and data redundancy, but the standby DB instance doesn't support connections for read workloads."

Enter image description here

  • 2a) We don't want another primary db instance, want we want a replicated read instance in Oregon based on the primary db in Ohio. Is that what is doing here?
  • 2b) Why does it not say it's creating a replicated db instance?
  • 2c) Why does it create a standby db instance that doesn't support read workloads, I thought that was the purpose of a read replica?
  1. Once created, will the replica database be displayed in the region we've specified under that Region's "Databases" list with a "Role" value of "Replica"?

Thank you for your time and help!

Best Regards,

Donald

asked 2 years ago200 views

1 Answer
2
Accepted Answer

Thank you for your detailed questions about creating a read replicated database instance in Amazon RDS. I'll address each of your points:

  1. When you create a read replica, it doesn't necessarily inherit all configurations from the source database. By default:
  • The instance class will be the same as the source.
  • The storage type will be the same, but you can choose a different type.
  • The allocated storage will be the same.
  • Other settings like availability, connectivity, subnet group, public access, VPC security group, certificate authority, and database authentication may differ and can be configured separately for the read replica.
  1. Regarding the Availability/Deployment options:

2a) The Multi-AZ option you're seeing is not about creating a read replica. It's an additional feature you can apply to your read replica for high availability. Your read replica will still be created in Oregon based on the primary in Ohio.

2b) The wording refers to the Multi-AZ deployment of the read replica itself, not the replication from Ohio to Oregon.

2c) This is describing the standby instance in the Multi-AZ setup of the read replica, not the read replica itself. The read replica will support read workloads, but its standby (if you choose Multi-AZ) will not.

  1. Yes, once created, the replica database will be displayed in the Oregon region's "Databases" list with a "Role" value of "Replica".

Remember, creating a cross-region read replica involves additional considerations, such as data transfer costs and potentially increased replication lag due to network latency between regions.
Sources
Creating a read replica - Amazon Relational Database Service
Working with DB instance read replicas - Amazon Relational Database Service
Working with Multi-AZ read replica deployments with MySQL - Amazon Relational Database Service
CreateDBInstanceReadReplica - Amazon Relational Database Service

answered 2 years ago

EXPERT

reviewed 2 years ago

  • Thank you AI Agent for your answers and explainations!

    Regarding, "2a) The Multi-AZ option you're seeing is not about creating a read replica. It's an additional feature you can apply to your read replica for high availability. Your read replica will still be created in Oregon based on the primary in Ohio."

    What if we don't want any HA for the read replica, it seems there is not an option to not have HA. The other option is only a write HA instance of the the read replica. What happens if we chose "Single DB Instance"? Does that mean will have an single db instance as an HA instance for the read replica?

    Thank you for your time and help! Best Regards, Donald

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.