Day 44: Relational Database Service in AWS

Welcome to another exciting day of exploring AWS services. Today, we'll delve into the process of seamlessly integrating an RDS instance with an EC2 instance in AWS.

In this blog post, we'll walk through each step, from creating a Free Tier RDS instance of MySQL to connecting an EC2 instance using a MySQL client. Let's get started

Task-01: Integrating RDS and EC2 Instances

Step 1: Create a Free Tier RDS Instance of MySQL

To begin, let's set up an RDS instance of MySQL using the AWS Management Console. Here's how you can do it:

1. Log in to the AWS Management Console.

2. Navigate to the RDS service.

   

3. Click on "Create database" to start the instance creation wizard.

   

4. Choose "MySQL" as the database engine and select the version that suits your requirements. we will be using PostgreSQL

   

5. Configure the instance details, including instance specifications, storage options, and database settings.

6. Set up the master username and password for your MySQL database.

   

7. Configure the networking options and security groups.

   

   

8. Review your settings and Create the RDS instance.

   

   Step 2: Create an EC2 Instance

   I hope till now you have mastered in creating instance of EC2

   

   Step 3: Create an IAM Role with RDS Access

   1. Navigate to the IAM service in the AWS Management Console.
   2.Click on "Roles" and then "Create role".

   

   1. Choose the EC2 service as the trusted entity.

      

   2. Attach the appropriate policies that grant RDS access to the role.

      

   3. Review your settings and create the IAM role.

      

Step 4: Assign the IAM Role to the EC2 Instance

1. Go to the EC2 dashboard in the AWS Management Console.

2. Select the EC2 instance you created in Step 2.

3. Click on "Actions" and then "Security".

   

4. Choose "Modify IAM role" and select the IAM role created in Step 3.

   

5. update IAM role

Step 5: Connect the EC2 Instance to the RDS Database Using a MySQL Client

1. Retrieve the credentials for your RDS instance from the RDS dashboard.

2. SSH into your EC2 instance using a terminal or SSH client.

3. Install a MySQL client on your EC2 instance.

   

4. Use the MySQL client and the RDS credentials to connect to the RDS instance.

   

That's it! You have successfully connected your RDS and EC2 instances. Now you can leverage the power of this integration for your applications and databases.

If you have any queries/suggestions please write a comment below. See you another day with another challenge.