# AWS - Relational Database Service

**Amazon RDS (Relational Database Service)** is a fully-managed SQL database cloud service that allows to create and operate relational databases. Using RDS you can access your files and database anywhere in a cost-effective and highly scalable way.

## Features of Amazon RDS

Amazon RDS has the following features −

- **Scalable** − Amazon RDS allows to scale the relational database by using AWS Management Console or RDS-specific API. We can increase or decrease your RDS requirements within minutes.
- **Host replacement** − Sometimes these situations occur when the hardware of Amazon RDS fails. There is no need to worry, it will be automatically replaced by Amazon.
- **Inexpensive** − Using Amazon RDS, we pay only for the resources we consume. There is no up-front and long-term commitment.
- **Secure** − Amazon RDS provides complete control over the network to access their database and their associated services.
- **Automatic backups** − Amazon RDS backs up everything in the database including transaction logs up to last five minutes and also manages automatic backup timings.
- **Software patching** − Automatically gets all the latest patches for the database software. We can also specify when the software should be patched using DB Engine Version Management.

## How to Set Up Amazon RDS?

**Step 1** − Login to AWS management console. Use the following link to open Amazon RDS console − [https://console.aws.amazon.com/rds/](https://console.aws.amazon.com/rds/)

**Step 2** − Select the region where the DB instance is to be created, at the top right corner of the Amazon RDS console.

**Step 3** − Select Instances in the navigation pane, then click Launch DB Instance button.

**Step 4** − The Launch DB Instance Wizard opens. Select the type of instance as required to launch and click the Select button.

![Engine Selection](https://www.tutorialspoint.com/amazon_web_services/images/engine_selection.jpg)

**Step 5** − On the Specify DB Details page, provide the required details and click the Continue button.

![Continue](https://www.tutorialspoint.com/amazon_web_services/images/continue.jpg)

**Step 6** − On the Additional configuration page, provide the additional information required to launch the MySQL DB instance and click the Continue button.

![DB Security Group](https://www.tutorialspoint.com/amazon_web_services/images/db_security_group.jpg)

**Step 7** − On Management options page, make the choices and click the Continue button.

![Launch DB Instance Wizard](https://www.tutorialspoint.com/amazon_web_services/images/launch_db_instance_wizard.jpg)

**Step 8** − On the Review page, verify the details and click the Launch DB Instance button.

![Launch DB Instance](https://www.tutorialspoint.com/amazon_web_services/images/launch_db_instance.jpg)

Now DB instance shows in the list of DB instances.

## How to Connect Database to MySQL DB Instance?

Following are the steps to connect a database on MySQL DB instance −

**Step 1** − Type the following command in the command prompt on a client computer to connect a database on MySQL DB instance (using the MySQL monitor).

**Step 2** − Replace <myDBI> with DNS name of your DB instance, <myusername> with your master user-name & <mypassword> with your master password.

```
PROMPT> mysql -h <myDBI> -P 3306 -u <myusername> -p
```

After running the above command, the output looks like −

```
Welcome to the MySQL monitor.  Commands end with ; or \g. 
Your MySQL connection id is 350 
Server version: 5.2.33-log MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.  
mysql>
```

## How to Delete a DB Instance?

After completing the task, we should delete the DB instance so will not be charged for it. Follow these steps to delete a DB instance −

**Step 1** − Sign in to the AWS Management Console and use the following link to open the Amazon RDS console.

[https://console.aws.amazon.com/rds/](https://console.aws.amazon.com/rds/)

**Step 2** − In the DB Instances list, select the DB instances to be deleted.

**Step 3** − Click the Instance Actions button and then select the Delete option from the dropdown menu.

**Step 4** − Select No in the Create Final Snapshot.

**Step 5** − Click the Yes, Delete to delete the DB instance.

## Cost of Amazon RDS

When using Amazon RDS, pay only for only the usage without any minimum and setup charges. Billing is based on the following criteria −

- **Instance class** − Pricing is based on the class of the DB instance consumed.
- **Running time** − Price is calculated by the instance-hour, which is equivalent to a single instance running per hour.
- **Storage** − Bill is calculated as per the storage capacity plan chosen in terms of per GB.
- **I/O requests per month** − Billing structure also includes total number of storage I/O requests made in a billing cycle.
- **Backup storage** − There is no additional charges for backup storage up to 100% of database. This service is free only for active DB instances.

For latest updated price structure and other details, visit the following link − [https://aws.amazon.com/rds/pricing/](https://aws.amazon.com/rds/pricing/)