High Availability with AWS RDS MultiAZ and Read Replica

Are you preparing to take the AWS Certified Solutions Architect Professional certification test? This space will contain articles that cover topics covered in the Solutions Architect Professional certification exam. This article will explain one of the most important features available with Amazon web services, which is AWS RDSMulti-AZ and Read Replica. This topic is likely to bring up a lot of questions for the Solutions Architect Professional exam. To receive the latest updates on this topic, you can subscribe to our mailing list.
AWS Certified Solutions Architect Professional – Free Test
How to prepare for the AWS Certified Solutions Architect Professional Exam?

This topic addresses the topic of High Availability/Business continuity, as mentioned in the table below and highlighted in the AWS Blueprint exam guide.

Multi-AZ and Read Replica: Purpose
AWS offers the ability to host Relational databases. These databases are supported by AWS: PostgreSQL and MySQL, MariaDB, Oracle, Microsoft SQL Server, and Microsoft SQL Server.
AWS provides 2 features for databases.
Multi-AZ – AWS maintains a copy in another Availability Zone of the primary database. Instance switching can be done to the secondary database in the event of a database failure. The data is replicated synchronously to the standby instance.

If any of these conditions occur, the primary DB instance automatically switches to the standby copy.
A Availability Zone outage
The primary DB instance fails
Change the server type of the DB instance
Software patching is underway for the operating system of the DB instance.
Reboot with failover was used to initiate a manual failover of the DB server instance.
For enhanced availability, operations such as DB instance scaling and system upgrades like OS patching, are performed on standby before an automatic failover. Your availability impact is therefore limited to the time it takes for automatic failover. Amazon RDS Multi-AZ deployments are not designed to failover in the event of database operations like long running queries, deadlocks, or database corruption errors.
Read Replica – This is where you can take a snapshot from the current RDS in AWS. This is a read-only copy that can be used for scaling a database. A Read replica is typically used to offload large amounts of read traffic from an application. If you have an application with a heavy query interface that requires a consistent number of reads, a Read replica can be used. The transactional part of the database can be in the main database, while the reads can occur in the Read replica.
Amazon RDS for MySQL, MariaDB and PostgreSQL allows you to order read replicas.
Other benefits of reading replicas include:
Enhanced security – All traffic between source and destination databases is encrypted.
Amazon RDS for MySQL, MariaDB and PostgreSQL provides a complement to Amazon RDS Multi AZ Deployments. If the source DB instance fails, you can promote a read copy. As part of your disaster recovery strategy, you can also replicate DB instances across AWS regions.
Creating a Multi-AZ Database
Let’s now examine the steps involved in creating a MultiAZ database. We will use AWS’ MySQL database as our example.
Step 1: Log in to the console and then go to the Database->RDS section

Step 2: Next screen, select the MySQL Engine

Step 3: Select the option to host a production database that automatically comes with Multi-AZ.

Step 4: The Multi-AZ Deployment will now be marked as a ‘Yes’ in the DB details.

Click Next to enter a database name, user name, and password.

Step 5: Next, select the VPC. It is a good idea to make sure the database is not accessible to the public.

Accept all default settings and click on Launch DB Instance.

Once the database has been created, you will be able to access the endpoint.

Create a Read Replicate
Let’s now examine the steps involved in creating a Read Replica Database. We will use the MySQL database that was created in the previous steps as our example.
Step 1: Log in to the console and then go to the Database->RDS section

Step 2: Navigate back to the database created in the previous step. Select the Instance Actions, and then click on Create Read Replica.

Step 3: Next, select the instance details that will host the read replica. You must also mention the source database and the provisioned IOPS. Then, you will need to specify the new instance ID for the read replica.

Step 4: You can also choose the region in w

Related Posts

Microsoft Power Platform Functional Consultant (PL-202) Certification – Practice Test Launched

Companies are thriving in a data-reliant world because they have millions of data that is recorded with every global sale. Data is created for a purpose. They…

Microsoft Power Platform App Maker (PL-100) Certification Preparation Guide

The Microsoft Power Platform App Maker Certification (PL-100), helps individuals to develop app-making skills that allow them to create solutions for transforming, automating, or simplifying their respective…

Microsoft Power Automate – Your Complete Guide

It doesn’t matter if you are an IT professional or a business user, it is crucial that you create efficient automated processes to increase productivity with Microsoft…

Knowledge Management

It is important to understand the many sources of information within an organization. Knowledge Management is the process of gathering, organizing and refining information within an organization….

Lori MacVittie: Exclusive Interview with Our Cloud Thought Leader – Know What You Know, and Know What It’s Not – Lori MacVittie

Lori MacVittie serves as the Principal Technical Evangelist for F5 Networks. F5 Networks has been her employer for 14 years. Currently, she focuses on how emerging technologies…

Keys to Effective Project Meetings

Meetings and the agenda that drives them should be organized in priority order. This ensures that the most important stuff gets done and that lower priority items…