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 [Link]
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 : [Link] ( 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
[Link]-west-
[Link]
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