🚀 Successfully Deployed RDS MySQL Database on AWS! 🚀

Thrilled to share a recent milestone in my AWS journey! 🌐 I've successfully deployed a MySQL database using Amazon RDS and established seamless data access from an EC2 instance. 🛠️💻

🔍 What's Been Achieved:
- 🚀 Deployed RDS MySQL Database on AWS for efficient and scalable data management.
- 🌐 Established a robust connection from an EC2 instance to the RDS database.
- ✨ Implemented seamless data insertion and deletion processes.

💡 Key Learnings:
AWS has proven once again to be a game-changer in simplifying database management. From the ease of deployment to the seamless connectivity between services, every step was a testament to the power of cloud computing. 🌩️

1. Log in to AWS Console 🖥️

• Navigate to the AWS Management Console and log in with your credentials.

• Open RDS Dashboard 🚪

  • Find the "RDS" service in the AWS Console and click to open the dashboard.

• Click "Create Database" 🌱

  • Hit the "Create Database" button to start the setup process.

• Select Database Engine 🛠️

  • Choose database engine MySQL from the options.

• Specify DB Details 📝

  • Fill in essential details like DB instance identifier, master username, and password.

• Configure DB Instance ⚙️

  • Set up instance specifications, including instance type, storage, and additional configurations.

• Configure Advanced Settings 🔄

  • Tailor advanced settings such as VPC, security groups, and backup preferences based on your needs.

• Add Database Tags (Optional) 🏷️

  • Tag your database for better organization and management.

• Review & Launch 👀

  • Double-check your configurations, then hit "Launch Database."

it will take some time to create the database. after creating the database you will see like this.

Meanwhile, you can create a EC2 instance from where we will access the database.

• Log in to AWS Console 🖥️

  • Head to the AWS Management Console and log in using your credentials.

• Navigate to EC2 Dashboard 🌐

  • Find and open the EC2 service in the AWS Console.

• Choose "Launch Instance" 🚀

  • Click on the "Launch Instance" button to initiate the instance creation process.

• Select an Amazon Machine Image (AMI) 🖼️

  • Choose an AMI Ubuntu

• Choose Instance Type ⚙️

  • Opt for the "t2.micro" instance type, which falls under the AWS Free Tier eligibility.

• Configure Instance Details 🛠️

  • Set parameters like the number of instances, network settings, and other configurations. The default settings work well for a basic setup.

• Add Storage 📦

  • Specify the amount of storage required for your instance. The Free Tier includes a limited amount of storage, but you can adjust as needed.

• Configure Security Group 🔐

  • Create a new security group or choose an existing one to define inbound and outbound rules for network traffic.

• Review Instance Launch 👀

  • Double-check your configurations and click "Launch" when you're ready to proceed.

• Create or Use an Existing Key Pair 🗝️

• Create a new key pair or use an existing one to securely access your EC2 instance.

1. Launch Instance 🚀

   • Click "Launch Instances".

now to establish recheability beetween EC2 and RDS go to RDS and click on the database. under that you will find connected compute resource.

Click on it and add the EC2 instance on here.

after adding the EC2 to the RDS there will a network will work such like VPC.

login to the EC2 in cli and run the command to get into the RDS .

mysql -u admin -h mysql-database.cyesulbcyunz.ap-south-1.rds.amazonaws.com -P 3306 -p