Swiftorial Logo
Home
Swift Lessons
AI Tools
Learn More
Career
Resources

AWS RDS Basics

What is Amazon RDS?

Amazon Relational Database Service (RDS) is a managed relational database service that provides six familiar database engines to choose from, including Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle Database, and SQL Server. RDS makes it easy to set up, operate, and scale a relational database in the cloud.

Key RDS Concepts

  • DB Instances: The basic building blocks of Amazon RDS. A DB instance is an isolated database environment in the cloud.
  • DB Snapshots: Backup copies of your DB instances.
  • DB Parameter Groups: A collection of engine configuration values that can be applied to one or more DB instances.
  • Multi-AZ Deployments: Provide enhanced availability and durability for RDS instances, making them suitable for production workloads.
  • Read Replicas: Enable you to elastically scale out beyond the capacity constraints of a single DB instance for read-heavy database workloads.

Creating an RDS Instance

To create an RDS instance:

  1. Sign in to the AWS Management Console.
  2. Navigate to the RDS Dashboard.
  3. Click "Create database".
  4. Select the database creation method. For this example, choose "Standard Create".
  5. Choose a database engine. For this example, select "MySQL".
  6. Choose the "Free tier" template if eligible, or select your instance specifications.
  7. Configure the database settings, including DB instance identifier, master username, and master password.
  8. Configure the instance specifications, such as instance class, storage type, and allocated storage.
  9. Configure the connectivity settings, including VPC, subnet group, and public access if needed.
  10. Configure additional settings, such as backups, monitoring, and maintenance preferences.
  11. Review your settings and click "Create database".

Connecting to Your RDS Instance

After creating your RDS instance, you need to connect to it:

  1. Sign in to the AWS Management Console.
  2. Navigate to the RDS Dashboard.
  3. Select the database instance you created.
  4. Find the "Endpoint" value in the instance details. This is the address you will use to connect to the database.
  5. Use a database client or command-line tool to connect to the database using the endpoint, master username, and password.

Example: Creating and Connecting to a MySQL RDS Instance

Let's create and connect to a MySQL RDS instance:

Step-by-Step Example:

  1. Sign in to the AWS Management Console.
  2. Navigate to the RDS Dashboard and click "Create database".
  3. Select "Standard Create" and choose "MySQL" as the engine.
  4. Select the "Free tier" template. Click "Next".
  5. In the "Settings" section, enter a DB instance identifier, such as "mydbinstance". Set the master username to "admin" and create a password.
  6. In the "DB Instance Size" section, choose "db.t2.micro" for the instance class.
  7. In the "Storage" section, choose the default settings.
  8. In the "Connectivity" section, choose your VPC and set "Publicly accessible" to "Yes" if you want to connect from outside the VPC. Choose an existing security group or create a new one to allow inbound traffic on port 3306 (the default MySQL port).
  9. In the "Additional configuration" section, you can set backup retention, enable Enhanced monitoring, and set maintenance preferences. Click "Create database".
  10. Once the instance is created, go to the RDS Dashboard and select your instance. Note the "Endpoint" value.
  11. Use a MySQL client or command-line tool to connect to the database: 
    mysql -h your-endpoint -P 3306 -u admin -p

Managing RDS Instances

You can manage your RDS instances using the AWS Management Console, AWS CLI, or RDS API. Common management tasks include:

  • Modifying an Instance: Change instance class, storage type, security groups, and other settings.
  • Backing Up and Restoring: Create manual snapshots or restore from automated backups.
  • Monitoring Performance: Use Amazon CloudWatch to monitor performance metrics and set alarms.
  • Scaling Storage and Instance Size: Increase storage capacity or change the instance class to handle more load.
  • Setting Up Multi-AZ Deployment: Enhance availability by deploying standby instances in different Availability Zones.

Conclusion

Amazon RDS simplifies the setup, operation, and scaling of a relational database in the cloud. By understanding the basics of RDS, including how to create, connect, and manage instances, you can effectively utilize AWS's managed database services for your applications.