3.5 Lepus数据库监控工具 · 开源知识库

Lepus数据库监控 == 安装Python环境 -- 安装Python基础模块首先安装Python环境（Python版本要求为Python2.6以上,不支持Python3）其次安装数据库连接Python的驱动包 1.安装 MySQLdb for python （必须安装） MySQLdb为Python连接和操作MySQL的类库，如果您准备使用lepus系统监控MySQL数据库，那么该模块必须安装。安装步骤如下： #wget http://cdn.lepus.cc/cdncache/software/MySQLdb-python.zip # unzip MySQLdb-python.zip # cd MySQLdb1-master/ # which mysql_config /usr/local/mysql/bin/mysql_config # vim site.cfg 修改如下： mysql_config = /usr/local/mysql/bin/mysql_config # python setup.py build # python setup.py install 常见错误解决： 1).如果编译python出现如下问题 /usr/bin/ld: cannot find -lpython2.7 collect2: ld returned 1 exit status error: command 'gcc' failed with exit status 1 请按如下步骤处理： A.检查并安装python-devel包 # yum -y install python-devel B.将libpython2.7.so库文件建立软连接到/usr/lib下 32位服务器下执行 # ln -s /usr/local/Python2.7/lib/libpython2.7.so /usr/lib/libpython2.7.so 64位服务器下执行 # ln -s /usr/local/Python2.7/lib/libpython2.7.so /usr/lib64/libpython2.7.so C.检查下/etc/ld.so.conf是否包含/usr/local/Python2.7/lib #vi /etc/ld.so.conf 添加/usr/local/Python2.7/lib #/sbin/ldconfig 2.安装cx_oracle for python （如果需要监控Oracle则必须安装）下载安装oracle instant client http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html 如果是64位的，请选择.*x86_64.rpm,否则是.*i386.rpm 如果是oracle 9i或更高，请选择Instant Client 11,如果是8或8i,请选择Instant Client 10 [root@westserver software]# rpm -ivh oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm Preparing... ########################################### [100%] 1:oracle-instantclient11.########################################### [100%] [root@westserver software]# rpm -ivh oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm Preparing... ########################################### [100%] 1:oracle-instantclient11.########################################### [100%] [root@westserver software]# rpm -ivh oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm Preparing... ########################################### [100%] 1:oracle-instantclient11.########################################### [100%] [root@westserver home]# vim /root/.bash_profile ORACLE_HOME="/usr/lib/oracle/11.2/client64" PATH=$PATH:$ORACLE_HOME/bin export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/usr/local/lib export LD_LIBRARY_PATH 修改完成后重新加载bash_profile文件 [root@westserver cx_Oracle-5.1.2]# source ~/.bash_profile [root@westserver software]# vim /etc/ld.so.conf 加入 /usr/lib/oracle/11.2/client64/lib 执行ldconfig生效 [root@westserver software]# ldconfig 安装cx_oracle # wget http://cdn.lepus.cc/cdncache/software/cx_Oracle-5.1.2.tar.gz # tar zxvf cx_Oracle-5.1.2.tar.gz # cd cx_Oracle-5.1.2 # python setup.py build # python setup.py install 3.安装Pymongo for python （如果需要监控Mongodb则必须安装） pymongo为Python连接和操作MongoDB的类库，如果您准备使用lepus系统监控MongoDBs数据库，那么该模块必须安装。安装步骤如下: # wget http://cdn.lepus.cc/cdncache/software/pymongo-2.7.tar.gz # tar zxvf pymongo-2.7.tar.gz # cd pymongo-2.7 # python setup.py install 4.安装Redis 驱动（如果需要监控Redis则必须安装） # wget http://cdn.lepus.cc/cdncache/software/redis-py-2.10.3.tar.gz # tar zxvf redis-py-2.10.3.tar.gz # cd redis-2.10.3/ # python setup.py install 5.测试各个驱动是否正常运行（非必须）在lepus的安装文件包python目录中，你可以找到如下测试文件，测试上述驱动是否安装正确。 # python test_driver_mysql.py MySQL python drivier is ok! # python test_driver_oracle.py Oracle python drivier is ok! # python test_driver_mongodb.py MongoDB python drivier is ok! # python test_driver_redis.py Redis python drivier is ok! 安装Lepus采集器 -- 1)上传软件包到监控机服务器并解压缩软件到您的系统 # unzip lepus_vx.x.x.zip 2).在监控机创建监控数据库，并授权。 mysql> create database lepus default character set utf8; mysql> grant select,insert,update,delete,create on lepus.* to 'lepus_user'@'localhost' identified by 'xxxxxx'; mysql> flush privileges; 导入SQL文件夹里的SQL文件(表结构和数据文件) # mysql -uroot –p lepus < sql/lepus_table.sql # mysql -uroot –p lepus < sql/lepus_data.sql 4)安装Lpeus程序进入到软件包的python文件夹 # cd python/ 授予install.sh可执行权限 # chmod +x install.sh 执行安装 # ./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. 5) 修改配置文件进入到安装目录，默认为/usr/local/lepus # cd /usr/local/lepus/ # vim etc/config.ini ###监控机MySQL数据库连接地址### [monitor_server] host="127.0.0.1" port=3306 user=" lepus_user " passwd="xxxxxx" dbname="lepus" 6) 启动Lepus （可选）此时，你可以执行启动命令启动lepus采集进程 [root@ebs-cloud lepus]# lepus start nohup: 把输出追加到"nohup.out" lepus server start success! 但是因为没有添加主机，所以查看日志会看到如下提示，属于正常提示。您也可以在部署完Lepus WEB控制台后再进行启动。 [root@ebs-cloud lepus]# tail -f logs/lepus.log 2015-08-03 13:09:09 [WARNING] check mongodb: not found any servers 2015-08-03 13:09:09 [INFO] check mongodb controller finished. 2015-08-03 13:09:12 [INFO] check redis controller started. 2015-08-03 13:09:12 [WARNING] check redis: not found any servers 2015-08-03 13:09:12 [INFO] check redis controller finished. 2015-08-03 13:09:15 [INFO] check os controller started. 2015-08-03 13:09:15 [WARNING] check os: not found any servers 2015-08-03 13:09:15 [INFO] check os controller finished. 2015-08-03 13:09:38 [INFO] alarm controller started. 2015-08-03 13:09:38 [INFO] alarm controller finished. Lepus采集程序安装完毕! ----------------------- [monitor_server] host="216.189.149.217" port=3306 user="lepus_user" passwd="xxxxxx" dbname="lepus" CREATE USER 'lepus'@'localhost' IDENTIFIED BY '***'; GRANT SUPER ON * . * TO 'lepus'@'localhost' IDENTIFIED BY '***' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; CREATE USER 'lepus'@'%' IDENTIFIED BY 'xxxxxx'; GRANT SUPER ON * . * TO 'lepus'@'%' IDENTIFIED BY '***' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;