Monitoring AWS RDS MySQL

Step 1: Follow the steps for installing Applicare SingleAgent.

Step 2: Check the below configurations are enabled in the DB instance.

• The RDS MySQL instance should be accessed from outside the 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.

Note:
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 and check the Parameter group assigned to that.

2. Go to RDS -> Parameter groups screen.

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

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

5. In the above settings if the performance_schema and the  performance_schema_events_statements_history_size parameter values are different then 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.

Note:
We cannot modify the "default" Parameter groups settings. So if we have only "default" Parameter groups settings then we need to create a new parameter group and modify the values in that and assign the newly created parameter group to that DB instance. Follow the steps to create a DB parameter group.

Step 3: Start the agent by running the startAgent.bat (Administrator mode for windows) and startAgent.sh (sudo for linux) inside the ApplicareSingleAgent.zip extracted directory.

Step 4: Once the agent is started, Agent will be automatically added to the Applicare controller. Login into the Applicare console and go to the Overview menu.

Step 5: Select the newly added agent and click the Edit button.

Step 6: Enable the "Add Database Configuration" checkbox and select the Database & Version dropdown values based on the database which we are going to configure. If the version is not available in the dropdown select the last option in version dropdown.

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

For Other Docs - Click here