Creating your first Amazon RDS DB instance

Amazon RDS simplifies the process of setting up and managing relational databases in the cloud. This walkthrough guides you through creating your first DB instance. By the end, you'll understand how to configure and manage your RDS DB instance.

Creating your first DB instance

A DB instance in Amazon RDS is the foundational building block for running a managed relational database in the cloud. This section helps you set up your first RDS DB instance.

Console

This tutorial walks you through the steps to create a simple RDS for MySQL DB instance using the Easy create option. For comprehensive instructions to create a production DB instance, see Creating an Amazon RDS DB instance in the Amazon RDS User Guide.

To create a DB instance using Easy create

1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

2. Choose Create database.

   

3. For the creation method, choose Easy create. This method simplifies database provisioning by automatically configuring settings such as instance class, storage type, and networking settings.

   

4. In this tutorial, we create a MySQL DB instance. For Engine type, choose MySQL.

   MySQL is a good starting point because it's open-source, cost-effective, and widely supported by the development community. For a full list of supported database engines, see Choosing your database engine for Amazon RDS.

5. For DB instance size, choose Free tier. This option lets you complete the tutorial without incurring costs, so it's ideal for learning and experimentation. If your usage exceeds the free tier limits or you select resources not covered by the free tier, you're billed at the listed hourly rate.

   

6. (Optional) For DB instance identifier, enter a name for the DB instance. Alternately, keep the name that Amazon RDS generates for you.

7. For Credentials management, select Self-managed. This option lets you manage your own master user credentials.

   

8. For Master password, enter a password for the master user and confirm the password.

9. Expand View default settings for Easy create and review the settings that Amazon RDS automatically configures for you. You can modify some settings, such as public access and the engine version, after you create the DB instance.

10. Choose Create database.

    The database appears in the Databases list with a status of Creating. When the status changes to Available, the DB instance is ready to use.

AWS CLI

The following command creates a simple RDS for MySQL DB instance using the AWS CLI. The command replicates the Easy create option from the RDS console, which default settings for development and experimentation. For production-ready configurations, see Creating an Amazon RDS DB instance in the Amazon RDS User Guide.

First, install and configure the AWS CLI. For instructions, see Installing or updating to the latest version of the AWS CLI in the AWS Command Line Interface User Guide.

Then, run the following command:

aws rds create-db-instance \
  --db-instance-identifier my-db-instance \
  --db-instance-class db.t4g.micro \
  --engine mysql \
  --master-username my-username \
  --master-user-password my-password \
  --allocated-storage 20 \
  --no-publicly-accessible \
  --backup-retention-period 7 \
  --storage-type gp2 \
  --engine-version 8.0.39

Replace the placeholders values for the instance identifier, username, and password with your own values.

Other important settings

Although the Easy create option simplifies the process of creating a DB instance, using the Standard create workflow offers more control and customization over your DB instance configuration. Consider the following important settings when you create a production DB instance.

Topics

• Storage allocation

• Instance class

• Public access

Storage allocation

In the Standard create workflow, you must specify the amount of storage for your DB instance. The type of storage, such as General Purpose SSD, Provisioned IOPS, or Magnetic, and the allocated size directly affect your database performance and cost.

• For most workloads, General Purpose SSD provides a balance between cost and performance.

• High-performance transactional applications benefit from Provisioned IOPS SSD.

For more information, see Amazon RDS DB instance storage in the Amazon RDS User Guide.

Instance class

The instance class determines the allocated compute and memory capacity for your database. Selecting the right class depends on factors such as the expected workload, query volume, and application requirements.

• Standard classes are ideal for general-purpose workloads.

• Memory-optimized classes are best for applications that require high memory throughput.

• Burstable classes work well for applications with intermittent workloads.

For detailed guidance, see DB instance classes in the Amazon RDS User Guide.

Public access

Public access controls whether users or applications can access your DB instance from outside the VPC. This setting is critical for managing connectivity and security.

• Enable public access to make your database accessible from external networks, such as for web applications or remote access. Configure security group rules to restrict unwanted access.

• Disable public access for internal applications or enhanced security, limiting connectivity to instances within your VPC.

For more information about configuring public or private access and related network settings, see Working with a DB instance in a VPC in the Amazon RDS User Guide.

Next steps

Now that you created your first RDS DB instance, the next step is to make sure that it's secure. Proper security configurations help protect your database and its data from unauthorized access.

In the next section, you'll learn about the following:

• Setting up public or private access.

• Configuring security groups and network settings.

• Managing database authentication and access controls.

Next step: Securing your Amazon RDS DB instance