Article

Create a MySQL RDS from Scratch

March 31, 2020

Introduction

This article describes how to create an RDS MySQL instance from scratch using the AWS console. It also describes some of the properties required to obtain a functional instance.

Objective

Create a MySQL instance from scratch on Amazon Web Services (AWS) using RDS.

Pre-requisite

  • You will need to get an account at AWS
  • Basic knowledge of AWS services

Steps to create a MySQL RDS Instance

Before starting, consider the following points:

  • We will use the default VPC, so we don’t need to setup one
  • Following the best practices, the RDS instance must not publicly accessible but for the purposes of this article it will be created public

1. Database Creation Method and Engine Version

Go to AWS console and navigate to RDS service, from the left panel select the “Databases” option and tap on the “Create database” button, then the create database page should be displayed. Leave the “Standard Create” option chosen and change to MySQL as the engine.

09_0

For the engine version, we will work with the 8.0.16 but if you need a specific version for compatibility reasons feel free to change it. Next, dropdown the “Version” options and choose “MySQL 8.0.16”

art-2

2. Template

Depending on the chosen option, in the next section, the default settings will be shown. To continue, select the “Dev/Test” option.

art-3

3. Settings

Specify the following properties:

 

  • DB instance identifier: Set name to identify the DB instance
  • Master username: A username that will be used to connect to the DB instance
  • Auto-generate a password: Disable the option
  • Master password: Choose a password to the user-specified above
  • Confirm password: Retype the password
art-4

4. DB instance size and Storage

According to the computational, network, and memory capacity of the DB instance, select the “Burstable classes (includes t classes)” option and choose “db.t2.micro”. For the storage section, we can leave the default values.

art-5art-6

5. Availability & durability

The “Multi-AZ deployment” option helps to maintain a synchronous standby replica in a different Availability Zone, nevertheless, for the purpose of this article select "Do not create a standby instance".

art-7

6. Connectivity

In the “Virtual Private Cloud (VPC)” choose the Default VPC and drop down “Additional connectivity configuration” options:

  • Subnet group: The DB subnet group for the VPC, select the Default option
  • Publicly accessible: Choose “Yes”
  • VPC security groups: Create a new VPC security group
  • New VPC security group name: Choose a name to identify the new security group
  • Availability zone: Select “No Preference”
  • Database port: The port that will be used for connection to the DB. Leave in the default value “3306”
art-8

7. Database authentication

We use the password created in step 3 as an authentication method, thus selecting the “Password authentication” option.

art-9

The “Additional configuration” section can stay as default.

8. Create Database

One more time review the RDS instance configuration and once validated tap on “Create database” button, the instance creation process will immediately run and after a few minutes it should be ready.

art-10

Now is possible to connect to the database through a MySQL client, just use the generated endpoint as the "host" in the process of creation of the database, as well as the username and password.

art-11

Conclusion

In this article, we showed how to create an RDS instance from zero in AWS, where we have great advantages such as automatic backups, security, performance, high availability, vertical and/or horizontal scaling. In addition, AWS offers simplicity to create different types of database instances (Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle Database, and SQL Server).

In future articles, we will cover more complex scenarios like securing the network access to the RDS database using Security Groups, improving network latency and security communication with VPC endpoints, and how to take advantage of a multi-AZ setup.

 

How can we help you?

IO Connect Services is here to help you by offering cost-effective, high quality technology solutions.