Create an RDS Instance with Multi-AZ Deployment and Read Replica

1. Create an RDS Instance with Multi-AZ Deployment

Step 1: Sign in to the AWS Management Console

• Open the AWS Management Console and sign in with your credentials.

Step 2: Navigate to RDS

• In the AWS Management Console, type RDS in the search bar and select RDS under "Services."

Step 3: Create a New Database

• Click on Create database.
• Choose a database creation method. You can select either:
  • Standard Create: Offers more configuration options.
  • Easy Create: AWS sets up the RDS instance with default settings (not recommended for production).

Step 4: Select the Database Engine

• Choose a database engine (e.g., MySQL, PostgreSQL, MariaDB, etc.).
• Select the version of the database engine.
  

Step 5: Configure Database Settings

• DB Instance Identifier: Provide a name for your DB instance.
• Master Username: Enter a username for the database administrator.
• Master Password: Set a strong password and confirm it.

Step 6: Choose Instance Specifications

• Under DB instance size, select the appropriate instance class (e.g., db.t3.xLarge).

• Choose Multi-AZ deployment by checking the box. This option creates a standby instance in a different Availability Zone for failover.

Step 7: Storage Configuration

• Set the storage type (e.g., General Purpose (SSD)).

• Choose the Allocated storage (e.g., 20 GiB).

• Enable Storage Auto-scaling if needed.

• Ensure Enable automated backups is checked.

  • Retention period: Choose how long backups should be retained (e.g., 7 days).

Step 9: Additional Configuration

• Initial Database

• Monitoring

• Enable Encryption if needed.

Step 10: Launch the RDS Instance

• Review your settings and click Create database.

• The RDS instance will take a few minutes to be provisioned with Multi-AZ deployment.

2. Create a Read Replica

Step 1: Navigate to the RDS Console

• In the RDS dashboard, locate your primary RDS instance under Databases.

Step 2: Create a Read Replica

• Click on the Actions dropdown menu next to your primary instance and select Create read replica.

Step 3: Configure the Read Replica

• DB Instance Identifier: Provide a unique name for the read replica.
• Source DB Instance: Your primary instance should already be selected.
• Multi-AZ Deployment: Choose whether you want Multi-AZ for the read replica.
• Instance specifications: Select the instance class and storage as needed.

Step 5: Launch the Read Replica

• Review your settings and click Create read replica.
• The Read Replica will take a few minutes to be created.

By following these steps, We have successfully created an RDS instance with Multi-AZ deployment, automated backups, and a Read Replica. This setup ensures high availability, durability, and scalability for our database workloads.