AWS – MYSQL RDS Creation Steps

Steps to create RDS (Relational Database System) in Amazon

Search and select Amazon RDS Service

Step 1 : Click on create database

Step 2 : Two options available to create database

 Standard create
 Easy create

I have selected the option Standard create for our demo.

Author - Srinivasulu Paranduru

AWS – MYSQL RDS Creation Steps

Step 3 : Engine Options

Multiple Engine options available in the AWS Console and choose the database based on your
requirement and currently I have chosen MySQL for our demo

Edition by default will be MySQL Community after the MYSQL Engine type selected and Version by
default selected to the latest one

If we want still we can select older version from the version list of items

Author - Srinivasulu Paranduru

AWS – MYSQL RDS Creation Steps

Step 4 : Templates

Different types of Templates available and select based on your requirement and for the demo I
have selected Production, so I can show more options available .

Author - Srinivasulu Paranduru

AWS – MYSQL RDS Creation Steps

Step 5 : Availability and durability

Multiple options available in Deployment options

 Multiple-AZ DB Cluster-new
 Multi-AZ DB instance
 Single DB instance

Select the one based on requirement and I have chosen Single DB instance for my demo and others
will be charged more.

Author - Srinivasulu Paranduru

AWS – MYSQL RDS Creation Steps

Step 6 : Settings

DB instance Database-srini Give the name as desired

identifier
Master admin This is the default Master username
username
Master password Give the password and remember
password it, which is required for connecting
to the database
Confirm password Enter the same password as Master
password password for confirmation

Step 7 : Instance Configuration

Currently there are 3 DB instance class options available and I have chosen Burstable classes ( very
less memory ones ad vCPUs )

Author - Srinivasulu Paranduru

AWS – MYSQL RDS Creation Steps

Step 8 : Storage
Default settings - screenshot

Storage type General Purpose SSD(gp2) Selected general purpose storage type for my
demo and but its suggested to go with
Provisioned IOPS SSD(io1) if you compare the
storage types for more performance

Author - Srinivasulu Paranduru

AWS – MYSQL RDS Creation Steps

Allocated 20 When we selected General Purpose SSD(gp2)

Storage and by 20 GiB is the default , if we want more
storage we can increase it.

Storage autoscaling :

If you enable storage autoscaling , if the allocated storage got exhausted and storage increment will
be taken automatically.

Maximum storage threshold : Minimum : 22 GiB , Maximum : 16,384 GiB and 1000 is auto
populated and keep the value as your needs

But for mydemo, I have unselected the option Enable storage autoscaling

Author - Srinivasulu Paranduru

AWS – MYSQL RDS Creation Steps

Step 9 : Connectivity

Author - Srinivasulu Paranduru

AWS – MYSQL RDS Creation Steps

Virtual private cloud (VPC) : You can select the default VPC , other VPCs or can create a new VPC and
I have selected Default VPC

Subnet group : default subnet group

Public Access : Two options – Yes / No . As we need to access through the internet and so selected
Yes option

VPC security group : Two options

 Choose existing (selected this option for my demo)

 Create new

Availability Zone : No preference (selected the default option)

Under Additional Configuration

Database port : 3306 ( this value is auto populated)

Step 10 : Database authentication

Multiple options available for connecting to the database and I have selected password
authentication .

Step 11 : Additional Configuration

Author - Srinivasulu Paranduru

AWS – MYSQL RDS Creation Steps

Initial database name sriniMySQLDB ( Give the name based on

your application / choice)
DB parameter group default selected one

Option group default selected one

Step 12 : Backup

By default Backup is enabled when we are trying to create database .

Default Backup retention period is 7 days and we can change the value from 0 days to 35 days

Author - Srinivasulu Paranduru

AWS – MYSQL RDS Creation Steps

Backup window : There two options available

 Select window [ Start time : Mostly selecting out of office hours ]

 No preference

Step 13 : Encryption
By default Enable encryption is enabled

But for the demo I am unselecting it

Step14: Monitoring
By default monitoring is enabled

Author - Srinivasulu Paranduru

AWS – MYSQL RDS Creation Steps

But for the demo, I am unselecting “Enable Enhanced monitoring”

Step 15: Log exports

select the log types from the choices available but for the demo I am not selecting any options

Step16 : Maintenance
By default Enable auto minor version upgrade is enabled but for the demo I have unselected it

Author - Srinivasulu Paranduru

AWS – MYSQL RDS Creation Steps

Step 17 : Maintenance Window

For the demo I have gone with No preference

Step 18 : Deletion protection

By default Enable deletion protection is not selected and to prevent others from deleting
the database, if you enable this option it will protect the database.

But for the demo I am not enabled this option

Author - Srinivasulu Paranduru

AWS – MYSQL RDS Creation Steps

Finally click on Create database

If we see the status is showing as Creating and we need to wait for 5 to 10 minutes for the RDS to be
provisioned properly and once the RDS is ready status changes to Available.

Author - Srinivasulu Paranduru

AWS – MYSQL RDS Creation Steps

Step 19 : RDS Endpoint & port

Endpoint database-srini.cx9lhttqiaou.eu-west-1.rds.amazonaws.com

Port 3306

Author - Srinivasulu Paranduru

AWS – MYSQL RDS Creation Steps

Step 20 : Tools used for connecting

SQL ECTRON : A simple and lightweight SQL client desktop/terminal with cross database and
platform support.

Link to download : https://sqlectron.github.io/ ( it’s a free ware tool )

Open SQL ECTRON after the installation

Click on Add

Author - Srinivasulu Paranduru

AWS – MYSQL RDS Creation Steps

Name SriniMySQL_DEV ( Give the name based on

choice, so you can remember multiple databases
are there )
Database Type Selected MySQL a we need to connect to MYSQL

Author - Srinivasulu Paranduru

AWS – MYSQL RDS Creation Steps

Server Address Copy the endpoint url copied from the RDS
database

database-srini.cx9lhttqiaou.eu-west-
1.rds.amazonaws.com

port 3306 ( should be 3306 , check the step 19)

User Admin
Password Password
Initial Database sriniMySQLDB ( Name given at the time of
RDS creation)

Author - Srinivasulu Paranduru

AWS – MYSQL RDS Creation Steps

Click on Test button and it will fail with the Connection Error

Step 21 : Changes to the security group to allow access

Go the RDS which we created and click on the security group

Author - Srinivasulu Paranduru

AWS – MYSQL RDS Creation Steps

Security group Inbound details given below and click on Edit Inbound rules

Added a new Inbound rule and source I have selected MyIP and wanted this database to be
accessible only to my IP and save rules

Go back to step 20 and try connecting using the Test button below

Author - Srinivasulu Paranduru

AWS – MYSQL RDS Creation Steps

Connection Test is successful and click on save the store the database details and click on connect
button as per the image given below

Author - Srinivasulu Paranduru

AWS – MYSQL RDS Creation Steps

Able to connect to the database

Create a table and insert two rows to the table

Create table EmpDetails(FirstName varchar(50),LastName varchar(50))

insert into EmpDetails(FirstName, LastName) values('Dev','User')

insert into EmpDetails(FirstName, LastName) values('Test','User')

Author - Srinivasulu Paranduru

AWS – MYSQL RDS Creation Steps

Table we created is showing in the left side section, once the table is created pleas refresh the
database and it will get reflected in the Sqlelctron UI

Author - Srinivasulu Paranduru