Setup AWS Relational Databases - RDS Hands On
Tags: cloud, aws, cloudskills, devops
Published: 2021-08-11 03:12:53

Last time we studied about databases now we create a RDS database in AWS. To create a RDS database follow the steps:

* In search bar type RDS. Select a service named RDS
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/s918yzkfolgdi98ymnhs.png)
* Then select databases. There click on create database
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/y82qs56axevr8lwm5i9j.png)
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/jxz93i3mf070sxmyqtjl.png)
* For this tutorial we would do a standard create in easy create there are some configured options that makes it really easy to create a DB. Select MySql in database engine. You can select the version too but right now I'll choosing the latest default version.
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ygfsi2xornc6029iwm7a.png)

* Select the free tier in templates or select the option if you need to deploy the DB in prod or test as needed.
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/4sf2f3ygur1v5d90n42f.png)
* In the settings setup database name, username and password as needed. I've set the db name as database-1, username as admin, password as password
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/qw26am6wjko453pukrhd.png)

* Select the instance because of free tier we only have a t2.micro available
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/knisc4ml1j1m2d2r2gg4.png)

* In storage select storage type as general purpose SSD with 20 GB storage as it is available in the free tier. Uncheck enable auto scaling as this is a test instance if in production enable it as the storage will automatically be increased as needed.
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/cn1ud9kywn3kt7cdet82.png)

* You can also select multi AZ deployments if you are using it for production but it is not available in the free tier.
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/8to628xihdu37j9ruc3w.png)
* In connectivity select the VPC you want and subnets we will study about them in detail some other time, for now select the default ones and no need to change anything in this section defaults work just fine.
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/imjfk5bfuox73yfniz85.png)
* In authentication we will select password auth and in the costs you will see that this is in the free tier change settings from free tier to something else and you will see the monthly costs.
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/nji5847fw40x5dpvxdzl.png)
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/rmpfbutqxzdky7j1g1os.png)
* Click on create database. This will create our DB.
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/842a5jycleehfuehw9aa.png)

* Don't forget to delete your Db if you are dong this as an exercise as it may cost you money with all the backups

Do we have created our database we can use it now so we see how easy it was to setup a new DB in AWS if we would have done it on our own with backups, monitoring etc. It would have taken us a 1-2 days. Next we will study about Dynamo DB.