MYSQL
futurexxxxxx
一周一更吧
展开
-
Mysql主从校验工具之pt-table-checksum和pt-table-sync
Mysql主从校验工具之pt-table-checksum下载并安装percona-toolkit及所需要用到的依赖wget http://www.percona.com/downloads/percona-toolkit/LATEST/RPM/percona-toolkit-2.2.14-1.noarch.rpmyum install perl-IO-Socket-SSL perl-DBD-MySQL perl-Time-HiRes -yrpm -ivh percona-toolki原创 2020-12-22 14:50:40 · 214 阅读 · 0 评论 -
Liunx监控Mysql主从复制发生错误时发送报警邮件
#!/bin/bash# 数据库登录mysql="/usr/local/mysql/bin/mysql -uroot -p123456"message=($($mysql -e "show slave status\G;">sql.log))mes=`cat sql.log`while truedo # 检测关键字 array=($($mysql -e "show slave status\G;"|egrep '_Running:|Behind_Master|Last_SQL_E原创 2020-09-14 13:56:02 · 336 阅读 · 0 评论 -
Liunx下安装MYSQL8.0(一定要设置忽略大小写)
Liunx下安装MYSQL8.0并实现主从复制首先检查liunx是否已经存在Mysql文件或软件,有的话删除;查看软件:rpm -qa |grep mysql卸载软件:rpm remove mysql…(软件名称)查看文件:find / -name mysql删除文件:rm -rf /var/mysql(文件路径)安装依赖之类的yum -y install wget cmake gcc gcc-c++ ncurses ncurses-devel libaio-devel openss原创 2020-09-08 14:52:14 · 4592 阅读 · 2 评论 -
MYSQL基于GTID的主从复制
MYSQL基于GTID的主从复制my.cnf设置(全部服务器都要设置并重启MYSQL)log_slave_updates = 1gtid_mode = ONenforce_gtid_consistency = 1从库设置这里的192.168.0.120是指主库的IPCHANGE MASTER TO MASTER_HOST=“192.168.0.120”, MASTER_PORT=3306,MASTER_USER=‘原创 2020-09-07 11:39:09 · 531 阅读 · 0 评论