摘要：
今天很搞笑的遇到了一个问题 ，启用半同步插件竟然报错，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
刘启武
阅读(2214)
评论(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
刘启武
阅读(390)
评论(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
刘启武
阅读(4680)
评论(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
刘启武
阅读(5684)
评论(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
刘启武
阅读(4526)
评论(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
刘启武
阅读(1683)
评论(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
刘启武
阅读(467)
评论(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
刘启武
阅读(674)
评论(0)
推荐(0)
浙公网安备 33010602011771号