Create Aurora MySQL DB

Amazon Relational Database Service (RDS) is an AWS managed service to set up, operate, and scale a relational database in the cloud with just a few clicks. You can use six familiar database engines to choose from, including PostgreSQL, MySQL, MariaDB, Oracle, MS SQL Server and Amazon Aurora (with MySQL and PostgreSQL compatibility). For this workshop, we will setup Amazon Aurora with MySQL compatibility.

Setup Aurora MySQL RDS Database

In this section, we will setup Aurora MySQL RDS with Multi-AZ configuration.

  1. Sign in to the AWS Management Console and open the Amazon RDS console.

  2. In the upper-right corner of the AWS Management Console, choose the default region in which we will create the DB cluster.

  3. In the navigation pane, choose Databases.

  4. Choose Create database.

  5. In Choose a database creation method, choose Standard Create.

  6. In Engine options, choose Amazon Aurora.

    Aurora RDS create

  7. In Edition, choose Amazon Aurora with MySQL compatibility

  8. In Capacity type, choose Provisioned

  9. In Templates, choose Dev/Test template.

  10. In the DB cluster identifier field, give Aurora DB cluster name, tripmgmtdb-cluster

  11. To enter your master password, do the following in Credential Settings

    1. Clear Auto generate a password check box.
    2. Enter Master password value as mysql123 and enter the same password in Confirm password.
  12. For DB instance size, choose db.t3.small

  13. For Availability & durability, choose Create an Aurora Replica/Reader node in a different AZ (recommended for scaled availability)

  14. For Connectivity, defaults.

  15. For Additional configuration

    1. Initial database name, enter tripmgmt
    2. Under Monitoring, uncheck Enable Enhanced monitoring
  16. Choose Create database.

  17. For Databases, choose the name of the new Aurora DB cluster.

    On the RDS console, the details for new DB cluster appear. The DB cluster and its DB instance have a status of creating until the DB cluster is ready to use. When the state changes to available for both, you can connect to the DB cluster. Depending on the DB instance class and the amount of storage, it can take up to 20 minutes before the new DB cluster is available.

  18. On the Connectivity & security tab, note the port and the endpoint of the writer DB instance. Please make a note of the endpoint and port of the cluster. Endpoint URL should be of format tripmgmtdb-cluster.cluster-UNIQUEID.AWSREGION.rds.amazonaws.com

  19. Click on Writer Node and on the Connectivity & security tab, make a note of the Security Group Id under Security section (i.e. sg-xxxxxxxx)

NOTE: You can continue with next steps and come back again for last steps.