Amazon RDS for MySQL and Amazon Aurora MySQL monitoring

Monitor the reliability, availability, and performance of the Amazon Relational Database Service (RDS) MySQL or Aurora MySQL instances by tracking the key performance indicators, including attempted connections, aborted connects, buffer pool utilization, threads running, and cache hit ratio.

Adding an Amazon RDS for MySQL or Aurora MySQL monitor

Prerequisites:

1. Log in to the AWS console.
2. Choose the appropriate region where you are planning to monitor the database.
3. Navigate to Services > Database > RDS and select the database instance you want to monitor.
4. You will find the Endpoint & port information under the Connectivity & security tab. We highly recommend using a private endpoint for monitor addition purposes.
   
   
   
   Fig. 1. Endpoint & port within the AWS console.
   
   
5. Please make sure the endpoint is accessible via the EC2 instance. If there is no EC2 instance set up for connection, you can create one by clicking Set up EC2 connection under the Actions tab in the Connected compute resources section.
   
   
   
   Fig. 2. Set up EC2 connection button.
   
   
6. If the endpoint is not accessible from the EC2 instance, check and update the outbound security rules of the EC2 instance and inbound VPC security group rules of the RDS instance to allow the MySQL port.
   
   
   
   Fig. 3. Outbound security rules of the EC2 instance.
   
   
   
   Fig. 4. Inbound VPC security group rules of the RDS.

To monitor AWS RDS MySQL or Aurora MySQL, you need to install the Site24x7 Linux server monitoring agent in the EC2 instance that shares the VPC of the database.

Site24x7 server monitoring agent installation:

1. Follow the steps on this page to create a user and grant permissions in the RDS instance.
2. Download and install the Site24x7 Linux server monitoring agent using these steps.
3. To start MySQL monitoring, authenticate Site24x7 to collect metrics. Execute the following command in your terminal to authenticate and configure MySQL monitoring:
   
   copied

   /opt/site24x7/monagent/scripts/AgentManager.sh mysql --add_instance

4. Enter your MySQL instance's user credentials, including the host name, port of the MySQL instance to be monitored, and the username and password that were created in Step 1, for the Site24x7 server monitoring agent.
   
   
   
   Fig. 5. Adding the MySQL instance.
   
   
5. For the host name and port, provide the private endpoint and the port number that you have copied from the Connectivity & security tab of the RDS instance (Step 4 under Prerequisites).

Check out the Site24x7 MySQL monitoring help page to know about the MySQL performance metrics that can be tracked, setting thresholds and getting alerts.

Related links

Database monitoring: MySQL | MSSQL | MySQL NDB Clusters
Server monitoring: Linux