软件包提取码:ai5r
lepus(天兔):是一套开源的数据可监控平台
目前监控支持的有:
- mysql
- oracle
- sqlserver
- redis
- mongdb
- redis
lepus监控MySQL时只需要授权
1、搭建lepus和LAMP
1)搭建LAMP
[root@CentOS1 ~]# yum -y install httpd php php-mysql mariadb-server mariadb-devel python-devel #php-mysql是php与mysql链接时的一个插件
2)安装python基础模块
[root@CentOS1 ~]# unzip MySQL-python-1.2.5.zip
[root@CentOS1 ~]# cd MySQL-python-1.2.5/
[root@CentOS1 MySQL-python-1.2.5]# which mysql_config
/usr/bin/mysql_config
[root@CentOS1 MySQL-python-1.2.5]# vim site.cfg
13 mysql_config = /usr/bin/mysql_config
[root@CentOS1 MySQL-python-1.2.5]# cd
[root@CentOS1 ~]# tar zxf pip-19.3.1.tar.gz #这个是依赖关系
[root@CentOS1 ~]# cd pip-19.3.1/
[root@CentOS1 pip-19.3.1]# python setup.py build #编译
[root@CentOS1 pip-19.3.1]# python setup.py install #安装
[root@CentOS1 pip-19.3.1]# cd /root/MySQL-python-1.2.5/
[root@CentOS1 MySQL-python-1.2.5]# python setup.py build #编译
[root@CentOS1 MySQL-python-1.2.5]# python setup.py install #安装
2)安装lepus
[root@CentOS1 ~]# unzip Lepus-3.7.zip
[root@CentOS1 ~]# cd lepus_v3.7/python/
[root@CentOS1 python]# python test_driver_mysql.py
MySQL python drivier is ok!
3)安装lepus采集器
[root@CentOS1 python]# systemctl start mariadb
[root@CentOS1 python]# netstat -anput | grep 3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 60570/mysqld
[root@CentOS1 python]# mysqladmin -uroot password '123456'
[root@CentOS1 python]# mysql -uroot -p123456
MariaDB [(none)]> grant all on lepus.* to "lepus"@"localhost" identified by '123456';
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> create database lepus default character set utf8;
Query OK, 1 row affected (0.00 sec)
MariaDB [(none)]> flush privileges;
Query OK, 0 rows affected (0.00 sec)
123
[root@CentOS1 sql]# mysql -ulepus -p123456 lepus <lepus_table.sql
[root@CentOS1 sql]# mysql -ulepus -p123456 lepus <lepus_data.sql
[root@CentOS1 sql]# cd ../python/
[root@CentOS1 python]# chmod +x install.sh
[root@CentOS1 python]# ./install.sh
[note] lepus will be install on basedir: /usr/local/lepus
[note] /usr/local/lepus directory does not exist,will be created.
[note] /usr/local/lepus directory created success.
[note] wait copy files.......
[note] change script permission.
[note] create links.
[note] install complete.
[root@CentOS1 ~]# vim /usr/local/lepus/etc/config.ini
###监控机MySQL数据库连接地址###
[monitor_server]
host="127.0.0.1"
port=3306
user="lepus"
passwd="123456"
dbname="lepus"
[root@CentOS1 ~]# lepus start
nohup: 把输出追加到"nohup.out"
lepus server start success!
安装web管理平台
[root@CentOS1 ~]# cd lepus_v3.7/php/
[root@CentOS1 php]# cp -a . /var/www/html/
[root@CentOS1 php]# vim /var/www/html/application/config/database.php
53 $db['default']['username'] = 'lepus';
54 $db['default']['password'] = '123456';
55 $db['default']['database'] = 'lepus';
[root@CentOS1 php]# systemctl start httpd
#web登录时的用户名和密码分别是:admin/Lepusadmin