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

三台服务器做了 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:13.222079Z   0 [Note] WSREP: Received shutdown signal. Will sleep for 10 secs before   initiating shutdown. pxc_maint_mode switched to SHUTDOWN 2018-09-27T07:33:23.230509Z   0 [Note] WSREP: Stop replication 2018-09-27T07:33:23.230619Z   0 [Note] WSREP: Closing send monitor... 2018-09-27T07:33:23.230640Z   0 [Note] WSREP: Closed send monitor. 2018-09-27T07:33:23.230660Z   0 [Note] WSREP: gcomm: terminating thread 2018-09-27T07:33:23.230680Z   0 [Note] WSREP: gcomm: joining thread 2018-09-27T07:33:23.230827Z   0 [Note] WSREP: gcomm: closing backend 2018-09-27T07:33:23.231780Z   0 [Note] WSREP: Current view of cluster as seen by this node view   (view_id(NON_PRIM,12f1e199,11) memb {         12f1e199,0         } joined {         } left {         } partitioned {         2331d3d7,0         c05737fd,0         } ) 2018-09-27T07:33:23.231867Z   0 [Note] WSREP: Current view of cluster as seen by this node view ((empty)) 2018-09-27T07:33:23.232111Z   0 [Note] WSREP: gcomm: closed 2018-09-27T07:33:23.232165Z   0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0,   memb_num = 1 2018-09-27T07:33:23.232253Z   0 [Note] WSREP: Flow-control interval: [100, 100] 2018-09-27T07:33:23.232260Z   0 [Note] WSREP: Trying to continue unpaused monitor 2018-09-27T07:33:23.232264Z   0 [Note] WSREP: Received NON-PRIMARY. 2018-09-27T07:33:23.232268Z   0 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 27) 2018-09-27T07:33:23.232279Z   0 [Note] WSREP: Received self-leave message. 2018-09-27T07:33:23.232285Z   0 [Note] WSREP: Flow-control interval: [0, 0] 2018-09-27T07:33:23.232288Z   0 [Note] WSREP: Trying to continue unpaused monitor 2018-09-27T07:33:23.232291Z   0 [Note] WSREP: Received SELF-LEAVE. Closing connection. 2018-09-27T07:33:23.232295Z   0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 27) 2018-09-27T07:33:23.232302Z   0 [Note] WSREP: RECV thread exiting 0: Success 2018-09-27T07:33:23.232383Z   2 [Note] WSREP: New cluster view: global state:   c057dbc5-c16e-11e8-a1a6-825ed9079934:27, view# -1: non-Primary, number of   nodes: 1, my index: 0, protocol version 3 2018-09-27T07:33:23.232394Z   2 [Note] WSREP: Setting wsrep_ready to false 2018-09-27T07:33:23.232400Z   2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2018-09-27T07:33:23.232439Z   2 [Note] WSREP: New cluster view: global state:   c057dbc5-c16e-11e8-a1a6-825ed9079934:27, view# -1: non-Primary, number of   nodes: 0, my index: -1, protocol version 3 2018-09-27T07:33:23.232443Z   2 [Note] WSREP: Setting wsrep_ready to false 2018-09-27T07:33:23.232446Z   2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2018-09-27T07:33:23.232472Z   2 [Note] WSREP: applier thread exiting (code:0) 2018-09-27T07:33:23.232479Z   0 [Note] WSREP: recv_thread() joined. 2018-09-27T07:33:23.232502Z   0 [Note] WSREP: Closing replication queue. 2018-09-27T07:33:23.232509Z   0 [Note] WSREP: Closing slave action queue. 2018-09-27T07:33:23.232517Z   0 [Note] Giving 2 client threads a chance to die gracefully 2018-09-27T07:33:25.232639Z   0 [Note] WSREP: Waiting for active wsrep applier to exit 2018-09-27T07:33:25.232758Z   1 [Note] WSREP: rollbacker thread exiting 2018-09-27T07:33:25.232994Z   0 [Note] Giving 0 client threads a chance to die gracefully 2018-09-27T07:33:25.233010Z   0 [Note] Shutting down slave threads 2018-09-27T07:33:25.233025Z   0 [Note] Forcefully disconnecting 0 remaining clients 2018-09-27T07:33:25.233044Z   0 [Note] Event Scheduler: Purging the queue. 0 events 2018-09-27T07:33:25.242788Z   0 [Note] WSREP: Service thread queue flushed. 2018-09-27T07:33:25.250399Z   0 [Note] WSREP: MemPool(SlaveTrxHandle): hit ratio: 0, misses: 0, in use: 0,   in pool: 0 2018-09-27T07:33:25.250479Z   0 [Note] WSREP: Shifting CLOSED -> DESTROYED (TO: 27) 2018-09-27T07:33:25.259428Z   0 [Note] Binlog end 2018-09-27T07:33:25.261702Z   0 [Note] Shutting down plugin 'ngram' 2018-09-27T07:33:25.261721Z   0 [Note] Shutting down plugin 'partition' 2018-09-27T07:33:25.261726Z   0 [Note] Shutting down plugin 'ARCHIVE' 2018-09-27T07:33:25.261729Z   0 [Note] Shutting down plugin 'BLACKHOLE' 2018-09-27T07:33:25.261733Z   0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-09-27T07:33:25.261736Z   0 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES' 2018-09-27T07:33:25.261739Z   0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-09-27T07:33:25.261741Z   0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-09-27T07:33:25.261744Z   0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-09-27T07:33:25.261746Z   0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-09-27T07:33:25.261749Z   0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-09-27T07:33:25.261751Z   0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-09-27T07:33:25.261754Z   0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-09-27T07:33:25.261756Z   0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-09-27T07:33:25.261759Z   0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-09-27T07:33:25.261761Z   0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-09-27T07:33:25.261764Z   0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-09-27T07:33:25.261766Z   0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-09-27T07:33:25.261769Z   0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-09-27T07:33:25.261771Z   0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-09-27T07:33:25.261774Z   0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-09-27T07:33:25.261776Z   0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-09-27T07:33:25.261778Z   0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-09-27T07:33:25.261781Z   0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-09-27T07:33:25.261783Z   0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-09-27T07:33:25.261785Z   0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-09-27T07:33:25.261788Z   0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-09-27T07:33:25.261790Z   0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-09-27T07:33:25.261793Z   0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-09-27T07:33:25.261795Z   0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-09-27T07:33:25.261797Z   0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-09-27T07:33:25.261800Z   0 [Note] Shutting down plugin 'INNODB_CMP' 2018-09-27T07:33:25.261802Z   0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-09-27T07:33:25.261805Z   0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-09-27T07:33:25.261807Z   0 [Note] Shutting down plugin 'INNODB_TRX' 2018-09-27T07:33:25.261809Z   0 [Note] Shutting down plugin 'XTRADB_ZIP_DICT_COLS' 2018-09-27T07:33:25.261812Z   0 [Note] Shutting down plugin 'XTRADB_ZIP_DICT'