How to use CloudWatch to monitor an EC2 instance with MySQL installed?

Question

Details:

I have a web server EC2 instance running MySQL on amazon linux 2.
I want to set up monitoring for this instance using AWS CloudWatch.
Specifically, I need to monitor metrics such as queries per seconds, operations per second, current active connection, connections per second etc..  .
I am looking for guidance on how to configure CloudWatch alarms and dashboards to effectively monitor the health and performance of my MySQL.

Answer

Hello.

I think it is necessary to register data such as the number of active connections to the database in CloudWatch metrics using a shell script or the like.  
For example, you can use a shell script to execute the SQL "show status like 'Threads_connected';" and register the value in CloudWatch metrics using "put-metric-data".  
https://docs.aws.amazon.com/AmazonCloudWatch/latest/monitoring/PublishMetrics.html#add-metrics-to-scenario

By creating an alarm for the created metrics, it is possible to notify when an abnormality occurs.  
https://docs.aws.amazon.com/AmazonCloudWatch/latest/monitoring/ConsoleAlarms.html

If you use RDS instead of EC2, I think most of the metrics you want to see are included in CloudWatch's standard metrics.  
In some cases, it may be easier to migrate to RDS.  
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/rds-metrics.html

How to use CloudWatch to monitor an EC2 instance with MySQL installed?

Relevant content