RDS Multi-AZ Configuration

Posted On: 2023-03-26 16:37:36 AWS

  1. Create new VPC "RDSVPC" with CIDR block is "10.10.0.0/16"
  2. Create new IInternet Gateway "RDSIGW"
  3. Attach RDSIGW to newly created VPC RDSVPC
  1. Create public subnet "rds-pub-subnet"  with CIDR block is "10.10.0.0/24" 
  2. Create route table "rds-rt-public" under "RDSVPC"
  3. Add route IGW "RDSIGW" to route table "rds-rt-public"
  4. Go to subnet association and select public subnet "rds-pub-subnet"

 

  1. Create private subnet "rds-pri-master-subnet" with CIDR block is "10.10.1.0/24"
  2. Create private subnet "rds-pri-replica-subnet" with CIDR block is "10.10.2.0/24"
  3. Create route table "rds-rt-private" under "RDSVPC"
  4. Go to subnet association and select private subnet's "rds-pri-master-subnet" & "rds-pri-replica-subnet"

 

  1. Create Subnet group rdsvpc-db-subnet-group under rdsvpc
    add : rds-pri-master-subnet" with CIDR block is "10.10.1.0/24

Add: rds-pri-replica-subnet" with CIDR block is "10.10.2.0/24

  1. Create security group in EC2  name is "rds-sg" with ports "mysql/aurora" port no -3306, source = 0.0.0.0/0
  2. Create RDS instance
  3. Create EC2 instance
  4. Connect EC2 instance with putty
  5. Run below command to install mysql client on EC2 instance

sudo yum install mysql

mysql -h database-3.ccz45nrif50w.ap-south-1.rds.amazonaws.com -u admin -p

Or

mysql -h database-1.cu2ro811v87t.ap-south-1.rds.amazonaws.com -p 3306 -u admin -p

 

show databases;

Create database: create database mydb1;

Enable database: use mydb1;

 Create some tables in database

 create table awsrdsdemo (name VARCHAR (30) , batch INT (2) , phone VARCHAR (10) , email  VARCHAR (30)) ;

Insert the data in table

 insert into awsrdsdemo values ('mahesh naidu', 9, '7799466664', 'cloudtechnet@gmail.com');

 Select * from awsrdsdemo

 Forcefully stop the connection to Master database server ?

 while true; do host database-1.crjchcfb33nv.ap-south-1.rds.amazonaws.com ; sleep 3; done