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.
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.
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.
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.
If you need to check the performance, you can “Enable” it.
Enable monitoring and you can also select the logs that will automatically be export to the cloud watch logs.
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”.
The most interesting thing, before launching the DB engine you can see the estimated cost.
Once you have review all the configuration, then click on “Create Database”. Now database instance is ready.
Click on the “database instances” and copy the “Endpoints“.
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
If you want to “delete” it, select the instance, and confirm the delete.
That’s it. Install rds database configure mysql