mysql PXC集群脑裂及grastate.dat修改试验

2022-07-31 18:43:29

字体：大中小

来源：转载

供稿：网友

三台服务器做了 mysql PXC 集群

172.31.217.182 bd-dev-mingshuo-182

172.31.217.183 bd-dev-mingshuo-183

172.31.217.89   bd-dev-vertica-89

正常关闭 183 一个节点

mysqladmin -uroot -poracle -S /u01/mysql/3307/data/mysql.sock -P3307 shutdown

正常节点 log

2018-09-27T07:33:22.505216Z   0 [Note] WSREP: declaring c05737fd at tcp://172.31.217.89:4567 stable

2018-09-27T07:33:22.505345Z   0 [Note] WSREP: forgetting 12f1e199 (tcp://172.31.217.183:4567)

2018-09-27T07:33:22.511586Z   0 [Note] WSREP: Node 2331d3d7 state primary

2018-09-27T07:33:22.512245Z   0 [Note] WSREP: Current view of cluster as seen by this node

view   (view_id(PRIM,2331d3d7,12)

memb {

        2331d3d7,0

        c05737fd,0

        }

joined {

        }

left {

        }

partitioned {

        12f1e199,0

        }

)

2018-09-27T07:33:22.512303Z   0 [Note] WSREP: Save the discovered primary-component to disk

2018-09-27T07:33:22.512547Z   0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0,   memb_num = 2

2018-09-27T07:33:22.513157Z   0 [Note] WSREP: forgetting 12f1e199 (tcp://172.31.217.183:4567)

2018-09-27T07:33:22.513241Z   0 [Note] WSREP: STATE_EXCHANGE: sent state UUID:   9ccf0351-c227-11e8-ae6a-d3cac5b411a7

2018-09-27T07:33:22.514096Z   0 [Note] WSREP: STATE EXCHANGE: sent state msg:   9ccf0351-c227-11e8-ae6a-d3cac5b411a7

2018-09-27T07:33:22.514647Z   0 [Note] WSREP: STATE EXCHANGE: got state msg: 9ccf0351-c227-11e8-ae6a-d3cac5b411a7   from 0 (bd-dev-mingshuo-182)

2018-09-27T07:33:22.514661Z   0 [Note] WSREP: STATE EXCHANGE: got state msg:   9ccf0351-c227-11e8-ae6a-d3cac5b411a7 from 1 (bd-dev-vertica-89)

2018-09-27T07:33:22.514669Z   0 [Note] WSREP: Quorum results:

        version    = 4,

        component = PRIMARY,

        conf_id    = 11,

        members    = 2/2 (primary/total),

        act_id     = 27,

        last_appl. = 0,

        protocols = 0/8/3 (gcs/repl/appl),

        group UUID =   c057dbc5-c16e-11e8-a1a6-825ed9079934

2018-09-27T07:33:22.514675Z   0 [Note] WSREP: Flow-control interval: [141, 141]

2018-09-27T07:33:22.514679Z   0 [Note] WSREP: Trying to continue unpaused monitor

2018-09-27T07:33:22.514707Z   2 [Note] WSREP: New cluster view: global state:   c057dbc5-c16e-11e8-a1a6-825ed9079934:27, view# 12: Primary, number of nodes:   2, my index: 0, protocol version 3

2018-09-27T07:33:22.514713Z   2 [Note] WSREP: Setting wsrep_ready to true

2018-09-27T07:33:22.514719Z   2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.

2018-09-27T07:33:22.514727Z   2 [Note] WSREP: REPL Protocols: 8 (3, 2)

2018-09-27T07:33:22.514747Z   2 [Note] WSREP: Assign initial position for certification: 27, protocol   version: 3

2018-09-27T07:33:22.514830Z   0 [Note] WSREP: Service thread queue flushed.

2018-09-27T07:33:27.691129Z   0 [Note] WSREP: cleaning up 12f1e199   (tcp://172.31.217.183:4567)

mysql> select   * from t1;

+---+------+

| a | b    |

+---+------+

| 1 |    1 |

| 2 |    2 |

| 3 |    3 |

| 4 |    4 |

+---+------+

4 rows in set   (0.00 sec)

启动 183 节点

mysql -S   /u01/mysql/3307/data/mysql.sock -uroot -poracle -P3307

mysql> select   * from t1;

+---+------+

| a | b    |

+---+------+

| 1 |    1 |

| 2 |    2 |

| 3 |    3 |

| 4 |    4 |

+---+------+

4 rows in set   (0.00 sec)

增量数据已经同步过来了。

现在测试直接非正常关闭两个节点

将 182 和 183 两个节点进程直接 kill -9 杀掉

89 存活节点：

mysql> select   * from ming.t1;

ERROR   1047 (08S01): WSREP has not yet prepared node for application use

mysql> insert   into ming.t1 values(10,10);

ERROR   1047 (08S01): WSREP has not yet prepared node for application use

存活节点已经无法正常提供读写服务。

（编辑：错新网）

上一篇：MySQL数据库分布式事务XA的实现原理解析

下一篇：mysql登陆告错mysql unknown variable basedir