实验环境

centos6.5_x64


实验软件

mycheckpoint-208-1.noarch.rpm


软件安装

yum install -y python  python-devel  MySQL-python

yum install -y mysql-server mysql-libs  mysql-devel 

python --version

Python 2.7.5    安装python,并且版本大于2.4


mysqladmin -uroot password  数据库验证

mysql -uroot    -p

mysql> set global validate_password_policy=0;

mysql> set global validate_password_length=1;  关闭安全策略

mysql> ALTER user 'root'@'localhost' IDENTIFIED BY '123456';  root验证

mysql> create database mycheckpoint;

mysql> create user 'mycheck'@'localhost' identified by '123456';

mysql> grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;  授权root远程访问

mysql> grant all privileges on mycheckpoint.* to 'mycheck'@'localhost' identified by '123456';

myql> flush privileges;


mysql  -umycheck -p123456

mysql>


rpm -ivh  mycheckpoint-208-1.noarch.rpm

chkconfig --level 35 mysqld   on


mycheckpoint  --user=mycheck --password=数据库验证  --socket=/var/lib/mysql/mysql.sock  --database=mycheckpoint   测试获得测试数据库数据

nohup  mycheckpoint  --user=mycheck  --password=数据库验证  --socket=/var/lib/mysql/mysql.sock  --database=mycheckpoint  http &  获得数据后台运行


crontab   -e

*/5  1 * * *  root  nohup mycheckpoint  --user=mycheck --password=数据库验证  --socket=/var/lib/mysql/mysql.sock  --database=mycheckpoint

http  & 


netstat -tuplna | grep LISTEN

tcp       0      0 0.0.0.0:3306       0.0.0.0:*     LISTEN      26944/mysqld 

tcp       0      0 0.0.0.0:12306     0.0.0.0:*     LISTEN      27007/python


​http://serverip:12306/mycheckpoint​

mycheckpoint数据库性能监控_软件