Table of contents
- Day 44: Relational Database Service in AWS
- Task-01
- Create a Free tier RDS instance of MySQL
- 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.
- Post the screenshots once your EC2 instance can connect to a MySQL server
- Hint: You should install the mysql client on EC2, and connect the Host and open Port(3306) of RDS with this client.
- Day 44 task is complete!
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
- 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.
mysql -h [Endpoint] -u [Username] -p [DatabaseName]
mysql -h my-database.cxtd1comdmzm.us-east-1.rds.amazonaws.com -u Admin -p chaitannyaa
Post the screenshots once your EC2 instance can connect to a MySQL server
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👇