How To Deploying and Covert a Secure Multi-AZ RDS Instance

What is Amazon RDS?

Amazon RDS is a managed database service that simplifies setting up, operating, and scaling databases by handling administrative tasks and infrastructure management.

Optimizing Amazon RDS Multi-Availability Zones (AZ) to Improve Redundancy.

The RDS Multi-AZ feature enhances availability and durability by replicating data across multiple Availability Zones. (I’ll explain Availability Zones in another post)

Simple Step by Step deploying into Multiple AZ’s.

This simple step by step will walk you through how to create and deploy your RDS resource.

Step 1. In the AWS console search bar, type RDS and select it.

Step 2–5. Click Create database. Under Database creation method, choose Standard create. Under Engine options, select PostgreSQL. Under Templates, select Dev/Test.

Step 6–9. For Availability and durability, choose Single DB instance. Enter secure-db as the DB instance identifier. Set a master password of your choice.

Step 10–11. Under Instance configuration, choose Burstable classes (includes t classes) → db.t3.medium. For Storage type, select General Purpose SSD (gp2).

Step 12–13. Under VPC security group (firewall), choose Create new. Name it RDSSecurityGroup.

Step 13–14. Scroll down and click Create database. Wait for the database status to become Available.

Step 15–18. In the Databases list, select your instance secure-db. Wait for the status to change from Modifying to Available.

Click Actions → Convert to Multi-AZ deployment.

In the pop-up, select Apply immediately → Convert to Multi-AZ.

Step 19–25. Under Connectivity & security, click the VPC security group link (opens in new tab). Select the Inbound rules tab. Click Edit inbound rules. Delete the existing rule.

Click Add rule → Under Type, choose PostgreSQL.

Delete existing rule for tutorial.

Under Source, choose the “cfst-”… security group. Click Save rules.

Step 26–29. Back in the RDS console, copy the Endpoint (it ends with rds.amazonaws.com).

Lastly, from your terminal, connect to your RDS instance using:psql -U postgres -h <ENDPOINT_LINK>.Enter the password you created. You should see the postgres=> prompt confirming a successful connection.