DEV Community

Cover image for How to provision database using AWS RDS for your next application
Devanand Ukalkar
Devanand Ukalkar

Posted on

How to provision database using AWS RDS for your next application

Amazon Relational Database Service (RDS) is a distributed relational database service by Amazon Web Services. It is a web service running "in the cloud" designed to simplify the setup, operation, and scaling of a relational database for use in applications.

This article will guide you through the simple steps to provision a production grade database for your application within matter of minutes. Lets get started!

  • First obvious step is to create AWS account to avail the services.
  • Once you have your account ready, Search for RDS on AWS homepage

Image description

  • Scroll bit down and click on "Create Database" button.

Image description

  • Choose "Standard Create" as database creation method & Select MySQL from the Engine options (You can choose database as per your need).

Image description

  • Select MySQL version and template as "Free Tier"

Image description

  • Move to Settings section and enter details such as your database name in "DB Instance Identifier", username and password.

Image description

  • Leave all other default options and hit on "Create database" at the bottom

Image description

  • Database creation would take up to 10 mins. The status would be changed to available once its provisioned.

Image description

  • Once database is created, you will see database related details such as Endpoint & port, network, security etc.

Image description

  • Your database is not yet available to connect publicly. the Security group needs to have a rule to allow database to be accessed over the internet. Using "Security group rules", add following mentioned inbound rules to your database endpoint.

Image description

Image description

Image description

You are now ready to test your database connections!

In this case, Open MySQL Workbench and test the connection using the database Endpoint, port, username and password given at the time of provisioning. Yoohooo! It's all ready to be used by your application now!

Image description

Discussion (0)