{"id":2544,"date":"2022-10-09T09:09:56","date_gmt":"2022-10-09T14:09:56","guid":{"rendered":"https:\/\/wiki-cloud.co\/?p=2544"},"modified":"2025-10-08T15:53:22","modified_gmt":"2025-10-08T20:53:22","slug":"deploying-amazon-rds-multi-az-instance","status":"publish","type":"post","link":"https:\/\/wiki-cloud.co\/en\/2022\/10\/deploying-amazon-rds-multi-az-instance\/","title":{"rendered":"Deploying Amazon RDS Multi-AZ Instance"},"content":{"rendered":"

In a previously article<\/a> anterior explicábamos los modelos de despliegue de alta disponibilidad que presenta Amazon RDS llamado Multi-AZ que presenta dos opciones donde se pueden tener una o dos instancias de base de datos en espera que son Multi-AZ DB instance deployment <\/em><\/strong>and clúster de base de datos Multi-AZ <\/em><\/strong>respectively.<\/p>\n

Next, we are going to concentrate on a practical example of the implementation of Multi-AZ DB instance deployment. <\/em><\/strong>The objective of this practical example is to configure the Multi-AZ DB instance schema and we are going to check its functionality by simulating how if there was a failure in the primary database doing a restart and see how the failover is done automatically in the standby database for it this to take the place of the primary.<\/p>\n

<\/p>\n

Image 1 \u2013 Multi-AZ DB Instance Deployment Architecture<\/p>\n

Before starting with the deployment of the RDS database and the configuration of the Multi-AZ deployment model, you must have previously created and configured the VPC with its respective public and private subnets according to the architecture that has been designed.<\/p>\n

For the following practical exercise used the region of Europe (Paris) \/ eu-west-3<\/strong><\/em> that has three availability zones and where the VPC that comes by default for this region will be used, later during the creation and configuration of the Amazon RDS instance the respective subnets will be created.<\/p>\n

<\/p>\n

Create and Configure Amazon RDS Multi-AZ instance<\/strong><\/span><\/p>\n

We will proceed to search in the AWS Management Console the RDS service and then start the process of creating and configuring the Amazon RDS DB instance by enabling the Multi-AZ scheme.<\/p>\n

<\/p>\n

We select the standard create option which allows us to set configuration options including the Multi-AZ deployment model option.<\/p>\n

<\/p>\n

In this example we are going to select the MySQL database engine to create our instance and select the latest version available in production.<\/p>\n

<\/p>\n

Now in the templates we select the production that already brings us default values for high availability.<\/p>\n

<\/p>\n

The next step is to define the name of the database instance and we configure a master user with its respective password, complying with the parameters defined by the AWS management console.<\/p>\n

<\/p>\n

The next step is to select the type of instance for the database that includes the number of vCPUs, RAM, and network. For this practice exercise, I selected the instance with the fewest features.<\/p>\n

<\/p>\n

Now we select the storage where our data will be hosted, where we specify the type of disk, its capacity in GiB and the amount of IOPS and if we want our storage to have auto scaling (optional).<\/p>\n

<\/p>\n

Now comes the most important step of this practical exercise and it is the availability and durability part, where we select the Multi-AZ deployment model that is recommended for production scenarios, in this case a standby instance will be created in another availability zone in the region we have selected (Europe \u2013 Paris \/ eu-west-3).<\/p>\n

<\/p>\n

Finally, we configure the connectivity part, where in this case we select the option to connect to an EC2 instance that was the one that we previously created and we select the VPC that is created by default for this region and we add a new security group for the database enabling port 3306 that will serve us for connectivity tests.<\/p>\n

<\/p>\n

I leave the following options by default and click on the \u201cCreate Database\u201d button.<\/p>\n

<\/p>\n

<\/p>\n

Once our Amazon RDS (MySQL) database instance has been created, we will also have our subnets and our EC2 instance created to do the respective connectivity tests. It is important to copy the Endpoint that will be used to configure the connection string to our database instance.<\/p>\n

<\/p>\n

<\/p>\n

Connection and testing Amazon RDS Multi-AZ instance<\/strong><\/span><\/p>\n

For the part of the connection tests and verification of the Multi-AZ deployment model, we are going to start with the part of the connectivity tests from an EC2 instance (Linux) and later we are going to simulate a failure to verify that the Multi-AZ deployment model and the replication works correctly.<\/p>\n

The first step is to connect to the EC2 instance that we have created and configured. In my case I will connect through Putty<\/a> pero también lo podemos hacer directamente desde la consola de administración de AWS.<\/p>\n

<\/p>\n

Next we are going to run the following command on our EC2 Linux instance to download the updated package lists from the repositories in order to get information about the latest versions of the packages and their respective dependencies.<\/p>\n\n\n\n

sudo apt-get update<\/pre><\/div>\n\n\n\n
Now going to install the MySQL client on our EC2 instance to connect to the Amazon RDS (MySQL) instance that we have already created and configured and where we will run some commands to interact with a database and verify the replication. During the execution of the following command, the system asked if we want to continue and we type \u201cY\u201d and the \u201cEnter\u201d key to continue with the process.<\/p>\n\n\n\n
sudo apt-get install default-mysql-client<\/pre><\/div>\n\n\n\n
Once the MySQL client is installed, the next step will be to connect to our Amazon RDS instance and we will do it through the following command where we put the Endponit that provides us with the Amazon RDS configuration that appears in the AWS management console.<\/p>\n\n\n\n
mysql -h project-db.cmklzpffazxt.eu-west-3.rds.amazonaws.com -u admin -P 3306 -p<\/pre><\/div>\n\n\n\n
<\/p>\n
Next, we are going to run a series of commands to the MySQL database engine to create a database, create a table, and insert some sample data.<\/p>\n\n\n\n
SHOW DATABASES;<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
CREATE DATABASE Company;<\/pre><\/div>\n\n\n\n
SHOW DATABASES;<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
USE Company;<\/pre><\/div>\n\n\n\n
SHOW TABLES;<\/pre><\/div>\n\n\n\n
CREATE TABLE Employees (\n\u00a0 employeeId int(11) NOT NULL,\n\u00a0 lastName varchar(50) NOT NULL,\n\u00a0 firstName varchar(50) NOT NULL,\n\u00a0 jobTitle varchar(50) NOT NULL,\n\u00a0 city varchar(20) NOT NULL,\n\u00a0 country varchar(10) NOT NULL\n);<\/pre><\/div>\n\n\n\n
SHOW TABLES;<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
INSERT INTO Employees (employeeID, lastName, firstName, jobTitle, city, country) VALUES (1002,'Murphy','Diane','President', 'Seattle','United States');\nINSERT INTO Employees (employeeID, lastName, firstName, jobTitle, city, country) VALUES (1056,'Patterson','Mary','VP Sales', 'London','England');\nINSERT INTO Employees (employeeID, lastName, firstName, jobTitle, city, country) values (1102,'Bondur','Gerard','Sales Manager EMEA', 'Berlin','Germany');\nINSERT INTO Employees (employeeID, lastName, firstName, jobTitle, city, country) values (1567,'Castillo','Paola','Sales Rep', 'Madrid','Spain');<\/pre><\/div>\n\n\n\n
SELECT * FROM Employees;<\/pre><\/div>\n\n\n\n
<\/p>\n
Now we do is execute a command at an interval of every 5 seconds to find out the IP address of the (primary) database that is responding to the requests that an application would make.<\/p>\n\n\n\n
while true; do host project-db.cmklzpffazxt.eu-west-3.rds.amazonaws.com; sleep 5; done<\/pre><\/div>\n\n\n\n
<\/p>\n
To verify that the failover is done, we do is a reboot to the Amazon RDS DB instance from the AWS Management Console.<\/p>\n
<\/p>\n
<\/p>\n
After the Amazon RDS primary database is restarted, the standby database that contains the replica of the data takes its place to become the primary and begins serving incoming requests.<\/p>\n
<\/p>\n
Finally, we check the Amazon RDS (MySQL) instance events in the AWS Management Console to verify that it has made the failover and the Multi-AZ deployment model has been applied.<\/p>\n
<\/p>\n
I hope this information is useful.<\/p>\n
Best Regards,<\/p>\n\n\n\n
Share:<\/strong><\/p>\n\n\n\n