Relational Database Service (RDS)

  • Post category:Solutions
  • Reading time:3 mins read

RDS is an acronym for Relational Database Service
It’s a managed DB service for DB’s that use SQL to query the data.
AWS offers the functionality of creating databases on the cloud :

  • Postgres 
  • MySQL
  • MariaDB 
  • Oracle 
  • Microsoft SQL Server 
  • Aurora (AWS Proprietary database)

Let’s create RDS in our AWS lab :

  • Log in to the Amazon Web Services Management Console and type “RDS” in the search bar
  • The RDS dashboard will appear as follows

RDS

  • Click on Databases on the left-hand side
  • Click on Create Database
  • As there are two different methods to create database, we’ll choose Standard Create to explore different possibilities
  • If you scroll down, you will see six different Engine options
  • The free tier is only available if you choose the MySQL database
  • Leave the version selection at the defaultRDS
  • We will explore the Free Tier in Templates
  • In this step, you should name your database instance, which should be unique in your region
  • We will name it as “myfirstmysql”
  • We need to specify the credentials for the master username
  • As an example, we are going to use “awscloud” and a password of your choice so that it is easy for you to remember

RDS

  • The DB instance size will default to “t2.micro” because we are using a free tier service
  • In Storage part disable “Enable storage autoscaling”
  • Scroll down and select Public Access as Yes
  • Create a new security group and call it as “my-first-rds-sg”
  • In Availability Zone select any one AZRDS
  • Scroll down and click on Additional Configuration
  • Give initial database name as “mydb
  • Leave the below options as default and we will keep Enable automatic backups enabled
  • Keep the default settings after scrolling down
  • Check out the estimated monthly costs of creating a database
  • Click on Create database
  • It will take few minutes for the database to launch and take backups as well
  • RDS
  • Finally, we have created our first database, and we expect the status to be Available
  • In this step, we will use SQL client to connect to RDS
  • In Google browser type sqlelectron and click on the link to open it

RDS

  • Click on Download GUI 
  • Download links can be found at the foot of the page
  • Windows users can download the Win package
  • Mac users can choose .dmg, and Linux users can choose .rpm or .deb
  • Click on the link to install the package
  • You will be able to see the SQL electron dashboard after completing the download.RDS
  • Click on Add
  • You will get the Server information page
  • Give the name as My RDS Database and database type select MySQL
  • Now, go to your RDS database page and copy the Endpoint
  • Enter the username and password you created when you created the database
  • Click on Test and it will show the message as Successfully tested
  • Click on Save
  • Then click on Connect

Congratulations!! You are connected to your database!! See you in next Lab.

 

 

Leave a Reply