Day 44: Relational Database Service in AWS ๐Ÿš€

Day 44: Relational Database Service in AWS ๐Ÿš€

ยท

3 min read

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. ๐Ÿ› ๏ธ

AWS Training - Amazon Relational Database Service (RDS) in Germany Berlin,  Munich, Frankfurt

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. ๐Ÿš€

Did you find this article valuable?

Support Nilkanth Mistry by becoming a sponsor. Any amount is appreciated!

ย