Table of contents
Amazon Relational Database Service (Amazon RDS) is a collection of managed services that makes it simple to set up, operate, and scale databases in the cloud
Task-01
Create a Free tier RDS instance of MySQL
Create an EC2 instance
Create an IAM role with RDS access
Assign the role to EC2 so that your EC2 Instance can connect with RDS
Once the RDS instance is up and running, get the credentials and connect your EC2 instance using a MySQL client.
Let’s begin with task 1
Steps to Create RDS Instance of MySQL
Login to AWS Console and search for "RDS".
Click on "RDS" and navigate to the RDS dashboard.
Create a database using the "Standard create" method and select "MySQL" under Engine options.
Select "Free Tier" under Templates.
Configure settings:
DB instance identifier: mydatabase-1
Master username: manager
Provide a password
Configure additional settings like storage, backups, VPC, and security groups.
Review and create the database. This process may take a few minutes.
Create an EC2 instance named RDS.
Configure the security group to allow inbound traffic on the MySQL port (default is 3306).
Create an IAM role with RDS access and assign it to the EC2 instance.
Click on create role
Copy the RDS instance endpoint and other details.
Connect to the EC2 instance using SSH.
Install the MySQL client on the EC2 instance:
sudo apt-get update
sudo apt-get install mysql-client
mysql --version
- Connect to the RDS instance using the MySQL client:
mysql -h <RDS_ENDPOINT> -P <RDS_PORT> -u <MASTER_USERNAME> -p
Thankyou for reading !!!!!