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.
https://d0.awsstatic.com/training-and-certification/docs-sa-pro/AWS_certified_solutions_architect_professional_blueprint.pdf

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