create rds database

We can install and configure the RDS database on AWS Cloud. We have installed MySQL in rds database using the RDS Service.

How To Install and Configure RDS Database On AWS Cloud:

We need to open the RDS service on the account. Click on “Database” -> Click on “Create database“.

Once you click on create a database and you will see the two options are available: Standard and Easy create.

Check Out: How To Send Tomcat Logs To S3 Bucket From EC2 Instance

Standard Create: you will have to set manually all the required parameters in the database configuration file my.cnf.

Easy Create: AWS will provide you some basic database configuration. you don’t need to do anything. 

AWS provides us 6 Engines like MySQL, MariaDB, amazon aurora, oracle, PostgreSQL, and Microsoft SQL Server. you can select which one you want to install. I’m installing the MySQL RDS database.

You need to select the MySQL version in the drop-down.

We can choose a “template” and AWS provides you 3 templates are Prod, Dev/test, and free tier. I will show you the “production template” settings but I will launch the database in free-tier.

Check Out: How To Install Git Bash and Access AWS EC2 Instance

Some of the features won’t be seeing in the free-tier.

We have to give an “instance name“. you can change the “DB user” and set the “password”.

Select the “DB instance size” and you can check the size by using other options as shown in the below figure.

This time to select the “Storage Type“.

You can automatically increase the storage by using storage autoscaling options if you have enabled it. 

In production, you will get these “Multi-AZ” options. This option will automatically create the standby instance of your parent database instance.

Check Out: Install and Configure AWS CLI Version 2 Tool On Windows

This is managed by AWS and data will automatically write to the standby instance. we can’t access the standby instance. 

Now we need to provide the “VPC network where it will launch the DB instances.

Click on “Additional connectivity configuration“. we will grant public access for testing purpose and you can also create a new “security group” or use an existing one.

Network Subnet Settings:

If you have created the new security group, you will have to open the DB port in the security group. we can also change the default port 3306. 

Select the DB instances access method.

In the additional configuration, if you want to create a database when it’s launched, you can give a database name as shown below.

Select “Automatic backups“, if you want to apply the auto backup of your database. we can change the retention period means it will keep the database for these days.

Check Out: Perform Database Task Using SQLYog On Ubuntu

By default, it’s 7 days backup will be provided. you can also select “window time” when you want to start the backup.

Select “Encryption” if you require on the instance. 

install and configure rds

If you need to check the performance, you can “Enable” it.

rds database

Enable monitoring and you can also select the logs that will automatically be export to the cloud watch logs.

connect to rds from ec2

You can also enable the maintenance of the instance if you want to upgrade the version atomically. AWS also provides you the window when you can perform this task and also “Enable deletion protection”.

install rds database

The most interesting thing, before launching the DB engine you can see the estimated cost.

how to access aws rds database

Check Out: How To Set Ulimit Users and File Descriptions On Linux Server

Once you have review all the configuration, then click on “Create Database”. Now database instance is ready. 

rds install mysql

Click on the “database instances” and copy the “Endpoints“. 

how to install mysql in rds

Note: Don’t forget to open the port 3306 in the firewall group.

How To Access the Database:

You can’t access this database instance. we need a Linux server where we will access it using its endpoint address.

We need to install MySQL on that EC2 instance to access this server. 

yum install MySQL -y

Once it’s installed, run the below command to access the database.

mysql -h database-1.ccqs1xvjc7ko.us-east-1.rds.amazonaws.com -u admin -p

configure rds database

If you want to “delete” it, select the instance, and confirm the delete.

aws create rds database

That’s it. Install rds database configure mysql

LEAVE A REPLY

Please enter your comment!
Please enter your name here