Welcome to our blog! In this tutorial, we will walk you through creating an Amazon RDS instance on AWS. This guide is based on our YouTube video, ensuring you can follow along easily. Let’s get started!

Prerequisites

Before we begin, ensure you have:

An AWS account
Basic knowledge of AWS services
Permissions to create an RDS instance

Step 1: Access the RDS Service

  1. Log in to your AWS Management Console.

In the search bar, type RDS and click on it.
Select Databases from the left menu.
If no database instance exists, click on Create Database.

Step 2: Choose the Database Creation Method

AWS provides two options:

  • Standard Create: Allows manual configuration of security, availability, and backups.

  • Easy Create: Uses AWS best practices for configuration.

For this tutorial, we will use Standard Create to customize settings.

Step 3: Select a Database Engine

AWS RDS supports multiple database engines:

  • MariaDB

  • MySQL

  • PostgreSQL

  • Oracle

We will create a MySQL instance using version 8.0.30.

Step 4: Choose a Template

AWS offers different templates:

  • Free Tier (limited resources, best for learning)

  • Production

  • Dev/Test

For this tutorial, we will use the Free Tier.

Step 5: Configure Instance Settings

  1. Database Instance Identifier: Enter a unique name (e.g., RDS).

  2. Master Username: Set a username (e.g., admin).

  3. Master Password: Choose a strong password (must include uppercase and numeric characters).

  4. Instance Configuration:

    • 2-core CPU

    • 1GB RAM

    • Step 6: Set Storage Options

      1. Allocated Storage: Default is 20GB (adjust if needed).

      2. Enable Storage Auto-scaling: Allows automatic expansion when usage reaches the threshold.

    • Step 7: Configure Connectivity

      • VPC Selection: Choose Default VPC (or configure a custom one later).
      • Subnet Group: Use Default Subnet.
      • Public Access: Enable for external connections (not recommended for production).
      • Security Group: Select or create a security group. Here, we are using an existing security group for an EC2 instance.
      • Availability Zone: Select any preferred zone.
      • Authentication Mode: Use Password Authentication.
      • Step 8: Create the Database
        • Review your settings.
        • Click Create Database.
        • The instance status will show Creating—this process may take a few minutes

        • Step 9: Open the MySQL Port (3306)

        • To allow remote connections, ensure port 3306 is open:

        • Go to Security Groups in AWS.
        • Click on the associated Security Group.
        • Select Inbound Rules and check if port 3306 is open.
        • If not open, click Edit Inbound Rules, add port 3306, and save changes
        • Step 10: Connect to the RDS Instance

      3. Once the instance is Available:

      4. Copy the Endpoint from the RDS dashboard.
      • mysql -h your-endpoint -u admin -p
  5. Use a MySQL client (e.g., MySQL Workbench, SequelPro, or CLI):

      3. Enter your password and verify the connection.