AWS RDS Read Replica

AWS RDS Read Replica

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

 

Leave a Reply

Close Menu