Boosting MySQL database performance

with Amazon ElastiCache (Redis OSS)

Introduction
Create a Redis Cluster
Create a MySQL Database
Populate your MySQL Database
Caching and Best Practices
Clean Up and Next Steps

Module 2: Create a MySQL database

You will create a RDS/MySQL database instance and your MySQL table.

What You Will Learn

  • How to create a RDS/MySQL Database Instance and your MySQL table

 Time to Complete

20 minutes

 Services Used

Amazon RDS Console

Implementation

  • 2.1 - Open a browser and navigate to Amazon RDS console.

    2.2 — On the top right corner, select the region where you want to launch the Aurora DB cluster.

    Select the region where you want to launch the Aurora DB Cluster

    2.3 — Click on “Create database” in the Amazon Aurora window.

    Click on "Create Database"

    Before continuing, switch to the new database creation flow if the option appears: 

    Switch to the new database creation flow (if the option appears)

  • 2.4 — On Database engine, select “MySQL”.

    Select MySQL

    2.5 — On Version, select the most recent MySQL version.

    Select the most recent MySQL version

  • 2.6 — Select “Free tier”.

    Select Free Tier

  • 2.7 — Choose an identifier for your MySQL database, e.g. “database-1”.

    Choose a DB instance identifier

  • 2.8 — Select db.t2.micro.

    Select db.t2.micro

  • You can leave the default value. 

  • 2.9 — Select the VPC where you want to create the database.

    Note that once created, a database can’t be migrated to a different VPC. 

    Select the VPC where you want to create the database

    2.10 — Click on “Additional connectivity configuration”.

    Click on Additional connectivity configuration

    2.11 — Select the default value for Subnet group.

    Select the default value for Subnet group

    2.12 — On Publicly accessible, select “No”.

    This means you will have to connect to the database from an EC2 instance within the same VPC. 

    Select "No" for publicly accessible

    2.13 — On VPC security group, select “Create new”.

    If you happen to have a security group that allows incoming TCP connections on port 3306, you can choose it instead.

    On VPC Security Group select "Create new"

    2.14 — In New VPC security group name, type “elc-tutorial”.

    In new VPC security group name, type "elc-tutorial"

    2.15 — Leave the default value for Database port.

    Leave the default value for Database Port

  • Leave the default values for “Additional configuration”.

    The best practice is to enable the Deletion protection. If you want to delete the database at the end of the tutorial, you can leave the option unchecked.

    2.16 — On “Deletion protection”, uncheck “Enable deletion protection”.

    On Deletion Protection, uncheck "Enable deletion protection"

  • After a quick review of all the fields in the form, you can proceed.

    2.17 — Click on “Create database”.

    While the instances are being created, you will see a banner explaining how to obtain your credentials. This is a good opportunity to save the credentials somewhere, as this is the only time you will be able to view this password.

    Click on Create Database

    2.18 — Click on “View credential details”.

    Click on View Credential Details

    2.19 — Save the username, password, and endpoint.

    Save the username, password, and endpoint

Was this module helpful?

 Feedback
Start Module Three

Populate Your MySQL Database