Day 44: Relational Database Service in AWS 🚀

Exploring Amazon Relational Database Service (Amazon RDS) 🚀

Amazon Relational Database Service (Amazon RDS) is like having your own personal database guru in the cloud. It simplifies the task of setting up, operating, and scaling relational databases, allowing you to focus on building your application without worrying about the nitty-gritty details of database management. 🛠️

Task 01: Setting up EC2 and RDS Instances in AWS 🛠️

Step 1: Create an EC2 instance

1. 🚀 Go to the Amazon EC2 console.

2. 🖱️ Click "Launch Instance".

   

3. 🛡️ Choose a Ubuntu AMI.

4. 💻 Choose an instance type, such as t2.micro.

5. 🔗 Choose a VPC and subnet.

6. 🛡️ Configure security group rules to allow inbound traffic on the appropriate port for the type of database you are using (e.g. port 3306 for MySQL).

   

7. 🚀 Launch the instance.

   

Step 2: Create a Free Tier RDS instance of MySQL

1. 🚀 Go to the Amazon RDS console.

   

2. 🖱️ Click "Create database".

   

3. 🗂️ Select "MySQL" as the engine type.

   

4. 🆓 Choose the "Free tier" template for "DB instance class".

   

5. 📛 Enter a unique name for the "DB instance identifier".

   

6. 👤 Set the "Master username" and "Master password" for the database.

   

7. 🌐 Set the "Virtual Private Cloud (VPC)" and "Subnet group" to create the instance in.

8. 🔒 Leave the other settings at their default values.

   

   

9. 🛡️ Select ec2-instance for "VPC security group".

   

   

10. 🚀 Click "Create database" to start the instance creation.

    

11. ✅ Database is created.

    

Step 3: Create an IAM role with RDS access

1. 🚀 Go to the IAM console.

   

2. 🖱️ Click "Roles".

3. ➕ Click "Create role".

   

4. 🔐 Choose the 'AWS service'.

   

5. 🛠️ Choose "Allows EC2 instances to call AWS services on your behalf".

   

6. 📜 Attach the "AmazonRDSFullAccess" policy.

   

7. 📛 Enter a unique name for the role.

   

8. ✅ Click "Create role".

9. ✅ Role is created.

   

Step 4: Assign the role to EC2

1. 🚀 Go to the EC2 console.

   

2. 🔍 Select the instance you just created.

3. 🖱️ Click "Actions", then "Instance Settings", then "Attach/Replace IAM Role".

   

   

   

   Continuing our DevOps, we turn our attention to the enchanting world of WordPress, where our EC2 instance awaits its transformation into a digital canvas for creativity and innovation. Powered by the steadfast reliability of MySQL RDS, our journey takes an exhilarating turn as we embark on the setup of WordPress. 🚀