You are currently viewing AWS RDS Read Replica

AWS RDS Read Replica

  • Post author:
  • Post category:AWS / RDS

AWS RDS read replica

Hello Everyone

Welcome to CloudAffaire and this is Debjeet.

In the last blog post, we have discussed AWS RDS instance subnet groups.

https://cloudaffaire.com/aws-rds-instance-subnet-groups

In this blog post, we will discuss AWS RDS read replica.

Read Replica:

Amazon RDS uses the MariaDB, MySQL, Oracle, and PostgreSQL DB engines’ built-in replication functionality to create a special type of DB instance called a Read Replica from a source DB instance. Updates made to the source DB instance are asynchronously copied to the Read Replica. When you create a Read Replica, you first specify an existing DB instance as the source. Then Amazon RDS takes a snapshot of the source instance and creates a read-only instance from the snapshot.

The Read Replica operates as a DB instance that allows only read-only connections. Applications connect to a Read Replica the same way they do to any DB instance. Amazon RDS replicates all databases in the source DB instance. Read Replica can be created to a different region than the source AWS RDS instance’s region. Read Replicas are supported by the MariaDB, MySQL, Oracle, and PostgreSQL engines.

Next, we are going to create a Read Replica of our existing AWS RDS PostgreSQL instance.

Prerequisite for this demo:

  • AWS RDS PostgreSQL instance.

AWS RDS Read Replica:

Step 1: Login to AWS console and navigate to ‘RDS’.

AWS RDS Read Replica

Step 2: In the navigation pane, click ‘Databases’, select your RDS instance and from ‘Actions’ click ‘Create read replica’.

AWS RDS Read Replica

Step 3: Provide instance configuration details and click ‘Create read replica’.

AWS RDS Read Replica

Note: You can create the Read Replica in a different region.

AWS RDS Read Replica

Note: You can create a Multi-AZ Read Replica and your source instance can be a part of Multi-AZ as well.

AWS RDS Read Replica

AWS RDS Read Replica

AWS RDS Read Replica

Read Replica successfully created.

AWS RDS Read Replica

You can connect to the Read Replica and perform read-only operations.

AWS RDS Read Replica

Hope you have enjoyed this article, In the next blog post, we will discuss Amazon RDS High Availability (Multi-AZ) options.

To get more details on AWS RDS, please refer below AWS documentation

https://docs.aws.amazon.com/rds/index.html