Sign in Subscribe
PaaS Products

Mysql - Developer Guide

dinesh chathuranga

• 4 min read
Mysql - Developer Guide

Welcome to the Meetrix Mysql Developer Guide! This guide is designed to assist you in seamlessly integrating Mysql into your AWS environment through detailed, step-by-step instructions.

Video
Blog
How to Easily Backup MySQL DBs in AWS: Simplifying Database Security in the Cloud
Simplify MySQL database security in the cloud with our guide on easy AWS backups, designed for businesses across the UK, USA, Europe, Ireland, Singapore, and Thailand.
Meetix.IOKelum Sampath

Prerequisites

Before you get started with the Mysql AMI, ensure you have the following prerequisites:

Launching the AMI

Step 1: Find and Select AMI

  1. Log in to your AWS Management Console.
  2. Navigate to the "Mysql" in  AWS Marketplace.

Step 2:  Initial Setup & Configuration

  1. Click the "Continue to Subscribe" button.
  2. After subscribing, you will need to accept the terms and conditions. Click on "Accept Terms" to proceed.
  3. Please wait for a few minutes while the processing takes place. Once it's completed, click on "Continue to Configuration".
  4. Select the "CloudFormation Template" as the fulfillment option and choose your preferred region on the "Configure this software" page. Afterward, click the "Continue to Launch" button.
  5. From the "Choose Action" dropdown menu in "Launch this software" page, select "Launch CloudFormation" and click "Launch" button.

Create CloudFormation Stack

Step1: Create stack

  1. Ensure the "Template is ready" radio button is selected under "Prepare template".

2. Click "Next".

Step2: Specify stack options

  1. Provide a unique "Stack name".
  2. Set "DatabaseSSHLocation" as "0.0.0.0/0".
  3. For "DeploymentName", enter a name of your choice.
  4. Choose an instance type, "InstanceType" (Recommended: t3.small).
  5. Select your preferred "keyName".
  6. Enter a name of your choice for the "MysqlDatabase".
  7. Enter a strong password for "MysqlPassword".
  8. Enter a name for the "MysqlUser".
  9. Provide a S3 bucket name to "S3Bucket" for storing backups.
  10. Set "SSHLocation" as "0.0.0.0/0".
  11. Keep "SubnetCidrBlock" as "10.0.0.0/24".
  12. Keep "VpcCidrBlock" as "10.0.0.0/16".
  13. Click "Next".

Step3: Configure stack options

  1. Choose "Roll back all stack resources" and "Delete all newly created resources" under the "Stack failure options" section.
  2. Click "Next".

Step4: Review

  1. Review and verify the details you've entered.

2. Tick the box that says, "I acknowledge that AWS CloudFormation might create IAM resources with custom names".

3. Click "Submit".

Afterward, you'll be directed to the CloudFormation stacks page.

Please wait for 5-10 minutes until the stack has been successfully created.

Connect to the Database

  1. To obtain the IP address, navigate to the "Outputs" tab and look for "PublicIp".

2. Use "MysqlUser" as the username and "MysqlPassword" as the password, which are entered in "Step2: Specify stack options" within the "Create CloudFormation Stack" section.

3. You can access the database via port 3306.


(Access Mysql using MySQL Workbench)

Shutting Down Mysql

  1. Click the link labeled "Instance" in the "Resources" tab to access the EC2 instance, you will be directed to the Mysql instance in EC2.

2. Select the Mysql instance by marking the checkbox and click "Stop instance" from the "Instance state" dropdown. You can restart the instance at your convenience by selecting "Start instance".

Remove Mysql

Delete the stack that has been created in the AWS Management Console under 'CloudFormation Stacks' by clicking the 'Delete' button.

Upgrades

When there is an upgrade, we will update the product with a newer version. You can check the product version in AWS Marketplace. If a newer version is available, you can remove the previous version and launch the product again using the newer version. Remember to backup the necessary server data before removing.

Troubleshoot

  1.  If you face the following error, please follow https://meetrix.io/articles/how-to-increase-aws-quota/ blog to increase vCPU quota.

2.  If you face the following error (do not have sufficient <instance_type> capacity...) while creating the stack, try changing the region or try creating the stack at a later time.

3. If you face the below error, when you try to access the API dashboard, please wait 5-10 minutes and then try.

Conclusion

The Meetrix MySQL Developer Guide provides detailed, step-by-step instructions for seamlessly integrating MySQL into your AWS environment. MySQL, a widely adopted RDBMS developed and supported by MySQL AB, offers businesses of all sizes a fast and user-friendly database solution. Its popularity stems from its efficiency, reliability, and robust feature set, making it a preferred choice for various applications and industries.

Technical Support

Reach out to Meetrix Support (support@meetrix.io)  for assistance with Mysql issues.

Discover Seamless Meetings with >>>
Meetrix