mysql数据库监控程序_mysql数据库监控利器lepus天兔工具安装和部署

需要的核心包如下：

以下软件包只需要部署在监控机即可。被监控机无需部署。

1.MySQL 5.0及以上(必须,用来存储监控系统采集的数据)

2.Apache 2.2及以上 (必须,WEB服务器运行服务器)

3.PHP 5.3以上 (必须,提供WEB界面支持)

4.Python2 (必须,推荐2.6及以上版本,执行数据采集和报警任务,不支持Python3)

5.Python连接和监控数据库的相关驱动模块包：

MySQLdb for python (Python连接MySQl的接口，用于监控MySQL,此模块必须安装)

cx_oracle for python (Python连接Oracle的接口，非必须,如果需要监控oracle此模块必须安装)

Pymongo for python (Python连接MongoDB的接口，非必须,如果需要监控MongoDB此模块必须安装)

redis-py for python (Python连接Redis的接口，非必须,如果需要监控Redis此模块必须安装)

一．基本环境安装

(1)安装LAMP环境Lepus对MySQL性能还是有一定的影响的，特别是当我们的被监控端越来越多，监控项也比较多时，建议安装mysql5.6二进制版本)

先安装mysql，二进制安装包mysql-5.6.36-linux-glibc2.5-x86_64.tar.gz

groupadd -r mysql

useradd -g mysql -r -s /sbin/nologin mysql

tar -zxvf mysql-5.6.36-linux-glibc2.5-x86_64.tar.gz -C /usr/local

cd /usr/local

ln -sv mysql-5.6.36-linux-glibc2.5-x86_64 mysql

cd mysql

chown -R root.mysql ./*

mkdir /data/mydata -p

chown -R mysql.mysql /data/mydata

mkdir /data/binlogs

chown -R mysql.mysql /data/binlogs

cd /usr/local

scripts/mysql_install_db --datadir=/data/mydata --user=mysql

将服务脚本拷贝到启动项

cp support-files/mysql.server /etc/rc.d/init.d/mysqld

chkconfig --add mysqld

chkconfig --list mysqld

cp my.cnf /etc/my.cnf

vim /etc/my.cnf

[client]

port = 3306

socket = /tmp/mysql.sock

default-character-set = utf8mb4

[mysqld]

port = 3306

innodb_file_per_table = 1

init-connect = 'SET NAMES utf8mb4'

character-set-server = utf8mb4

default_storage_engine = InnoDB

skip-name-resolve

skip-external-locking

datadir = /data/mydata

log-bin=/data/binlogs/master-bin

binlog_format=row

socket=/tmp/mysql.sock

interactive_timeout = 28800

wait_timeout = 28800

[mysqldump]

quick

max_allowed_packet = 16M

[myisamchk]

key_buffer_size = 8M

sort_buffer_size = 8M

read_buffer = 4M

write_buffer = 4M

# 启动服务

service mysqld start

删除匿名用户，配置root密码

mysql> update user set password=PASSWORD('AJaC7uiKkYxbytGiEJBn') where user='root';

Query OK, 2 rows affected (0.00 sec)

Rows matched: 2 Changed: 2 Warnings: 0

mysql> flush privileges;

通过以下方式安装LAP

yum install httpd php -y

(2)开机自启动httpd，mysqld

chkconfig httpd on

chkconfig mysqld on

(3)安装lepus server需要的依赖包

yum install gcc python-devel mysql-devel net-snmp-devel curl-devel perl-DBI php-gd php-mysql php-bcmath php-mbstring php-xml -y

(4)配置httpd并启动

# vim /etc/httpd/conf/httpd.conf

# 修改默认的ServerName

ServerName localhost:8090

监听8090端口

Listen 8090

启动httpd服务

# service httpd start

(5)配置php

sed -i "s/;date.timezone =/date.timezone = Asia\/Shanghai/g" /etc/php.ini

sed -i "s#max_execution_time = 30#max_execution_time = 300#g" /etc/php.ini

sed -i "s#post_max_size = 8M#post_max_size = 32M#g" /etc/php.ini

sed -i "s#max_input_time = 60#max_input_time = 300#g" /etc/php.ini

sed -i "s#memory_limit = 128M#memory_limit = 128M#g" /etc/php.ini

sed -i "/;mbstring.func_overload = 0/ambstring.func_overload = 2\n" /etc/php.ini

验证lamp环境是否Ok

vim /var/www/html/info.php

phpinfo();

?>

访问http://ip/info.php看是否打印lamp环境信息

(7) 安装MySQLdb-python,解压后，编辑site.cfg，找到mysql_config,把#号去掉，并指定mysql_config的路径

mkdir lepus

wget https://github.com/farcepest/MySQLdb1/archive/MySQLdb-1.2.5.zip

unzip MySQLdb-python.zip

[root@u04ck04 lepus]# cd MySQLdb1-MySQLdb-1.2.5/

[root@u04ck04 MySQLdb1-MySQLdb-1.2.5]# which mysql_config

/usr/local/mysql/bin/my