DEV Community

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

Posted on

1 1

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

Do your career a big favor. Join DEV. (The website you're on right now)

It takes one minute, it's free, and is worth it for your career.

Get started

Community matters

Top comments (0)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

đź‘‹ Kindness is contagious

Immerse yourself in a wealth of knowledge with this piece, supported by the inclusive DEV Community—every developer, no matter where they are in their journey, is invited to contribute to our collective wisdom.

A simple “thank you” goes a long way—express your gratitude below in the comments!

Gathering insights enriches our journey on DEV and fortifies our community ties. Did you find this article valuable? Taking a moment to thank the author can have a significant impact.

Okay