mysql grastate.dat_PXC加入新节点避免SST时grastate.dat文件内容的修改问题

最新推荐文章于 2023-02-18 13:34:53 发布
最新推荐文章于 2023-02-18 13:34:53 发布
阅读量706 收藏
点赞数
文章标签： mysql grastate.dat
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_35715402/article/details/113674966
版权

PXC加入新节点避免SST时grastate.dat文件内容的修改问题

在主从同步完成并关闭实例后,需要修改grastate.dat中的seqno:到底应该填已经执行过最后的XID号(Executed_Gtid_Set:),还是,还是将从哪一个执行的XID号(Executed_Gtid_Set+1)?

分析结果:从以下操作看应该为从哪一个执行的XID号(Executed_Gtid_Set+1).比如:show master status的Executed_Gtid_Set是0a15ae1e-5e2f-ee17-4638-bcd794bde339:1-3363764,那应该填:3363765

#vi grastate.dat

# GALERA saved state

version: 2.1

uuid: f5ea51e1-a1d0-11e8-b9c7-43286b421cc6

seqno: ?????

safe_to_bootstrap: 0

操作命令集:

cd /3101/data/

cp -r /data/backup/2018-08-18_01-42-32/* .

chown -R mysql:mysql *

\\注:my.cnf 为去掉pxc参数的配置文件,my_pxc.cnf是有PXC参数的配置文质

/usr/local/pxc/bin/mysqld --defaults-file=/3101/my.cnf&

mysql -S /3101/tmp/mysql.sock -pzstzst

reset master;

set global gtid_purged='0a15ae1e-5e2f-ee17-4638-bcd794bde339:1-3204367';

change master to master_host='db210',master_port=3101,master_user='repl',master_password='repl4slave',master_auto_position=1;

start slave;

stop slave ;

show slave status\G;

Executed_Gtid_Set: 0a15ae1e-5e2f-ee17-4638-bcd794bde339:1-3363764

reset slave all;

root@localhost [(none)]>show master status;

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

| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |

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

| mysql-bin.000001 | 73162918 | | | 0a15ae1e-5e2f-ee17-4638-bcd794bde339:1-3363764 |

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

1 row in set (0.00 sec)

p

修改为已同步的XID号3363764,会提示:

#vi grastate.dat

# GALERA saved state

version: 2.1

uuid: f5ea51e1-a1d0-11e8-b9c7-43286b421cc6

seqno: 3363764

safe_to_bootstrap: 0

关键信息:

2018-08-18T05:12:40.016791Z 0 [Note] WSREP: Receiving IST... 0.0% (0/1 events) complete.

2018-08-18T05:12:40.022637Z 2 [ERROR] Slave SQL: Could not execute Write_rows event on table wenyz.t2; Duplicate entry '4080231' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log FIRST, end_log_pos 173, Error_code: 1062

以下为全日志文件:

2018-08-18T05:12:37.007155Z 0 [Warning] The syntax '--log_warnings/-W' is deprecated and will be removed in a future release. Please use '--log_error_verbosity' instead.

2018-08-18T05:12:37.007399Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2018-08-18T05:12:37.007467Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled

2018-08-18T05:12:37.007505Z 0 [Note] /usr/local/pxc/bin/mysqld (mysqld 5.7.22-22-29.26-log) starting as process 13561 ...

2018-08-18T05:12:37.011276Z 0 [Note] WSREP: Setting wsrep_ready to false

2018-08-18T05:12:37.011296Z 0 [Note] WSREP: No pre-stored wsrep-start position found. Skipping position initialization.

2018-08-18T05:12:37.011302Z 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/local/pxc/lib/libgalera_smm.so'

2018-08-18T05:12:37.016523Z 0 [Note] WSREP: wsrep_load(): Galera 3.26(r) by Codership Oy loaded successfully.

2018-08-18T05:12:37.016594Z 0 [Note] WSREP: CRC-32C: using hardware acceleration.

2018-08-18T05:12:37.017073Z 0 [Note] WSREP: Found saved state: f5ea51e1-a1d0-11e8-b9c7-43286b421cc6:3363764, safe_to_bootstrap: 0

2018-08-18T05:12:37.033739Z 0 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> f5ea51e1-a1d0-11e8-b9c7-43286b421cc6:3363764

2018-08-18T05:12:37.034737Z 0 [Note] WSREP: Assign initial position for certification: 3363764, protocol version: -1

2018-08-18T05:12:37.034770Z 0 [Note] WSREP: Preparing to initiate SST/IST

2018-08-18T05:12:37.034775Z 0 [Note] WSREP: Starting replication

2018-08-18T05:12:37.034791Z 0 [Note] WSREP: Setting initial position to f5ea51e1-a1d0-11e8-b9c7-43286b421cc6:3363764

2018-08-18T05:12:37.035054Z 0 [Note] WSREP: Using CRC-32C for message checksums.

2018-08-18T05:12:37.035171Z 0 [Note] WSREP: gcomm thread scheduling priority set to other:0

2018-08-18T05:12:37.035307Z 0 [Warning] WSREP: Fail to access the file (/3101/data//gvwstate.dat) error (No such file or directory). It is possible if node is booting for first time or re-booting after a graceful shutdown

2018-08-18T05:12:37.035316Z 0 [Note] WSREP: Restoring primary-component from disk failed. Either node is booting for first time or re-booting after a graceful shutdown

2018-08-18T05:12:37.035982Z 0 [Note] WSREP: GMCast version 0

2018-08-18T05:12:37.036299Z 0 [Note] WSREP: (52637524, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567

2018-08-18T05:12:37.036308Z 0 [Note] WSREP: (52637524, 'tcp://0.0.0.0:4567') multicast: , ttl: 1

2018-08-18T05:12:37.038548Z 0 [Note] WSREP: (52637524, 'tcp://0.0.0.0:4567') connection established to 52637524 tcp://192.168.99.212:4567

2018-08-18T05:12:37.038571Z 0 [Warning] WSREP: (52637524, 'tcp://0.0.0.0:4567') address 'tcp://192.168.99.212:4567' points to own listening address, blacklisting

2018-08-18T05:12:37.038789Z 0 [Note] WSREP: (52637524, 'tcp://0.0.0.0:4567') connection established to f5e9d0b5 tcp://192.168.99.210:4567

2018-08-18T05:12:37.038891Z 0 [Note] WSREP: (52637524, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers:

2018-08-18T05:12:37.039074Z 0 [Note] WSREP: (52637524, 'tcp://0.0.0.0:4567') connection established to 334d1dc3 tcp://192.168.99.211:4567

2018-08-18T05:12:37.538670Z 0 [Note] WSREP: declaring 334d1dc3 at tcp://192.168.99.211:4567 stable

2018-08-18T05:12:37.538705Z 0 [Note] WSREP: declaring f5e9d0b5 at tcp://192.168.99.210:4567 stable

2018-08-18T05:12:37.539056Z 0 [Note] WSREP: Node 334d1dc3 state primary

2018-08-18T05:12:37.539426Z 0 [Note] WSREP: Current view of cluster as seen by this node

view (view_id(PRIM,334d1dc3,27)

memb {

334d1dc3,0

52637524,0

f5e9d0b5,0

}

joined {

}

left {

}

)

2018-08-18T05:12:37.539444Z 0 [Note] WSREP: Save the discovered primary-component to disk

2018-08-18T05:12:38.037701Z 0 [Note] WSREP: gcomm: connected

2018-08-18T05:12:38.037800Z 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)

2018-08-18T05:12:38.037969Z 0 [Note] WSREP: Waiting for SST/IST to complete.

2018-08-18T05:12:38.037973Z 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 3

2018-08-18T05:12:38.038003Z 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.

2018-08-18T05:12:38.038072Z 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 709b1607-a2a5-11e8-bf12-4fc225cb1a6b

2018-08-18T05:12:38.038082Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: 709b1607-a2a5-11e8-bf12-4fc225cb1a6b from 0 (db211)

2018-08-18T05:12:38.038089Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: 709b1607-a2a5-11e8-bf12-4fc225cb1a6b from 2 (db210)

2018-08-18T05:12:38.038492Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: 709b1607-a2a5-11e8-bf12-4fc225cb1a6b from 1 (db212)

2018-08-18T05:12:38.038503Z 0 [Note] WSREP: Quorum results:

version = 4,

component = PRIMARY,

conf_id = 26,

members = 2/3 (primary/total),

act_id = 3363765,

last_appl. = -1,

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

group UUID = f5ea51e1-a1d0-11e8-b9c7-43286b421cc6

2018-08-18T05:12:38.038510Z 0 [Note] WSREP: Flow-control interval: [173, 173]

2018-08-18T05:12:38.038513Z 0 [Note] WSREP: Trying to continue unpaused monitor

2018-08-18T05:12:38.038518Z 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 3363765)

2018-08-18T05:12:38.038584Z 2 [Note] WSREP: State transfer required:

Group state: f5ea51e1-a1d0-11e8-b9c7-43286b421cc6:3363765

Local state: f5ea51e1-a1d0-11e8-b9c7-43286b421cc6:3363764

2018-08-18T05:12:38.038605Z 2 [Note] WSREP: REPL Protocols: 8 (3, 2)

2018-08-18T05:12:38.038617Z 2 [Note] WSREP: New cluster view: global state: f5ea51e1-a1d0-11e8-b9c7-43286b421cc6:3363765, view# 27: Primary, number of nodes: 3, my index: 1, protocol version 3

2018-08-18T05:12:38.038620Z 2 [Note] WSREP: Setting wsrep_ready to true

2018-08-18T05:12:38.038623Z 2 [Warning] WSREP: Gap in state sequence. Need state transfer.

2018-08-18T05:12:38.038626Z 2 [Note] WSREP: Setting wsrep_ready to false

2018-08-18T05:12:38.548564Z 2 [Note] WSREP: Prepared SST/IST request: xtrabackup-v2|192.168.99.212:4588/xtrabackup_sst//1

2018-08-18T05:12:38.548592Z 2 [Note] WSREP: Auto Increment Offset/Increment re-align with cluster membership change (Offset: 1 -> 2) (Increment: 1 -> 3)

2018-08-18T05:12:38.548612Z 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.

2018-08-18T05:12:38.548633Z 2 [Note] WSREP: Assign initial position for certification: 3363765, protocol version: 3

2018-08-18T05:12:38.548690Z 0 [Note] WSREP: Service thread queue flushed.

2018-08-18T05:12:38.548733Z 2 [Note] WSREP: Check if state gap can be serviced using IST

2018-08-18T05:12:38.548853Z 2 [Note] WSREP: IST receiver addr using tcp://192.168.99.212:4568

2018-08-18T05:12:38.549017Z 2 [Note] WSREP: Prepared IST receiver, listening at: tcp://192.168.99.212:4568

2018-08-18T05:12:38.549038Z 2 [Note] WSREP: State gap can be likely serviced using IST. SST request though present would be void.

2018-08-18T05:12:38.549436Z 0 [Note] WSREP: Member 1.0 (db212) requested state transfer from '*any*'. Selected 2.0 (db210)(SYNCED) as donor.

2018-08-18T05:12:38.549451Z 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 3363765)

2018-08-18T05:12:38.549489Z 2 [Note] WSREP: Requesting state transfer: success, donor: 2

2018-08-18T05:12:38.549504Z 2 [Note] WSREP: GCache history reset: f5ea51e1-a1d0-11e8-b9c7-43286b421cc6:0 -> f5ea51e1-a1d0-11e8-b9c7-43286b421cc6:3363765

2018-08-18T05:12:38.881221Z 0 [Note] WSREP: 2.0 (db210): State transfer to 1.0 (db212) complete.

2018-08-18T05:12:38.881584Z 0 [Note] WSREP: Member 2.0 (db210) synced with group.

2018-08-18T05:12:38.900497Z WSREP_SST: [INFO] xtrabackup_ist received from donor: Running IST

2018-08-18T05:12:38.902699Z WSREP_SST: [INFO] Galera co-ords from recovery: f5ea51e1-a1d0-11e8-b9c7-43286b421cc6:3363764

2018-08-18T05:12:38.914099Z 0 [Note] WSREP: SST complete, seqno: 3363764

2018-08-18T05:12:38.916064Z 0 [Note] InnoDB: PUNCH HOLE support available

2018-08-18T05:12:38.916075Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2018-08-18T05:12:38.916079Z 0 [Note] InnoDB: Uses event mutexes

2018-08-18T05:12:38.916083Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier

2018-08-18T05:12:38.916087Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.7

2018-08-18T05:12:38.916090Z 0 [Note] InnoDB: Using Linux native AIO

2018-08-18T05:12:38.916354Z 0 [Note] InnoDB: Number of pools: 1

2018-08-18T05:12:38.916489Z 0 [Note] InnoDB: Using CPU crc32 instructions

2018-08-18T05:12:38.918710Z 0 [Note] InnoDB: Initializing buffer pool, total size = 5G, instances = 1, chunk size = 128M

2018-08-18T05:12:39.097918Z 0 [Note] InnoDB: Completed initialization of buffer pool

2018-08-18T05:12:39.142187Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2018-08-18T05:12:39.178972Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /data/pxc/mysql3101/data/xb_doublewrite

2018-08-18T05:12:39.180706Z 0 [Note] InnoDB: Highest supported file format is Barracuda.

2018-08-18T05:12:39.247496Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /data/pxc/mysql3101/data/xb_doublewrite, size 3932160 bytes

2018-08-18T05:12:39.382191Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2018-08-18T05:12:39.382307Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2018-08-18T05:12:39.413135Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

2018-08-18T05:12:39.414495Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.

2018-08-18T05:12:39.414508Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.

2018-08-18T05:12:39.414864Z 0 [Note] InnoDB: Waiting for purge to start

2018-08-18T05:12:39.465228Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.22-rel22 started; log sequence number 1767442014

2018-08-18T05:12:39.465388Z 0 [Note] InnoDB: Loading buffer pool(s) from /data/pxc/mysql3101/data/ib_buffer_pool

2018-08-18T05:12:39.465986Z 0 [Note] Plugin 'FEDERATED' is disabled.

2018-08-18T05:12:39.990734Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.

2018-08-18T05:12:39.990761Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.

2018-08-18T05:12:39.991586Z 0 [Warning] CA certificate ca.pem is self signed.

2018-08-18T05:12:39.991651Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.

2018-08-18T05:12:39.991785Z 0 [Note] Server hostname (bind-address): '*'; port: 3101

2018-08-18T05:12:39.991842Z 0 [Note] IPv6 is available.

2018-08-18T05:12:39.991859Z 0 [Note] - '::' resolves to '::';

2018-08-18T05:12:39.991898Z 0 [Note] Server socket created on IP: '::'.

2018-08-18T05:12:40.002996Z 0 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=db212-relay-bin' to avoid this problem.

2018-08-18T05:12:40.007070Z 0 [Warning] Recovery from master pos 226323000 and file mysql-bin.000006 for channel ''. Previous relay log pos and relay log file had been set to 76670171, ./db212-relay-bin.000002 respectively.

2018-08-18T05:12:40.014932Z 0 [Note] Event Scheduler: Loaded 0 events

2018-08-18T05:12:40.015044Z 0 [Note] WSREP: Signalling provider to continue on SST completion.

2018-08-18T05:12:40.016564Z 0 [Note] WSREP: Initialized wsrep sidno 2

2018-08-18T05:12:40.016594Z 0 [Note] WSREP: SST received: f5ea51e1-a1d0-11e8-b9c7-43286b421cc6:3363764

2018-08-18T05:12:40.016670Z 2 [Note] WSREP: Receiving IST: 1 writesets, seqnos 3363764-3363765

2018-08-18T05:12:40.016694Z 0 [Note] /usr/local/pxc/bin/mysqld: ready for connections.

Version: '5.7.22-22-29.26-log' socket: '/3101/tmp/mysql.sock' port: 3101 Percona XtraDB Cluster binary (GPL) 5.7.22-29.26, Revision da86071, wsrep_29.26

2018-08-18T05:12:40.016791Z 0 [Note] WSREP: Receiving IST... 0.0% (0/1 events) complete.

2018-08-18T05:12:40.022637Z 2 [ERROR] Slave SQL: Could not execute Write_rows event on table wenyz.t2; Duplicate entry '4080231' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log FIRST, end_log_pos 173, Error_code: 1062

2018-08-18T05:12:40.022652Z 2 [Warning] WSREP: RBR event 3 Write_rows apply warning: 121, 3363765

2018-08-18T05:12:40.022805Z 2 [Note] WSREP: Applier statement rollback needed

2018-08-18T05:12:40.022834Z 2 [Warning] WSREP: Failed to apply app buffer: seqno: 3363765, status: 1

at galera/src/trx_handle.cpp:apply():351

Retrying 2th time

2018-08-18T05:12:40.022943Z 2 [ERROR] Slave SQL: Could not execute Write_rows event on table wenyz.t2; Duplicate entry '4080231' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log FIRST, end_log_pos 173, Error_code: 1062

2018-08-18T05:12:40.022955Z 2 [Warning] WSREP: RBR event 3 Write_rows apply warning: 121, 3363765

2018-08-18T05:12:40.023065Z 2 [Note] WSREP: Applier statement rollback needed

2018-08-18T05:12:40.023091Z 2 [Warning] WSREP: Failed to apply app buffer: seqno: 3363765, status: 1

at galera/src/trx_handle.cpp:apply():351

Retrying 3th time

2018-08-18T05:12:40.023168Z 2 [ERROR] Slave SQL: Could not execute Write_rows event on table wenyz.t2; Duplicate entry '4080231' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log FIRST, end_log_pos 173, Error_code: 1062

2018-08-18T05:12:40.023175Z 2 [Warning] WSREP: RBR event 3 Write_rows apply warning: 121, 3363765

2018-08-18T05:12:40.023829Z 2 [Note] WSREP: Applier statement rollback needed

2018-08-18T05:12:40.023854Z 2 [Warning] WSREP: Failed to apply app buffer: seqno: 3363765, status: 1

at galera/src/trx_handle.cpp:apply():351

Retrying 4th time

2018-08-18T05:12:40.023945Z 2 [ERROR] Slave SQL: Could not execute Write_rows event on table wenyz.t2; Duplicate entry '4080231' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log FIRST, end_log_pos 173, Error_code: 1062

2018-08-18T05:12:40.023963Z 2 [Warning] WSREP: RBR event 3 Write_rows apply warning: 121, 3363765

2018-08-18T05:12:40.024520Z 2 [Note] WSREP: Applier statement rollback needed

2018-08-18T05:12:40.024569Z 2 [ERROR] WSREP: receiving IST failed, node restart required: Failed to apply trx 3363765 4 times

2018-08-18T05:12:40.024583Z 2 [ERROR] WSREP: failed trx: source: f5e9d0b5-a1d0-11e8-a8ab-fb9117856933 version: 3 local: 0 state: APPLYING flags: 257 conn_id: 461 trx_id: 3365041 seqnos (l: -1, g: 3363765, s: 3363764, d: 3363764, ts: 1008762593706070)

2018-08-18T05:12:40.538080Z 0 [Note] WSREP: (52637524, 'tcp://0.0.0.0:4567') turning message relay requesting off

2018-08-18T05:12:40.731840Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180818 13:12:40

实例启来了,但状态不对(wsrep_local_state=1):

root@localhost [(none)]>show master status;

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

| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |

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

| mysql-bin.000002 | 194 | | | 0a15ae1e-5e2f-ee17-4638-bcd794bde339:1-3363764 |

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

1 row in set (0.00 sec)

root@localhost [(none)]>show global status like '%wsrep%';

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

| Variable_name | Value |

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

| wsrep_local_state_uuid | f5ea51e1-a1d0-11e8-b9c7-43286b421cc6 |

| wsrep_protocol_version | 8 |

| wsrep_last_applied | 3363764 |

| wsrep_last_committed | 3363764 |

| wsrep_replicated | 0 |

| wsrep_replicated_bytes | 0 |

| wsrep_repl_keys | 0 |

| wsrep_repl_keys_bytes | 0 |

| wsrep_repl_data_bytes | 0 |

| wsrep_repl_other_bytes | 0 |

| wsrep_received | 1 |

| wsrep_received_bytes | 277 |

| wsrep_local_commits | 0 |

| wsrep_local_cert_failures | 0 |

| wsrep_local_replays | 0 |

| wsrep_local_send_queue | 0 |

| wsrep_local_send_queue_max | 1 |

| wsrep_local_send_queue_min | 0 |

| wsrep_local_send_queue_avg | 0.000000 |

| wsrep_local_recv_queue | 0 |

| wsrep_local_recv_queue_max | 1 |

| wsrep_local_recv_queue_min | 0 |

| wsrep_local_recv_queue_avg | 0.000000 |

| wsrep_local_cached_downto | 0 |

| wsrep_flow_control_paused_ns | 0 |

| wsrep_flow_control_paused | 0.000000 |

| wsrep_flow_control_sent | 0 |

| wsrep_flow_control_recv | 0 |

| wsrep_flow_control_interval | [ 173, 173 ] |

| wsrep_flow_control_interval_low | 173 |

| wsrep_flow_control_interval_high | 173 |

| wsrep_flow_control_status | OFF |

| wsrep_cert_deps_distance | 0.000000 |

| wsrep_apply_oooe | 0.000000 |

| wsrep_apply_oool | 0.000000 |

| wsrep_apply_window | 1.000000 |

| wsrep_commit_oooe | 0.000000 |

| wsrep_commit_oool | 0.000000 |

| wsrep_commit_window | 0.000000 |

| wsrep_local_state | 1 |

| wsrep_local_state_comment | Joining: receiving State Transfer |

| wsrep_cert_index_size | 0 |

| wsrep_cert_bucket_count | 22 |

| wsrep_gcache_pool_size | 1536 |

| wsrep_causal_reads | 0 |

| wsrep_cert_interval | 0.000000 |

| wsrep_ist_receive_status | 100% complete, received seqno 3363765 of 3363765-3363765 |

| wsrep_ist_receive_seqno_start | 3363765 |

| wsrep_ist_receive_seqno_current | 3363765 |

| wsrep_ist_receive_seqno_end | 3363765 |

| wsrep_incoming_addresses | 192.168.99.211:3101,192.168.99.212:3101,192.168.99.210:3101 |

| wsrep_desync_count | 0 |

| wsrep_evs_delayed | |

| wsrep_evs_evict_list | |

| wsrep_evs_repl_latency | 0/0/0/0/0 |

| wsrep_evs_state | OPERATIONAL |

| wsrep_gcomm_uuid | 52637524-a2a5-11e8-9202-5e6bd08af1e3 |

| wsrep_cluster_conf_id | 27 |

| wsrep_cluster_size | 3 |

| wsrep_cluster_state_uuid | f5ea51e1-a1d0-11e8-b9c7-43286b421cc6 |

| wsrep_cluster_status | Primary |

| wsrep_connected | ON |

| wsrep_local_bf_aborts | 0 |

| wsrep_local_index | 1 |

| wsrep_provider_name | Galera |

| wsrep_provider_vendor | Codership Oy |

| wsrep_provider_version | 3.26(r) |

| wsrep_ready | OFF |

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

68 rows in set (0.01 sec)

修改为GTID+1的XID(3363765)的执行情况

[root@db212_15:53:31 /3101/data]

#cat grastate.dat

# GALERA saved state

version: 2.1

uuid: f5ea51e1-a1d0-11e8-b9c7-43286b421cc6

seqno: 3363765

safe_to_bootstrap: 0

error.log

#vi error.log

2018-08-18T08:11:19.233282Z 0 [Warning] The syntax '--log_warnings/-W' is deprecated and will be removed in a future release. Please use '--log_error_verbosity' instead.

2018-08-18T08:11:19.233530Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2018-08-18T08:11:19.233598Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled

2018-08-18T08:11:19.233637Z 0 [Note] /usr/local/pxc/bin/mysqld (mysqld 5.7.22-22-29.26-log) starting as process 14354 ...

2018-08-18T08:11:19.237530Z 0 [Note] WSREP: Setting wsrep_ready to false

2018-08-18T08:11:19.237549Z 0 [Note] WSREP: No pre-stored wsrep-start position found. Skipping position initialization.

2018-08-18T08:11:19.237555Z 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/local/pxc/lib/libgalera_smm.so'

2018-08-18T08:11:19.242964Z 0 [Note] WSREP: wsrep_load(): Galera 3.26(r) by Codership Oy loaded successfully.

2018-08-18T08:11:19.243040Z 0 [Note] WSREP: CRC-32C: using hardware acceleration.

2018-08-18T08:11:19.243521Z 0 [Note] WSREP: Found saved state: f5ea51e1-a1d0-11e8-b9c7-43286b421cc6:3363765, safe_to_bootstrap: 0

2018-08-18T08:11:19.261079Z 0 [Note] WSREP: GCache history reset: f5ea51e1-a1d0-11e8-b9c7-43286b421cc6:0 -> f5ea51e1-a1d0-11e8-b9c7-43286b421cc6:3363765

2018-08-18T08:11:19.261575Z 0 [Note] WSREP: Assign initial position for certification: 3363765, protocol version: -1

2018-08-18T08:11:19.261594Z 0 [Note] WSREP: Preparing to initiate SST/IST

2018-08-18T08:11:19.261598Z 0 [Note] WSREP: Starting replication

2018-08-18T08:11:19.261612Z 0 [Note] WSREP: Setting initial position to f5ea51e1-a1d0-11e8-b9c7-43286b421cc6:3363765

2018-08-18T08:11:19.261802Z 0 [Note] WSREP: Using CRC-32C for message checksums.

2018-08-18T08:11:19.261905Z 0 [Note] WSREP: gcomm thread scheduling priority set to other:0

2018-08-18T08:11:19.262020Z 0 [Warning] WSREP: Fail to access the file (/3101/data//gvwstate.dat) error (No such file or directory). It is possible if node is booting for first time or re-booting after a graceful shutdown

2018-08-18T08:11:19.262028Z 0 [Note] WSREP: Restoring primary-component from disk failed. Either node is booting for first time or re-booting after a graceful shutdown

2018-08-18T08:11:19.262665Z 0 [Note] WSREP: GMCast version 0

2018-08-18T08:11:19.262992Z 0 [Note] WSREP: (495569ff, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567

2018-08-18T08:11:19.263006Z 0 [Note] WSREP: (495569ff, 'tcp://0.0.0.0:4567') multicast: , ttl: 1

2018-08-18T08:11:19.264937Z 0 [Note] WSREP: (495569ff, 'tcp://0.0.0.0:4567') connection established to 495569ff tcp://192.168.99.212:4567

2018-08-18T08:11:19.264958Z 0 [Warning] WSREP: (495569ff, 'tcp://0.0.0.0:4567') address 'tcp://192.168.99.212:4567' points to own listening address, blacklisting

2018-08-18T08:11:19.265358Z 0 [Note] WSREP: (495569ff, 'tcp://0.0.0.0:4567') connection established to 334d1dc3 tcp://192.168.99.211:4567

2018-08-18T08:11:19.265456Z 0 [Note] WSREP: (495569ff, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers:

2018-08-18T08:11:19.265484Z 0 [Note] WSREP: (495569ff, 'tcp://0.0.0.0:4567') connection established to f5e9d0b5 tcp://192.168.99.210:4567

2018-08-18T08:11:19.764859Z 0 [Note] WSREP: declaring 334d1dc3 at tcp://192.168.99.211:4567 stable

2018-08-18T08:11:19.764897Z 0 [Note] WSREP: declaring f5e9d0b5 at tcp://192.168.99.210:4567 stable

2018-08-18T08:11:19.765236Z 0 [Note] WSREP: Node 334d1dc3 state primary

2018-08-18T08:11:19.765538Z 0 [Note] WSREP: Current view of cluster as seen by this node

view (view_id(PRIM,334d1dc3,31)

memb {

334d1dc3,0

495569ff,0

f5e9d0b5,0

}

joined {

}

left {

}

)

2018-08-18T08:11:19.765550Z 0 [Note] WSREP: Save the discovered primary-component to disk

2018-08-18T08:11:20.264288Z 0 [Note] WSREP: gcomm: connected

2018-08-18T08:11:20.264384Z 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)

2018-08-18T08:11:20.264519Z 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 3

2018-08-18T08:11:20.264589Z 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.

2018-08-18T08:11:20.264590Z 0 [Note] WSREP: Waiting for SST/IST to complete.

2018-08-18T08:11:20.264625Z 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 67952d95-a2be-11e8-81ed-abb61082a544

2018-08-18T08:11:20.264634Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: 67952d95-a2be-11e8-81ed-abb61082a544 from 0 (db211)

2018-08-18T08:11:20.264640Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: 67952d95-a2be-11e8-81ed-abb61082a544 from 2 (db210)

2018-08-18T08:11:20.265036Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: 67952d95-a2be-11e8-81ed-abb61082a544 from 1 (db212)

2018-08-18T08:11:20.265056Z 0 [Note] WSREP: Quorum results:

version = 4,

component = PRIMARY,

conf_id = 30,

members = 2/3 (primary/total),

act_id = 3443542,

last_appl. = -1,

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

group UUID = f5ea51e1-a1d0-11e8-b9c7-43286b421cc6

2018-08-18T08:11:20.265063Z 0 [Note] WSREP: Flow-control interval: [173, 173]

2018-08-18T08:11:20.265066Z 0 [Note] WSREP: Trying to continue unpaused monitor

2018-08-18T08:11:20.265071Z 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 3443542)

2018-08-18T08:11:20.265135Z 1 [Note] WSREP: State transfer required:

Group state: f5ea51e1-a1d0-11e8-b9c7-43286b421cc6:3443542

Local state: f5ea51e1-a1d0-11e8-b9c7-43286b421cc6:3363765

2018-08-18T08:11:20.265155Z 1 [Note] WSREP: REPL Protocols: 8 (3, 2)

2018-08-18T08:11:20.265166Z 1 [Note] WSREP: New cluster view: global state: f5ea51e1-a1d0-11e8-b9c7-43286b421cc6:3443542, view# 31: Primary, number of nodes: 3, my index: 1, protocol version 3

2018-08-18T08:11:20.265170Z 1 [Note] WSREP: Setting wsrep_ready to true

2018-08-18T08:11:20.265173Z 1 [Warning] WSREP: Gap in state sequence. Need state transfer.

2018-08-18T08:11:20.265175Z 1 [Note] WSREP: Setting wsrep_ready to false

2018-08-18T08:11:20.777717Z 1 [Note] WSREP: Prepared SST/IST request: xtrabackup-v2|192.168.99.212:4588/xtrabackup_sst//1

2018-08-18T08:11:20.777738Z 1 [Note] WSREP: Auto Increment Offset/Increment re-align with cluster membership change (Offset: 1 -> 2) (Increment: 1 -> 3)

2018-08-18T08:11:20.777761Z 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.

2018-08-18T08:11:20.777783Z 1 [Note] WSREP: Assign initial position for certification: 3443542, protocol version: 3

2018-08-18T08:11:20.777841Z 0 [Note] WSREP: Service thread queue flushed.

2018-08-18T08:11:20.777897Z 1 [Note] WSREP: Check if state gap can be serviced using IST

2018-08-18T08:11:20.778016Z 1 [Note] WSREP: IST receiver addr using tcp://192.168.99.212:4568

2018-08-18T08:11:20.778164Z 1 [Note] WSREP: Prepared IST receiver, listening at: tcp://192.168.99.212:4568

2018-08-18T08:11:20.778182Z 1 [Note] WSREP: State gap can be likely serviced using IST. SST request though present would be void.

2018-08-18T08:11:20.778608Z 0 [Note] WSREP: Member 1.0 (db212) requested state transfer from '*any*'. Selected 2.0 (db210)(SYNCED) as donor.

2018-08-18T08:11:20.778620Z 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 3443542)

2018-08-18T08:11:20.778658Z 1 [Note] WSREP: Requesting state transfer: success, donor: 2

2018-08-18T08:11:20.778680Z 1 [Note] WSREP: GCache history reset: f5ea51e1-a1d0-11e8-b9c7-43286b421cc6:0 -> f5ea51e1-a1d0-11e8-b9c7-43286b421cc6:3443542

2018-08-18T08:11:21.108717Z 0 [Note] WSREP: 2.0 (db210): State transfer to 1.0 (db212) complete.

2018-08-18T08:11:21.109088Z 0 [Note] WSREP: Member 2.0 (db210) synced with group.

2018-08-18T08:11:21.127557Z WSREP_SST: [INFO] xtrabackup_ist received from donor: Running IST

2018-08-18T08:11:21.129735Z WSREP_SST: [INFO] Galera co-ords from recovery: f5ea51e1-a1d0-11e8-b9c7-43286b421cc6:3363765

2018-08-18T08:11:21.140447Z 0 [Note] WSREP: SST complete, seqno: 3363765

2018-08-18T08:11:21.142362Z 0 [Note] InnoDB: PUNCH HOLE support available

2018-08-18T08:11:21.142385Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2018-08-18T08:11:21.142389Z 0 [Note] InnoDB: Uses event mutexes

2018-08-18T08:11:21.142393Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier

2018-08-18T08:11:21.142396Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.7

2018-08-18T08:11:21.142400Z 0 [Note] InnoDB: Using Linux native AIO

2018-08-18T08:11:21.142716Z 0 [Note] InnoDB: Number of pools: 1

2018-08-18T08:11:21.142850Z 0 [Note] InnoDB: Using CPU crc32 instructions

2018-08-18T08:11:21.145049Z 0 [Note] InnoDB: Initializing buffer pool, total size = 5G, instances = 1, chunk size = 128M

2018-08-18T08:11:21.304608Z 0 [Note] InnoDB: Completed initialization of buffer pool

2018-08-18T08:11:21.344323Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2018-08-18T08:11:21.389070Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /data/pxc/mysql3101/data/xb_doublewrite

2018-08-18T08:11:21.391376Z 0 [Note] InnoDB: Highest supported file format is Barracuda.

2018-08-18T08:11:21.436004Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /data/pxc/mysql3101/data/xb_doublewrite, size 3932160 bytes

2018-08-18T08:11:21.573504Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2018-08-18T08:11:21.573610Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2018-08-18T08:11:21.604616Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

2018-08-18T08:11:21.605965Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.

2018-08-18T08:11:21.605977Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.

2018-08-18T08:11:21.606305Z 0 [Note] InnoDB: Waiting for purge to start

2018-08-18T08:11:21.656732Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.22-rel22 started; log sequence number 1767492650

2018-08-18T08:11:21.656892Z 0 [Note] InnoDB: Loading buffer pool(s) from /data/pxc/mysql3101/data/ib_buffer_pool

2018-08-18T08:11:21.657052Z 0 [Note] Plugin 'FEDERATED' is disabled.

2018-08-18T08:11:21.674392Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.

2018-08-18T08:11:21.674407Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.

2018-08-18T08:11:21.675138Z 0 [Warning] CA certificate ca.pem is self signed.

2018-08-18T08:11:21.675194Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.

2018-08-18T08:11:21.675325Z 0 [Note] Server hostname (bind-address): '*'; port: 3101

2018-08-18T08:11:21.675378Z 0 [Note] IPv6 is available.

2018-08-18T08:11:21.675391Z 0 [Note] - '::' resolves to '::';

2018-08-18T08:11:21.675406Z 0 [Note] Server socket created on IP: '::'.

2018-08-18T08:11:21.694594Z 0 [Note] Event Scheduler: Loaded 0 events

2018-08-18T08:11:21.694696Z 0 [Note] WSREP: Signalling provider to continue on SST completion.

2018-08-18T08:11:21.694716Z 0 [Note] WSREP: Initialized wsrep sidno 2

2018-08-18T08:11:21.694734Z 0 [Note] WSREP: SST received: f5ea51e1-a1d0-11e8-b9c7-43286b421cc6:3363765

2018-08-18T08:11:21.694799Z 1 [Note] WSREP: Receiving IST: 79777 writesets, seqnos 3363765-3443542

2018-08-18T08:11:21.694827Z 0 [Note] /usr/local/pxc/bin/mysqld: ready for connections.

Version: '5.7.22-22-29.26-log' socket: '/3101/tmp/mysql.sock' port: 3101 Percona XtraDB Cluster binary (GPL) 5.7.22-29.26, Revision da86071, wsrep_29.26

2018-08-18T08:11:21.694933Z 0 [Note] WSREP: Receiving IST... 0.0% ( 0/79777 events) complete.

2018-08-18T08:11:21.803155Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180818 16:11:21

2018-08-18T08:11:22.764669Z 0 [Note] WSREP: (495569ff, 'tcp://0.0.0.0:4567') turning message relay requesting off

2018-08-18T08:11:31.696659Z 0 [Note] WSREP: Receiving IST... 83.8% (66816/79777 events) complete.

2018-08-18T08:11:33.502974Z 0 [Note] WSREP: Receiving IST...100.0% (79777/79777 events) complete.

2018-08-18T08:11:33.503181Z 1 [Note] WSREP: IST received: f5ea51e1-a1d0-11e8-b9c7-43286b421cc6:3443542

2018-08-18T08:11:33.503586Z 0 [Note] WSREP: 1.0 (db212): State transfer from 2.0 (db210) complete.

2018-08-18T08:11:33.503600Z 0 [Note] WSREP: SST leaving flow control

2018-08-18T08:11:33.503606Z 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 3443542)

2018-08-18T08:11:33.503913Z 0 [Note] WSREP: Member 1.0 (db212) synced with group.

2018-08-18T08:11:33.503925Z 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 3443542)

2018-08-18T08:11:33.503943Z 1 [Note] WSREP: Synchronized with group, ready for connections

2018-08-18T08:11:33.503952Z 1 [Note] WSREP: Setting wsrep_ready to true

2018-08-18T08:11:33.503956Z 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.

Current database: *** NONE ***

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

| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |

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

| mysql-bin.000003 | 194 | | | 0a15ae1e-5e2f-ee17-4638-bcd794bde339:1-3363764 |

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

1 row in set (0.00 sec)

root@localhost [(none)]>show global status like '%wsrep%';

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

| Variable_name | Value |

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

| wsrep_local_state_uuid | f5ea51e1-a1d0-11e8-b9c7-43286b421cc6 |

| wsrep_protocol_version | 8 |

| wsrep_last_applied | 3363765 |

| wsrep_last_committed | 3363765 |

| wsrep_replicated | 0 |

| wsrep_replicated_bytes | 0 |

| wsrep_repl_keys | 0 |

| wsrep_repl_keys_bytes | 0 |

| wsrep_repl_data_bytes | 0 |

| wsrep_repl_other_bytes | 0 |

| wsrep_received | 2 |

| wsrep_received_bytes | 285 |

| wsrep_local_commits | 0 |

| wsrep_local_cert_failures | 0 |

| wsrep_local_replays | 0 |

| wsrep_local_send_queue | 0 |

| wsrep_local_send_queue_max | 1 |

| wsrep_local_send_queue_min | 0 |

| wsrep_local_send_queue_avg | 0.000000 |

| wsrep_local_recv_queue | 0 |

| wsrep_local_recv_queue_max | 1 |

| wsrep_local_recv_queue_min | 0 |

| wsrep_local_recv_queue_avg | 0.000000 |

| wsrep_local_cached_downto | 0 |

| wsrep_flow_control_paused_ns | 0 |

| wsrep_flow_control_paused | 0.000000 |

| wsrep_flow_control_sent | 0 |

| wsrep_flow_control_recv | 0 |

| wsrep_flow_control_interval | [ 173, 173 ] |

| wsrep_flow_control_interval_low | 173 |

| wsrep_flow_control_interval_high | 173 |

| wsrep_flow_control_status | OFF |

| wsrep_cert_deps_distance | 0.000000 |

| wsrep_apply_oooe | 0.000000 |

| wsrep_apply_oool | 0.000000 |

| wsrep_apply_window | 0.000000 |

| wsrep_commit_oooe | 0.000000 |

| wsrep_commit_oool | 0.000000 |

| wsrep_commit_window | 0.000000 |

| wsrep_local_state | 4 |

| wsrep_local_state_comment | Synced |

| wsrep_cert_index_size | 0 |

| wsrep_cert_bucket_count | 22 |

| wsrep_gcache_pool_size | 1320 |

| wsrep_causal_reads | 0 |

| wsrep_cert_interval | 0.000000 |

| wsrep_ist_receive_status | |

| wsrep_ist_receive_seqno_start | 0 |

| wsrep_ist_receive_seqno_current | 0 |

| wsrep_ist_receive_seqno_end | 0 |

| wsrep_incoming_addresses | 192.168.99.212:3101,192.168.99.211:3101,192.168.99.210:3101 |

| wsrep_desync_count | 0 |

| wsrep_evs_delayed | |

| wsrep_evs_evict_list | |

| wsrep_evs_repl_latency | 0/0/0/0/0 |

| wsrep_evs_state | OPERATIONAL |

| wsrep_gcomm_uuid | 03a1abaf-a2bc-11e8-b1e3-a6c5831d0c91 |

| wsrep_cluster_conf_id | 29 |

| wsrep_cluster_size | 3 |

| wsrep_cluster_state_uuid | f5ea51e1-a1d0-11e8-b9c7-43286b421cc6 |

| wsrep_cluster_status | Primary |

| wsrep_connected | ON |

| wsrep_local_bf_aborts | 0 |

| wsrep_local_index | 0 |

| wsrep_provider_name | Galera |

| wsrep_provider_vendor | Codership Oy |

| wsrep_provider_version | 3.26(r) |

| wsrep_ready | ON |

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

68 rows in set (0.00 sec)

将已有PXC节点关闭,查看grastate.dat中的seqno位置

关闭前节点状态检查:

root@localhost [(none)]>show global status like '%wsrep%';

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

| Variable_name | Value |

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

| wsrep_local_state_uuid | f5ea51e1-a1d0-11e8-b9c7-43286b421cc6 |

| wsrep_protocol_version | 8 |

| wsrep_last_applied | 3443542 |

| wsrep_last_committed | 3443542 |

| wsrep_replicated | 0 |

| wsrep_replicated_bytes | 0 |

| wsrep_repl_keys | 0 |

| wsrep_repl_keys_bytes | 0 |

| wsrep_repl_data_bytes | 0 |

| wsrep_repl_other_bytes | 0 |

| wsrep_received | 3 |

| wsrep_received_bytes | 293 |

| wsrep_local_commits | 0 |

| wsrep_local_cert_failures | 0 |

| wsrep_local_replays | 0 |

| wsrep_local_send_queue | 0 |

| wsrep_local_send_queue_max | 1 |

| wsrep_local_send_queue_min | 0 |

| wsrep_local_send_queue_avg | 0.000000 |

| wsrep_local_recv_queue | 0 |

| wsrep_local_recv_queue_max | 1 |

| wsrep_local_recv_queue_min | 0 |

| wsrep_local_recv_queue_avg | 0.000000 |

| wsrep_local_cached_downto | 0 |

| wsrep_flow_control_paused_ns | 0 |

| wsrep_flow_control_paused | 0.000000 |

| wsrep_flow_control_sent | 0 |

| wsrep_flow_control_recv | 0 |

| wsrep_flow_control_interval | [ 173, 173 ] |

| wsrep_flow_control_interval_low | 173 |

| wsrep_flow_control_interval_high | 173 |

| wsrep_flow_control_status | OFF |

| wsrep_cert_deps_distance | 0.000000 |

| wsrep_apply_oooe | 0.000000 |

| wsrep_apply_oool | 0.000000 |

| wsrep_apply_window | 1.000000 |

| wsrep_commit_oooe | 0.000000 |

| wsrep_commit_oool | 0.000000 |

| wsrep_commit_window | 1.000000 |

| wsrep_local_state | 4 |

| wsrep_local_state_comment | Synced |

| wsrep_cert_index_size | 0 |

| wsrep_cert_bucket_count | 22 |

| wsrep_gcache_pool_size | 1536 |

| wsrep_causal_reads | 0 |

| wsrep_cert_interval | 0.000000 |

| wsrep_ist_receive_status | |

| wsrep_ist_receive_seqno_start | 0 |

| wsrep_ist_receive_seqno_current | 0 |

| wsrep_ist_receive_seqno_end | 0 |

| wsrep_incoming_addresses | 192.168.99.211:3101,192.168.99.212:3101,192.168.99.210:3101 |

| wsrep_desync_count | 0 |

| wsrep_evs_delayed | |

| wsrep_evs_evict_list | |

| wsrep_evs_repl_latency | 0/0/0/0/0 |

| wsrep_evs_state | OPERATIONAL |

| wsrep_gcomm_uuid | 495569ff-a2be-11e8-90eb-3ff707d359ca |

| wsrep_cluster_conf_id | 31 |

| wsrep_cluster_size | 3 |

| wsrep_cluster_state_uuid | f5ea51e1-a1d0-11e8-b9c7-43286b421cc6 |

| wsrep_cluster_status | Primary |

| wsrep_connected | ON |

| wsrep_local_bf_aborts | 0 |

| wsrep_local_index | 1 |

| wsrep_provider_name | Galera |

| wsrep_provider_vendor | Codership Oy |

| wsrep_provider_version | 3.26(r) |

| wsrep_ready | ON |

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

68 rows in set (0.00 sec)

root@localhost [(none)]>show master status\G;

*************************** 1. row ***************************

File: mysql-bin.000004

Position: 36617641

Binlog_Do_DB:

Binlog_Ignore_DB:

Executed_Gtid_Set: 0a15ae1e-5e2f-ee17-4638-bcd794bde339:1-3443541

1 row in set (0.00 sec)

ERROR:

No query specified

root@localhost [(none)]>shutdown;

Query OK, 0 rows affected (0.00 sec)

查看grastate.dat中的seqno位置

[root@db212_16:20:45 /3101/data]

#cat grastate.dat

# GALERA saved state

version: 2.1

uuid: f5ea51e1-a1d0-11e8-b9c7-43286b421cc6

seqno: 3443542

safe_to_bootstrap: 0

两点人山
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
mysql PXC集群脑裂及grastate.dat修改实验
conghe6716的博客
09-30 3229
三台服务器做了 mysql PXC 集群 172.31.217.182 bd-dev-mingshuo-182 172.31.217.183 bd-dev-m...
mysql grastate.dat_MySQL Galera Cluster grastate.dat文件详解
weixin_30091863的博客
02-04 521
介绍一个Galera 集群中非常重要的一个文件即grastate.dat，他位于MySQL的数据文件目录，即datadir1. 定位最近状态的节点当我们关闭一个节点时，其seqno会写入grastate.dat文件中，这时后续的seqno该节点将无法接收到注意数据库开启状态或者异常关闭时seqno值为-1当我们将所有节点关闭，准备重启时我们需要知道哪个节点是最后关闭的，并使用它来引导集群这时查看s...
mysql grastate.dat_X. MySQL Galera Cluster全解析 Part 10 grastate.dat文件详解
weixin_34878397的博客
02-04 109
前期回顾主机名IP地址操作系统MySQL版本插件版本rac111.12.14.29Redhat 6.105.7.2625.3.27rac211.12.14.30Redhat 6.105.7.2625.3.27rac311.12.14.39Redhat 6.105.7.2625.3.27前面我们说了Galera Cluster有三种不同的分支MySQL Galera Cluster by Coder...
edit the grastate.dat file manually and set safe_to_bootstrap to 1
cuchengjiao8603的博客
07-24 540
1、尝试重启mysql数据库时报错 [root@galera01 ~]# /etc/init.d/mysqld start --wsrep-new-cluster MySQL Daemon failed to start....
MySQL集群PXC（Percona-XtraDB-Cluster-5.7.41-31.65）
06-02
MySQL集群PXC-5.7.41： Percona-XtraDB-Cluster-5.7.41-31.65.tar.gz percona-xtradb-cluster-5.7_5.7.41-31.65.orig.tar.gz Percona-XtraDB-Cluster-server-57-5.7.41-31.65.1.el7.x86_64.rpm Percona-XtraDB-...
qpress-11-1.el7.x86_64.rpm
02-27
最近在搭建pxc集群时发现缺少这个包在百度一直找不到合适的，从谷歌下载了下载，欢迎使用qpress-11-1.el7
MySQL PXC_百度大神cnf配置
08-30
MySQL PXC，全称为Percona XtraDB Cluster，是MySQL的一种高可用性和可扩展性的集群解决方案。它基于MySQL Server和XtraDB存储引擎，并引入了Galera同步技术，实现了多节点之间的实时数据复制，确保在节点故障时能够...
MySQL PXC构建一个新节点只需IST传输的方法(推荐)
01-19
需求场景：原有的pxc环境数据量已经比较大，新买的服务器要加入此集群中，如何让其用IST的方式传输，而不是SST. PXC传输数据有两种方式： IST：Incremental State Transfer 增量同步 SST：State Snapshot Transfer ...
MySQL集群PXC（Percona-XtraDB-Cluster-8.0.32）
05-31
MySQL集群PXC： Percona-XtraDB-Cluster-8.0.32-24.tar.gz percona-xtradb-cluster_8.0.32-24.orig.tar.gz Percona-XtraDB-Cluster-8.0.32-24.tar.gz.gz
MySQL Galera Cluster grastate.dat文件详解
Nicholas的专栏
11-23 1911
介绍一个Galera 集群中非常重要的一个文件 即grastate.dat，他位于MySQL的数据文件目录，即datadir 1. 定位最近状态的节点 当我们关闭一个节点时，其seqno会写入grastate.dat文件中，这时后续的seqno该节点将无法接收到 注意数据库开启状态或者异常关闭时seqno值为-1 当我们将所有节点关闭，准备重启时我们需要知道哪个节点是最后关闭的，并使用它来引导集群 这时查看seqno的值即可，最大的即可 2. 安全引导保护...
mysql pxc问题
2023年最新地推相关信息
02-18 410
pxc 2节点启动报错报错如下，我的xtrabackup都正常的呀为什么会有这种情况是版本问题么。
mysql pxc安装部署_MySQL高可用之PXC安装部署（续）
weixin_35785014的博客
01-19 483
1 //Change the parameter "wsrep_sst_method" into "rysnc" in my3308.cnf file.2 #loose-wsrep_sst_method=xtrabackup-v23 loose-wsrep_sst_method=rsync45 [root@zlm4 07:51:38 /data/mysql/mysql3308/data]6 #ta...
算法--路径总和
CodersCoder的博客
09-08 564
描述 给定一个二叉树和一个目标和，判断该树中是否存在根节点到叶子节点的路径，这条路径上所有节点值相加等于目标和。 说明: 叶子节点是指没有子节点的节点。 示例 分析 从根节点开始，使用递归，判断左节点或者右节点到叶子节点是否存在sum-root.val即可。 实现 class Solution { public boolean hasPathSum(TreeNode root, int sum) { if (root == null) { return fa
mysql timestamp utc_MySQL 5.7 时间显示修改(log_timestamps UTC)
weixin_39678304的博客
01-19 124
https://blog.csdn.net/leshami/article/details/78952842https://blog.csdn.net/hyy_217/article/details/72781614https://blog.csdn.net/jason_asia/article/details/100749127 (这个可以)在MySQL 5.7版本中，日志记录时间发生了...
mysql脑裂英文_mysql PXC集群脑裂及grastate.dat修改实验
weixin_32224617的博客
02-06 345
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 SHUTDOWN2018-09-27T07:33:23.230509Z 0 [Note] W...
MySQL高可用PXC
weixin_56463403的博客
06-27 273
PXC高可用 2.1 PXC介绍 Percona Server由领先的MySQL咨询公司Percona发布。 Percona Server是一款独立的数据库产品，其可以完全与MySQL兼容，可以在不更改代码的情况了下将存储引擎更换成XtraDB 。XtraDB可以看做是InnoDB存储引擎的增强版本，它完全兼容InnoDB，且提供了很多InnoDB不具备的有用的功能。 Percona团队的最终声明是“Percona Server是最接近官方MySQL Enterprise发行版的版本”。 Perco
galera mysql cluster 故障节点再次接入集群遇到的问题.
cudi7618的博客
06-09 3725
galera cluster是mysql 的多主集群. 我们目前搭建了3个节点的测试集群. 第一轮测试的时候, 发现一个问题,节点故障了, 下线,然后重新加入集群,无法加入. 然后直接整个节点内容...
Percona XtraDB Cluster添加仲裁节点
乐沙弥的世界
04-25 1855
Galera Arbitrator是Percona XtraDB集群的成员，用于投票，以防您拥有少量服务器（通常为两个）并且不希望添加更多资源。Galera仲裁器不需要专用服务器。它可以安装在运行其他应用程序的机器上。只要确保它具有良好的网络连接。Galera Arbitrator是参与投票的群集的成员，但不是实际复制（虽然它接收与其他节点相同的数据）。此外，它不包含在流量控制计算中。本文给出添加...
pymysql_pxc
最新发布
09-02
pymysql_pxc 是一个用于连接 Percona XtraDB Cluster 数据库的 Python 库。它是基于 PyMySQL 库开发的，提供了额外的功能来支持与 Percona XtraDB Cluster 的交互。 你可以使用 pymysql_pxc 来连接 Percona XtraDB ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值