Day44 ----> 90DaysOfDevOps Challenge @TWS

Day44 ----> 90DaysOfDevOps Challenge @TWS

Day 44: Relational Database Service in AWS

🗄️ 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

With RDS, you can choose from various popular relational database engines such as MySQL, PostgreSQL, Oracle, SQL Server, and Amazon Aurora. RDS handles administrative tasks such as hardware provisioning, database setup, patching, backups, and automated software updates, allowing you to focus on your application development rather than managing the underlying infrastructure.

Task-01

  • Create a Free tier RDS instance of MySQL

image

image

image

image

image

image

image

image

image

image

image

image

  • Create an EC2 instance

image

  • Create an IAM role with RDS access

image

image

  • Assign the role to EC2 so that your EC2 Instance can connect with RDS

image

image

  • Once the RDS instance is up and running, get the credentials and connect your EC2 instance using a MySQL client.

mysql -h [Endpoint] -u [Username] -p [DatabaseName]
mysql -h my-database.cxtd1comdmzm.us-east-1.rds.amazonaws.com -u Admin -p chaitannyaa

image

image

  • Post the screenshots once your EC2 instance can connect to a MySQL server

image

Hint: You should install the mysql client on EC2, and connect the Host and open Port(3306) of RDS with this client.

Happy Learning:)

Day 44 task is complete!

90DaysOfDevOps Tasks👇

github.com/Chaitannyaa/90DaysOfDevOps.git

Chaitannyaa Gaikwad | LinkedIn