MYSQL learning summary (7): MYSQL monitoring

#Monitor master-slave synchronization
At present, I don’t have a ready-made script, but the general idea is this: check the two yeses, and check the pos of the master and slave, or you can insert a sql on the master and check whether it can be checked on the slave. get.
#Monitor the normal operation of mysql
There is currently no ready-made script available. The general idea is: monitor the 3306 port. If it does not exist, start mysql. The script runs every 10 minutes.
#Monitoring mysql machine performance indicators (including memory, cpu, IO, hard disk, etc.)
It can be monitored together with nagios, but I haven’t fully set up nagios yet. If you have experience in this area, please share it.

The above is the MYSQL learning summary (7): the content of MYSQL monitoring. For more related content, please pay attention to the PHP Chinese website (www.php.cn)!