AWS RDS

Credits Educative.io

Before we can start working with RDS, we’ll have to set up other resources that are required while creating an RDS DB instance. The first of those resources is VPC (virtual private cloud). An RDS DB instance must be created inside a VPC. This is to enhance security and provide network isolation.

When setting VPC name will autotag -vpc. Set “Number of Availability Zones (AZs)”. “None” for the “VPC” endpoints.

Now we create RDS, from the “Templates” section, select the “Dev/Test” option because it’ll allow you to select the deployment options. Choose: “Single DB instance”, “Multi-AZ DB instance”, or “Multi-AZ DB cluster” Burstable classes (includes t classes) We can now check the status of the RDS using EC2 instance:

chmod 400 usercode/RDS-client-key-pair.pem
ssh -i usercode/RDS-client-key-pair.pem ubuntu@{public-ipv4-address}
sudo apt update
sudo apt install mysql-client-core-8.0
mysql -h {endpoint} -P 3306 -u admin -p
aws rds describe-db-instances --db-instance-identifier mysql8