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

This article mainly explains "the steps of building Lepus monitoring MySQL". The content of the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "the steps of building Lepus monitoring MySQL".

Part1:

Lepus installation requires Lamp environment. XAMPP is also recommended for installation on lepus official website manual. Lepus is also developed on XAMPP.

Note that xampp will install both apache,mysql,php, so install it in a clean environment to avoid installing two mysql, and two mysql is also possible.

Construction of Part2:LNMP environment

Install XAMPP

Xampp download address: https://www.apachefriends.org/download.html

Pay attention to your version number, the higher version of XAMPP may not be Mysql but MariaDB

If the system version is low, the GLIBC_ version will be low. I used xampp-linux-x64-5.6.37-0-installer.run (the database version is mariadb).

[root@B77-11-100 opt opt] # chmod + x xampp-linux-x64-1.8.2-5-installer.run

[root@B77-11-100 opt opt] #. / xampp-linux-x64-1.8.2-5-installer.run

[root@B77-11-100 opt opt] # / opt/lampp/lampp start

[root@B77-11-100 opt opt] # vi / etc/profile append environment variables

Export PATH=$PATH:/opt/lampp/bin/

Export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/lampp/lib

[root@B77-11-100 opt opt] # source / etc/profile

Part3: installing Lepus

MySQLdb-python.zip is necessary for monitoring mysql after lepus installation, and is installed directly by yum.

[root@B77-11-100 opt opt] # yum install MySQL-python

Lepus installation collector (download from lepus official website)

[root@B77-11-100 opt opt] # unzip lepus3.7.zip

[root@B77-11-100 opt opt] # which mysql_config

/ opt/lampp/bin/mysql_config

[root@B77-11-100 opt lepus_v3.7] # vi site.cfg

Mysql_config= / opt/lampp/bin/mysql_config

[root@B77-11-100 opt opt] # yum install gcc libffi-devel python-devel openssl-devel

[root@B77-11-100 opt opt] # yum install urpmi xterm

Note: if an error is reported during the installation of lepus, operate according to the error message, such as

[root@B77-11-100 opt lepus_v3.7] # ln-s / usr/lib64/libssl.so.1.0.1e / usr/lib64/libssl.so.1.0.0

[root@B77-11-100 opt lepus_v3.7] # ln-s / usr/lib64/libcrypto.so.1.0.1e / usr/lib64/libcrypto.so.1.0.0

Part4: database configuration

Monitoring library

Mysql > create database lepus default character set utf8

Mysql > grant select,insert,update,delete,create on lepus.* to 'lepus_user'@'%' identified by' abc123'

Mysql > flush privileges

[root@B77-11-100 opt lepus_v3.7] # mysql-uroot-p lepus

Use lepus

Mysql > alter table mysql_status modify column max_connect_errors bigint (18)

Mysql > alter table mysql_status_history modify column max_connect_errors bigint (18)

Just create a lepus_monitor account.

Mysql > grant select,super,process,reload,show databases,replication client on *. * to'lepus_monitor'@'192.168.11.100' identified by 'abc123'

Part5:lepus configuration

[root@B77-11-100 opt lepus_v3.7] # cd python/

[rroot@B77-11-100 opt python] # chmod + x install.sh

[root@B77-11-100 opt python] #. / install.sh

[root@B77-11-100 opt python] # vi / usr/local/lepus/etc/config.ini

# MySQL database connection address of monitor computer #

[monitor_server]

Host= "127.0.0.1"

Port=3306

User= "lepus_user"

Passwd= "abc123"

Dbname= "lepus"

[root@HE3lepus_v3.7] # cp-r php/* / opt/lampp/htdocs/

[root@HE3lepus_v3.7] # vi / opt/lampp/htdocs/application/config/database.php

$db ['default'] [' hostname'] = '192.168.11.100'

$db ['default'] [' port'] = '3306'

$db ['default'] [' username'] = 'lepus_user'

$db ['default'] [' password'] = 'abc123'

$db ['default'] [' database'] = 'lepus'

$db ['default'] [' dbdriver'] = 'mysql'

[root@B77-11-100 opt lepus_v3.7] # cd / usr/local/lepus/

[root@B77-11-100 opt lepus_v3.7] # lepus start

Nohup: appendingoutput to `nohup.out'

Lepus server startsuccess!

If you have any questions, read the log.

[root@HE3] # tail-f / usr/local/lepus/nohup.out

[root@HE3] # tail-f / usr/local/lepus/logs/lepus.log

[root@HE3~] # vi / opt/lampp/etc/extra/httpd-vhosts.conf

Delete the original and change it to

AddDefaultCharset UTF-8

DocumentRoot "/ opt/lampp/htdocs"

ServerName mysqlmtop1.ikongjian.com

Options FollowSymLinks

AllowOverride All

Order allow,deny

Allow from All

ErrorLog "| / usr/local/apache/bin/rotatelogs / home/logs/apache/php_%Y%m%d_error.log86400 480"

CustomLog "| / usr/local/apache/bin/rotatelogs / home/logs/apache/php_%Y%m%d_access.log86400 480" common

Enter 192.168.11.100 through the browser to open the monitoring interface and log in to the system. Default administrator account password after admin/Lepusadmin login, please change the administrator password and add an ordinary account.

Let xampp boot and start automatically

Sudo ln-s / opt/lampp/lampp / etc/init.d/lampp

Sudo chkconfig-add lampp

Thank you for your reading. The above is the content of "steps to set up Lepus to monitor MySQL". After the study of this article, I believe you have a deeper understanding of the steps of building Lepus to monitor MySQL, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.