MHA安装部署

参考: http://blog.csdn.net/st380109693/article/details/46044309 http://blog.itpub.net/14594028/viewspace-1073516/ http://www.tuicool.com/articles/qaqyAjE 参数详解 http://wubx.net/mha-parameters/ 命令详解 http://www.csdn123.com/html/itweb/20131024/184394.htm http://www.2cto.com/os/201508/431565.html ####################################安装 17.22.144.81 manager 17.22.144.82 node 主库 17.22.144.83 node 备库 17.22.144.84 node 备库 一 [阅读全文]

mysql同步监控脚本,发邮件提醒

[root@BJDbProdIP3134 ~]$crontab -l */5 * * * * /data/scripts/heartbeat_check_all.sh > /root/heartbeat_check_all.txt */5 * * * * ansible bj-master3306 -m command -a “/data/scripts/show_readonly_3306.sh” > /root/monitor-chk/check_master_readonly_3306.txt */5 * * * * ansible bj-slave3306 -m command -a “/data/scripts/show_readonly_3306.sh” > /root/monitor-chk/check_slave_readonly_3306.txt */15 * * * * grep -v 0. /root/heartbeat_check_all.txt && grep -v 0. /root/heartbeat_check_all.txt|mail -s “31.34Prodb-chk-heartbeat-alarm” wywmir@139.com,chengyun@neusoft.com,87512674@qq.com */15 * * * * grep -n ‘read’ /root/monitor-chk/check_master_readonly_3306.txt |grep -v OFF && /root/monitor-chk/chk_master_readonly_3306.sh */15 * [阅读全文]

yum\atp安装mysql5.7/6

centos7下安装 yum localinstall https://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm yum install -y mysql-community-server systemctl enable mysqld.service systemctl start mysqld.service cat /var/log/mysqld.log|grep 'A temporary password' systemctl stop firewalld.service 初始化密码 set password=password("123456"); ubuntu16下安装 sudo apt-get install software-properties-common $ sudo add-apt-repository -y ppa:ondrej/mysql-5.6 $ sudo apt-get update $ sudo apt-get install mysql-server-5.6 配置文 [阅读全文]