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’.
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
https://docs.aws.amazon.com/rds/index.html