AWS RDS read replica
Welcome to CloudAffaire and this is Debjeet.
In the last blog post, we have discussed AWS RDS instance subnet groups.
In this blog post, we will discuss AWS RDS 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’.
Step 2: In the navigation pane, click ‘Databases’, select your RDS instance and from ‘Actions’ click ‘Create read replica’.
Step 3: Provide instance configuration details and click ‘Create read replica’.
Note: You can create the Read Replica in a different region.
Note: You can create a Multi-AZ Read Replica and your source instance can be a part of Multi-AZ as well.
Read Replica successfully created.
You can connect to the Read Replica and perform read-only operations.
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