摘要: 环境:RHEL6.3 MySQL:5.7.19 GTID:ON mysqlbinlog skip gtids=TRUE /mysql/binlog/mysql bin.000001 |mysql uroot pfuckwisedu h127.1 mysqlbinlog skip gtids=TRUE 阅读全文
posted @ 2019-12-16 17:41 Coye 阅读(129) 评论(0) 推荐(0)
摘要: Plugin group_replication reported: '[GCS] Connection attempt from IP address ::ffff:10.57.19.100 refused. Address is not in the IP whitelist.' 版本:8.0. 阅读全文
posted @ 2019-12-05 17:41 Coye 阅读(2065) 评论(1) 推荐(1)
摘要: _ pstack 7359 pid.info pt pmp pid.info 阅读全文
posted @ 2019-05-24 13:49 Coye 阅读(141) 评论(0) 推荐(0)
摘要: Server 1 [mysqld] server configuration datadir=/data/s1 basedir=/mysql 5.7/ port=3306 socket=/s1.sock server_id=1 gtid_mode=ON enforce_gtid_consistenc 阅读全文
posted @ 2019-05-23 16:37 Coye 阅读(804) 评论(0) 推荐(0)
摘要: 1 [root@archsitdb203 ~] ip a 1: lo: mtu 16436 qdisc noqueue state UNKNOWN link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00 inet 127.0.0.1/8 scope 阅读全文
posted @ 2019-05-16 09:51 Coye 阅读(324) 评论(0) 推荐(0)
摘要: Navicat 11 连MySQL 8.0.16 报 Client does not support authentication。。。。。。。。 解决: alter user 'fabu'@'%' identified with mysql_native_password by 'FuckWise 阅读全文
posted @ 2019-04-29 15:48 Coye 阅读(704) 评论(0) 推荐(0)
摘要: 官档原文,懒得翻译了 "https://dev.mysql.com/doc/refman/5.7/en/innodb locks set.html" INSERT sets an exclusive lock on the inserted row. This lock is an index re 阅读全文
posted @ 2019-04-28 14:20 Coye 阅读(1108) 评论(0) 推荐(0)
摘要: 用XtraBackup对备份集进行apply log 的时候,卡在 xtrabackup 版本:2.4.3 InnoDB: Waited for 1535930 seconds for 128 pending reads 中了个BUG,乍一看现象是一样一样的。。。 只好升级xtrabackup 版本 阅读全文
posted @ 2019-04-19 09:08 Coye 阅读(394) 评论(0) 推荐(1)
摘要: "官网" "下载" 装包 yum y install make automake libtool pkgconfig libaio devel 编译安装 ./autogen.sh ./configure make j make install 官网给出的 "安装步骤" 漏了 这步,直接./confi 阅读全文
posted @ 2019-03-14 19:28 Coye 阅读(437) 评论(0) 推荐(0)
摘要: "Linux error numbers, straight from the horse's mouth. " define EPERM 1 / Operation not permitted / define ENOENT 2 / No such file or directory / defi 阅读全文
posted @ 2019-03-13 16:57 Coye 阅读(501) 评论(0) 推荐(0)