Shulou(Shulou.com)05/31 Report--

This article is about how lepus monitors replication options. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

The lepus Monitoring replication option has no data:

Use Lepus 3.8to monitor MySQL 5.7.Why doesn't the copy monitoring section show the results? Master-slave synchronization is normal.

This kind of error occurs mainly in log files:

2017-05-31 17:42:01 [WARNING] check mysql 10.168.200.96 failure: sleep 3 seconds and check again.

2017-05-31 17:42:01 [WARNING] check mysql 172.16.11.189 purl 3306 failure:-1 error totally whack

2017-05-31 17:42:01 [WARNING] check mysql 172.16.11.189 failure: sleep 3 seconds and check again.

2017-05-31 17:42:01 [WARNING] check mysql 172.16.11.187 purl 3306 failure:-1 error totally whack

2017-05-31 17:42:01 [WARNING] check mysql 172.16.11.187 failure: sleep 3 seconds and check again.

2017-05-31 17:42:01 [WARNING] check mysql 172.16.11.188 failure:-1 error totally whack

2017-05-31 17:42:01 [WARNING] check mysql 172.16.11.188 failure: sleep 3 seconds and check again.

(this problem has been plagued for several days.), there is also a feedback error in the question collection on the official website. But it's a pity that I didn't read it.

To the solution, but when I looked at the problem collection for the nth time, I was pleasantly surprised to find that there was a person below to solve it (I was too careless)

The settings of the monitored machines are as follows:

Set global show_compatibility_56=on; should be fine, because show_compatibility_56 mysql 5.7in check.mysql.py is no longer supported.

two。 The replication module does not have permission to open:

Solution: find /-name lp_mysql.php

Just comment out the 337 lines of the file.

Public function replication_chart () {

# parent::check_privilege ('parent::check_privilege ()')

$server_id = $this- > uri- > segment (3)

$server_id: "0" empty ($server_id)

$begin_time = $this- > uri- > segment (4)

$beginnings timetables empty ($begin_time)? $begin_time: "60"

$time_span = $this- > uri- > segment (5)

$timetables spanned empty ($time_span)? $time_span: "hour"

Thank you for reading! This is the end of this article on "how to monitor replication options in lepus". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.