摘要: 今天很搞笑的遇到了一个问题 ,启用半同步插件竟然报错,ERROR 1030 (HY000): Got error 1 from storage engine 1.现象mysql> INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master. 阅读全文
posted @ 2020-03-17 16:21 刘启武 阅读(2119) 评论(0) 推荐(0) 编辑
摘要: 8.0.18 错误日志时间慢了8个小时2019-10-29T07:58:56.684916Z 0 [Note] [MY-011503] [Repl] Plugin group_replication reported: 'Group membership changed to 192.xxx.xxx 阅读全文
posted @ 2019-10-29 16:59 刘启武 阅读(383) 评论(0) 推荐(0) 编辑
摘要: 节点长时间RECOVERING 状态 MYSQL database replication Error MY-002061 start group_replication;ysql> select * from replication_group_members;+ + + + + + + +| C 阅读全文
posted @ 2019-10-29 16:44 刘启武 阅读(4516) 评论(0) 推荐(0) 编辑
摘要: mysql> start group_replication; ERROR 3092 (HY000): The server is not configured properly to be an active member of the group. Please see more details 阅读全文
posted @ 2019-10-28 15:07 刘启武 阅读(5415) 评论(1) 推荐(2) 编辑
摘要: mysql> START GROUP_REPLICATION; ERROR 3092 (HY000): The server is not configured properly to be an active member of the group. Please see more details 阅读全文
posted @ 2019-10-28 14:58 刘启武 阅读(4152) 评论(0) 推荐(0) 编辑
摘要: 方法如下:1、先执行下面的语句将维护计划的ID查出(msdb库下)select * from sysmaintplan_plans2、 将查出的ID填入到下面几句话中的''中,并执行。delete from sysmaintplan_log where plan_id = ''delete from 阅读全文
posted @ 2019-09-05 14:10 刘启武 阅读(1659) 评论(0) 推荐(0) 编辑
摘要: mysql> select concat("kill ",id,";") from information_schema.PROCESSLIST where command="Query" or command="Execute" into outfile "/tmp/kill.sql";ERROR 阅读全文
posted @ 2019-07-12 14:28 刘启武 阅读(433) 评论(0) 推荐(0) 编辑
摘要: keepalived-2.0.15]# ./configure --prefix=/usr/local/keepalivedchecking for a BSD-compatible install... /usr/bin/install -cchecking whether build envir 阅读全文
posted @ 2019-07-01 15:25 刘启武 阅读(633) 评论(0) 推荐(0) 编辑