Monitoring AWS RDS MySQL

Step 1: Complete the installation of Applicare SingleAgent.

Step 2: Verify that the following configurations are enabled in the DB instance.

• The RDS MySQL instance must be accessed from outside AWS.
• The user which we are going to configure in Applicare should have the same permission as master user.
• performance_schema parameter value should be 1.
• performance_schema_events_statements_history_size value should be1024.

Whenever we modify the Performance Schema Values, we must restart the DB instance.

Steps to check the performance_schema values in DB instance

1. Select the DB instance and go to Configuration tab to check the assigned to parameters group.

2. Go to RDS -> Parameter groups screen.

3. Choose the parameter group assigned to the DB instance and select Edit option from the Parameter group actions dropdown.

4. Search for performance_schema and check the values of performance_schema and performance_schema_events_statements_history_size values.

5. If the values for performance_schema and performance_schema_events_statements_history_size are not aligned in the settings, click the Edit parameters button and change the performance_schema to 1 and performance_schema_events_statements_history_size to 1024 and click the Save changes button.

6. Restart DB instance.

Since the "default" parameter group settings cannot be modified, you'll need to create a new parameter group if only the "default" group is available. After creating and configuring the new parameter group with the desired values, assign it to the DB instance. Follow these steps to create a DB parameter group and configure it.

Step 3: Launch the agent by executing the startAgent.bat (Administrator mode for windows) and startAgent.sh (sudo for linux) within the ApplicareSingleAgent.zip extracted directory.

Step 4: After starting the agent, it will be automatically registered with the Applicare controller. Log in to the Applicare console and go to the Overview menu.

Step 5: Locate the newly added agent, select it and click the Edit button.

Step 6: Check the "Add Database Configuration" box then choose the appropriate values from the   Database & Version dropdown menus based on the database which you are configuring. If your database version is not listed, select the last option in version dropdown.

Step 7: Provide the JDBC URL, Username and Password and click the update button to save.

Docs home