Redgate Monitor 14

Additional configuration required

Make sure you have prepared MySQL for monitoring before adding a MySQL instance to Redgate Monitor.

This page explains how to add MySQL instances running on Amazon RDS.

Parameter Group Configuration

By default, performance_schema is disabled in Amazon RDS for MySQL.

You will need to enable it by modifying your RDS parameter group, as system variables in RDS cannot be directly changed with SET statements.

Step 1: Create a Custom Parameter Group

Amazon RDS does not allow modifying performance_schema directly on the instance, so you must create a custom DB parameter group.

Sign in to AWS Management Console and go to RDS.
In the left menu, click Parameter groups.
Click Create parameter group.
Choose:
- Parameter group family: Select the correct MySQL version (e.g., mysql8.0).
- Type: Select DB Parameter Group.
- Name: Enter a descriptive name, e.g., mysql-custom-params.
- Description: (Optional) Add a description.
Click Create.

Step 2: Modify the Parameter Group

Find your newly created DB parameter group and click on it.
Search for performance_schema.
Change its value from 0 to 1.
Click Save changes.

Step 3: Apply the Custom Parameter Group to Your RDS Instance

Go to RDS → Databases.
Select your MySQL RDS instance.
Click Modify.
Scroll down to DB parameter group and select the custom parameter group you created.
Click Continue.
Select Apply Immediately (or apply it during the next maintenance window).
Click Modify DB Instance.

Step 4: Reboot the RDS Instance

The changes won’t take effect until you reboot:

Go to RDS → Databases.
Select your MySQL instance.
Click Actions → Reboot.
Confirm the reboot.

Adding MySQL Instance

Go to Configuration → Monitored servers → Add → MySQL instance

Insert the endpoint and port details, the authentication details will be the same as created in the precursory step above.

Optionally, set up Advanced monitoring using your AWS API credentials:

You can now attempt to test the connection, then add once connection is successful, or, add straight away.

Once added, the server name can't be edited. If you typed the name incorrectly and the server cannot be reached you will need to remove the server and add it again.