8i | 9i | 10g | 11g | 12c | 13c | 18c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Articles » Vm » Here

Amazon Web Services (AWS) : Relational Database Services (RDS) for MySQL

This article describes the creation of a database using Amazon Web Services (AWS) Relational Database Services (RDS) for MySQL, a Database as a Service (DBaaS) offering.

Related articles.

Create a New MySQL Service

Select the RDS option from the service catalog.

ASW Services

Select the "MySQL" option by clicking the "MySQL" tab and clicking the "Select" button next to it.

Select Engine

Select the high-availability state of the service. In this case I'm using the non-production option. When you've made your choice, click the "Next Step" button.

Production?

Enter the database details. Once you are happy with the settings click the "Next Step" button.

Specify DB Details

Enter the advanced settings, making sure the backup and maintenance settings are correct for your service. Once you are happy with the settings click the "Launch DB Instance" button.

Configure Advanced Settings

Click the "View Your DB Instances" button to see the status of your service.

Created

The resulting page shows the status of your services. Once the status is "available", you can connect to the service. If you want to see the monitoring information for the specific service, click the checkbox next to the service and click the "Show Monitoring" button.

Complete

The following picture shows the monitoring graphs.

Monitoring

Connecting to the Service

Open MySQL Workbench and create a new connection using the endpoint information from the "Instances" page and the credentials you used while setting up the service.

MySQL Workbench Connection

You will be logged into the console just like any other MySQL instance. To create a new schema, click the new schema button on the toolbar.

MySQL Workbench

Enter the details for the new schema and click the "Apply" button.

MySQL Workbench New Schema

Review the SQL and click the "Apply" button.

MySQL Workbench Review Script

Click the "Finish" button.

MySQL Workbench Apply Script

The new schema is now listed in the console.

MySQL Workbench

For more information see:

Hope this helps. Regards Tim...

Back to the Top.