AWS

How to set up MySQL server on AWS RDS

Learn to configure MySQL server on AWS RDS.

· 4 min read
How to set up MySQL server on AWS RDS

Hello everyone, In this article, I'll be discussing how we can set up a MySQL server on AWS Relational Database Service (RDS).

So let's begin with the process.

Open RDS

Open the RDS console in AWS. To open RDS just search for it & click on the first result you find. Just like the image below.

On opening, it will look something like this.

Now click the "Create database" button (marked in the above image) to start creating the database.

Configure MySQL Database Server

On opening the RDS "Create Database" Screen, a form will which will look like this.

So let's start the actual configuration.

Database creation mode & Engine Options

In "Choose a database creation method" you can choose either -

  1. Standard Create - In this you have the option to configure the database server as per your requirements. This option gives you more freedom to choose as per your requirement.
  2. Easy Create - In this, the database server is already configured by AWS. You just have to put the basic details to create a database server.

In "Engine Options" you can choose your preferred DB engine. Here in this article, I am using a MySQL server.

As of Oct 2021, these engines are present -

  1. Amazon Aurora
  2. MySQL
  3. MariaDB
  4. PostgreSQL
  5. Oracle
  6. Microsoft SQL Server

DB Instance Settings

The above screenshots show how we can set up/choose the basic details of our DB server.

MySQL Version

In this option, you can choose the MySQL version as you preferred.

Templates

In this, you can choose templates for your server configuration. Simply the type of instance you wanted for your server. This option sets the ranges of the instance types.

  1. Free Tier - In this option, you can only choose t2.micro instance for your server.
  2. Dev/Test - In this option you can choose instances from M, R, X & T classes.
  3. Production - In this option, you can choose instances from M, R, X & T classes suitable for the production environment.
Settings

Here you can set your database name & password. You can also opt to auto-generate passwords.

DB Instance Class & Storage

DB Instance class

Here you can choose the DB instance class based on what template you have chosen above.

Storage

In the section, you can set the storage of your DB Server. You can also enable auto-scaling. Enabling this feature will allow the storage to increase once the specified threshold is exceeded.

Public Accessible

In connectivity settings, you can see the option title "Public access". By default, the public access to the DB server is blocked. So to enable public access just check the "Yes" option.

This is the basic configuration we have to do to launch a MySQL DB Server in AWS. You can leave all options with their default values.

AWS also shows you the estimated monthly cost of your server as per the configuration you choose. Check the image below for example.

Now click on the "Create database" button to start creating the server.

This will start creating the DB Server. It will show something like this while creating the server.

Once the server is created it will start showing like this. It will take some time to create the DB Instance.

You can click on "View connection details" to show your server username, password & endpoint. And please save the password somewhere. Because the password will now show again.

That's all how you can configure a MySQL DB Server in AWS RDS.

So that's all for this article. If you have questions related to this article, you can ask me in the comment section.

I hope you have liked this. Be sure to subscribe to the blog for more related articles.