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 on 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 “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 by 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 showing. 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 with the computational, network, and memory capacity of the DB instance, select the “Burstable classes (includes t classes)” option and chose “db.t2.micro”. For the storage section we can leave the default values.

art-5art-6

5. Availability & durability

The “Multi-AZ deployment” option help 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 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 conenction to the DB. Leave in the defaul value “3306”
art-8

7. Database authentication

We use the password created in the step 3 as authentication method, thus select “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 oce 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.

 

INSIGHTS

Recommended

News
Announcing New Salesforce Commerce Cloud Partnership
News
IO Connect Services Achieves AWS Well-Architected Partner Status
Video
Monitoring Mule® Applications with Datadog
News
IO Connect Services Announces CloudWatch Mule® Integration

How can we help you?

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