MySQL 8.4.x on AWS

This article describes the steps to configure a MySQL 8.4.x database on AWS RDS for use with OvalEdge. The procedure covers RDS instance creation, parameter configuration, and schema setup.

Audience: System Administrators, DevOps Engineers, Database Administrators

Prerequisites

Before starting the installation, ensure the following:

• AWS Permissions

  • IAM user/role with permissions to create and manage RDS instances, networking (VPC, Subnet Groups, Security Groups), and parameter groups.

• Technical Knowledge

  • Basic understanding of AWS networking concepts (VPC, Subnets, Security Groups).

  • Familiarity with MySQL administration.

• Tools

  • MySQL client installed on the local machine or bastion host.

  • Access to the Masterscripts.sql file provided by the OvalEdge team.

Steps Involved

1. Create a MySQL RDS Instance

   • Log in to the AWS Management Console and navigate to: RDS → Databases → Create Database

     
   • Select Standard Create as the creation method.

     
   • In Engine Options, choose MySQL.

     

     • Recommended Version: 8.4.x (Latest GA release)

   • Configure Templates, Availability, and Durability based on organizational requirements (e.g., Multi-AZ for high availability).

     
   • Provide database details:

     

     • DB Identifier: <your-db-identifier>

     • Master Username: <username>

     • Password: <password>

   • Select an Instance Configuration that meets workload requirements.

     

     • Example: db.m6g.large for medium workloads.

   • In Storage, configure:

     

     • Storage type (e.g., General Purpose SSD)

     • Allocated storage size (e.g., 100 GB, scalable as required).

   • Configure Connectivity:

     • Select the appropriate VPC, Subnet group, and Security group as per the Cloud/Networking team’s recommendations.

       

       
     • Ensure that MySQL (port 3306) is open to the required application servers.

   • Under Authentication, select Password Authentication.

     
   • In Additional Configuration:

     • Set an initial database name if required.

     • Attach a new DB Parameter Group customized for OvalEdge.

   • Click Create Database.

     

     ⚡ It will take a few minutes to create the RDS, and then it will display the available status.

     

2. Retrieve Database Endpoint

   • From the RDS console, select the newly created instance.

     
   • Copy the Endpoint value (host address).

3. Connect to the Database

   • Run the following command from a system with the MySQL client installed:

     Copy

     mysql -h <endpoint> -u <username> -p

     Sample Reference Screenshot:

     

     • Replace <endpoint> with the RDS instance endpoint.

     • Enter the master password when prompted.

     Error Handling Tip

     If the connection fails, verify:

     • Security group inbound rules allow access from the client machine.

     • Correct endpoint, username, and password are used.

     • MySQL client version is compatible with MySQL 8.4.x.

4. Create OvalEdge Schema

   • From the MySQL prompt, execute the OvalEdge Masterscripts.sql file:

     Copy

     source <path_to_Masterscripts.sql>

     Sample Reference Screenshot:

     
   • Verify database creation with:

     Copy

     SHOW DATABASES;

     Sample Reference Screenshot:

Rollback Instructions

• If incorrect parameters or instance class were selected:

  • Delete the RDS instance from the AWS console.

  • Recreate with correct parameters.

• If schema creation fails:

  • Drop the failed database using:

    Copy

    DROP DATABASE <schema_name>;

  • Re-run the Masterscripts.sql file.

Copyright © 2025, OvalEdge LLC, Peachtree Corners, GA, USA.