Lbmysqlping (LegendBaseMySQLPing)

Lbmysqlping (LegendBaseMySQLPing) protocol. Ofcourse, itcouldbeusedtomonitorMySQLserversavailability. Ifsomeserverdown, LBMySQLpingwillrunDowncommandthat

Lbmysqlping (LegendBase MySQL Ping) is a tool that does MySQL service availability check for MySQL HA solution. of course, it cocould be used to monitor MySQL servers availability. if some server down, LBMySQLping will run Down command that

Lbmysqlping (LegendBase MySQL Ping) is a tool that does MySQL service availability check for MySQL HA solution.

Of course, it cocould be used to monitor MySQL servers availability. If some server down, LBMySQLping will run "Down" command that cocould send email or message to your mobile.

Many of my friends are faced with MySQL service availability detection when working on MySQL database high availability (Heartbeat, keepalived) and Master/Slave Load Balancing (LVS, F5, A10, etc.

It is not easy to solve the following problems:

• The port can be connected, but the SQL statement may not be executed. In fact, MySQL service is unavailable at this time.
• The SQL statement execution is blocked and cannot be returned for a long time, because MySQL is blocked.
• MySQL Slave has a large latency and should be cleared from the route table.

I have learned that many people use port detection methods, which is risky.

Lbmysqlping contributed today can flexibly detect MySQL services through configurable methods. If an exception \ timeout occurs or the Slave latency exceeds the configured size, you can run the specified invalid command, when the service is available, you can run the recovery command again.

In addition, lbmysqlping can also be used as a simple alarm system. After the default information is configured, other realservers only need to configure IP addresses. If the ports are different, change the ports. Then fill in the relevant scripts or alarm programs in the down and up commands, so that a simple MySQL service availability alarm system will come out, simple and efficient.

The configuration file format is as follows:

(...)
Read the full text lbmysqlping (LegendBase MySQL Ping) (58 words)

? Tan junqing published a study on MySQL performance, MySQL Cluster, and MySQL HA High Availability-MySQL laboratory, 2012.
The source and author information of an article can be reproduced at will.
Link: http://www.mysqlab.net/blog/2012/06/lbmysqlping-legendbase-mysql-ping/

Tags: MySQL, MySQL HA, MySQL Replication