Create RDS

Create RDS

In this step, we will create an RDS instance.
This is a crucial step in preparing to deploy our application data to RDS in the upcoming sections.

1. Go to the RDS Management Console
2. Click on Databases

3. On the RDS dashboard, click Create database

4. On the Create database page:
   • Under Choose a database creation method, select Standard create
   • Under Engine options, choose MySQL

5. Scroll down to:
   • Templates: select Free tier
   • Availability and durability: will be automatically set to Single-AZ DB instance deployment (1 instance)

6. Scroll down to the database credentials section:
   • Enter a DB instance identifier
   • Set Master username to admin
   • Under Credentials management, choose Self managed

7. Scroll down to the password section:
   • Enter the Master password
   • Re-enter it in Confirm master password

8. In the Connectivity section:
   • Virtual private cloud (VPC): choose Default VPC
   • DB subnet group: choose default
   • Public access: select Yes
   • VPC security group (firewall): choose Choose existing

9. Under Database authentication:
   • Select Password authentication
   • Monitoring defaults to Database Insights – Standard

10. Scroll to the bottom and click Create database

11. Once created, you will see your new database listed with the status Available

12. Click on the newly created database to view its details — take note of the endpoint, which is the URL your application will use to connect

13. Scroll down to Connectivity & security to see that the database runs on port 3306

14. Open MySQL Community client. You can download it here

• Click Database
• Then click Connect to Database

15. In the Connect to database dialog:

• Connection Method: select Standard
• Hostname: paste the endpoint from your RDS instance
• Username: enter admin
• Click OK, then enter the master password when prompted

16. The MySQL client interface will now show the details of your newly created database

Now that we’ve finished setting up RDS, the next step is to download the source code and package it into a .jar file.