1. 停止后，master日志没有任何变化，依旧是上次拒绝190加入的日志。到是189有新日志，两条。
188：
- [root@greatsql01 log]# tail -f error.log
- 2023-12-05T12:11:47.695006+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017495059959455. Please stop the old node or wait for it to leave the group.'
- 2023-12-05T12:11:47.696147+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:63 in close_connection'
- 2023-12-05T12:11:47.793762+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:62 connected'
- 2023-12-05T12:11:47.793916+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:62'
- 2023-12-05T12:11:47.794826+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017495059959455. Please stop the old node or wait for it to leave the group.'
- 2023-12-05T12:11:47.796004+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:62 in close_connection'
- 2023-12-05T12:11:47.893200+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:63 connected'
- 2023-12-05T12:11:47.893350+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:63'
- 2023-12-05T12:11:47.894470+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017495059959455. Please stop the old node or wait for it to leave the group.'
- 2023-12-05T12:11:47.895709+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:63 in close_connection'
189：
- [root@greatsql02 ~]# tail -f /data/greatsql/8.0.32/log/error.log
- 2023-12-05T12:11:47.799393+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:42 connected'
- 2023-12-05T12:11:47.799614+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:42'
- 2023-12-05T12:11:47.800686+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017495059959455. Please stop the old node or wait for it to leave the group.'
- 2023-12-05T12:11:47.801667+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:42 in close_connection'
- 2023-12-05T12:11:47.899419+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:45 connected'
- 2023-12-05T12:11:47.899694+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] buffered_read_msg sets CON_PROTO for fd:45'
- 2023-12-05T12:11:47.900776+08:00 0 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Old incarnation found while trying to add node 192.168.6.190:33081 17017495059959455. Please stop the old node or wait for it to leave the group.'
- 2023-12-05T12:11:47.901968+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:45 in close_connection'
- 2023-12-05T13:44:41.027189+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set fd:35 connected'
- 2023-12-05T13:44:41.027717+08:00 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] set CON_NULL for fd:35 in close_connection'
2. 188执行show engine innodb status\G
- (Tue Dec 5 13:48:52 2023)[root@GreatSQL][(none)]>show engine innodb status\G
- *************************** 1. row ***************************
- Type: InnoDB
- Name:
- Status:
- =====================================
- 2023-12-05 13:48:53 139837876680448 INNODB MONITOR OUTPUT
- =====================================
- Per second averages calculated from the last 7 seconds
- -----------------
- BACKGROUND THREAD
- -----------------
- srv_master_thread loops: 147638 srv_active, 0 srv_shutdown, 1055424 srv_idle
- srv_master_thread log flush and writes: 0
- ----------
- SEMAPHORES
- ----------
- OS WAIT ARRAY INFO: reservation count 81940
- OS WAIT ARRAY INFO: signal count 207394
- RW-shared spins 0, rounds 0, OS waits 0
- RW-excl spins 0, rounds 0, OS waits 0
- RW-sx spins 0, rounds 0, OS waits 0
- Spin rounds per wait: 0.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx
- ------------
- TRANSACTIONS
- ------------
- Trx id counter 41735491
- Purge done for trx's n:o < 41735490 undo n:o < 0 state: running but idle
- History list length 0
- LIST OF TRANSACTIONS FOR EACH SESSION:
- ---TRANSACTION 421318168159144, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421318168155752, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421318168158296, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421318168156600, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421318168163384, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421318168162536, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421318168161688, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421318168160840, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421318168159992, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421318168157448, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421318168154904, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421318168154056, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- --------
- FILE I/O
- --------
- I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
- I/O thread 1 state: waiting for completed aio requests (log thread)
- I/O thread 2 state: waiting for completed aio requests (read thread)
- I/O thread 3 state: waiting for completed aio requests (read thread)
- I/O thread 4 state: waiting for completed aio requests (read thread)
- I/O thread 5 state: waiting for completed aio requests (read thread)
- I/O thread 6 state: waiting for completed aio requests (write thread)
- I/O thread 7 state: waiting for completed aio requests (write thread)
- I/O thread 8 state: waiting for completed aio requests (write thread)
- I/O thread 9 state: waiting for completed aio requests (write thread)
- I/O thread 10 state: waiting for completed aio requests (write thread)
- I/O thread 11 state: waiting for completed aio requests (write thread)
- I/O thread 12 state: waiting for completed aio requests (write thread)
- I/O thread 13 state: waiting for completed aio requests (write thread)
- I/O thread 14 state: waiting for completed aio requests (write thread)
- I/O thread 15 state: waiting for completed aio requests (write thread)
- Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0, 0, 0, 0, 0, 0, 0] ,
- ibuf aio reads:, log i/o's:
- Pending flushes (fsync) log: 0; buffer pool: 18
- 2300 OS file reads, 2930377 OS file writes, 886147 OS fsyncs
- 0.00 reads/s, 0 avg bytes/read, 1.11 writes/s, 0.14 fsyncs/s
- -------------------------------------
- INSERT BUFFER AND ADAPTIVE HASH INDEX
- -------------------------------------
- Ibuf: size 1, free list len 0, seg size 2, 0 merges
- merged operations:
- insert 0, delete mark 0, delete 0
- discarded operations:
- insert 0, delete mark 0, delete 0
- Hash table size 276707, node heap has 0 buffer(s)
- Hash table size 276707, node heap has 0 buffer(s)
- Hash table size 276707, node heap has 0 buffer(s)
- Hash table size 276707, node heap has 0 buffer(s)
- Hash table size 276707, node heap has 0 buffer(s)
- Hash table size 276707, node heap has 0 buffer(s)
- Hash table size 276707, node heap has 0 buffer(s)
- Hash table size 276707, node heap has 0 buffer(s)
- 0.00 hash searches/s, 782.75 non-hash searches/s
- ---
- LOG
- ---
- Log sequence number 25345870386
- Log buffer assigned up to 25345870386
- Log buffer completed up to 25345870386
- Log written up to 25345870386
- Log flushed up to 25345870386
- Added dirty pages up to 25345870386
- Pages flushed up to 25345870386
- Last checkpoint at 25345870386
- Log minimum file id is 119
- Log maximum file id is 125
- Modified age no less than 25345870386
- Checkpoint age 0
- Max checkpoint age 5422668288
- 2262305 log i/o's done, 0.00 log i/o's/second
- ----------------------
- BUFFER POOL AND MEMORY
- ----------------------
- Total large memory allocated 0
- Dictionary memory allocated 733538
- Buffer pool size 65528
- Buffer pool size, bytes 1073610752
- Free buffers 32000
- Database pages 33528
- Old database pages 12216
- Modified db pages 0
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 40135, not young 39298
- 1.11 youngs/s, 0.00 non-youngs/s
- Pages read 1559, created 231057, written 548924
- 0.00 reads/s, 0.42 creates/s, 0.97 writes/s
- Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 33528, unzip_LRU len: 0
- I/O sum[168]:cur[0], unzip sum[0]:cur[0]
- ----------------------
- INDIVIDUAL BUFFER POOL INFO
- ----------------------
- ---BUFFER POOL 0
- Buffer pool size 8191
- Buffer pool size, bytes 134201344
- Free buffers 4000
- Database pages 4191
- Old database pages 1527
- Modified db pages 0
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 45, not young 143
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 198, created 5618, written 7926
- 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
- Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 4191, unzip_LRU len: 0
- I/O sum[21]:cur[0], unzip sum[0]:cur[0]
- ---BUFFER POOL 1
- Buffer pool size 8191
- Buffer pool size, bytes 134201344
- Free buffers 4000
- Database pages 4191
- Old database pages 1527
- Modified db pages 0
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 1019, not young 230
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 165, created 6556, written 9143
- 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
- No buffer pool page gets since the last printout
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 4191, unzip_LRU len: 0
- I/O sum[21]:cur[0], unzip sum[0]:cur[0]
- ---BUFFER POOL 2
- Buffer pool size 8191
- Buffer pool size, bytes 134201344
- Free buffers 4000
- Database pages 4191
- Old database pages 1527
- Modified db pages 0
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 113, not young 345
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 196, created 6877, written 8871
- 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
- No buffer pool page gets since the last printout
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 4191, unzip_LRU len: 0
- I/O sum[21]:cur[0], unzip sum[0]:cur[0]
- ---BUFFER POOL 3
- Buffer pool size 8191
- Buffer pool size, bytes 134201344
- Free buffers 4000
- Database pages 4191
- Old database pages 1527
- Modified db pages 0
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 8586, not young 14895
- 1.11 youngs/s, 0.00 non-youngs/s
- Pages read 289, created 52707, written 133801
- 0.00 reads/s, 0.28 creates/s, 0.83 writes/s
- Buffer pool hit rate 1000 / 1000, young-making rate 8 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 4191, unzip_LRU len: 0
- I/O sum[21]:cur[0], unzip sum[0]:cur[0]
- ---BUFFER POOL 4
- Buffer pool size 8191
- Buffer pool size, bytes 134201344
- Free buffers 4000
- Database pages 4191
- Old database pages 1527
- Modified db pages 0
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 8031, not young 177
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 93, created 52642, written 130509
- 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
- No buffer pool page gets since the last printout
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 4191, unzip_LRU len: 0
- I/O sum[21]:cur[0], unzip sum[0]:cur[0]
- ---BUFFER POOL 5
- Buffer pool size 8191
- Buffer pool size, bytes 134201344
- Free buffers 4000
- Database pages 4191
- Old database pages 1527
- Modified db pages 0
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 11017, not young 1351
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 27, created 48644, written 118717
- 0.00 reads/s, 0.14 creates/s, 0.14 writes/s
- No buffer pool page gets since the last printout
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 4191, unzip_LRU len: 0
- I/O sum[21]:cur[0], unzip sum[0]:cur[0]
- ---BUFFER POOL 6
- Buffer pool size 8191
- Buffer pool size, bytes 134201344
- Free buffers 4000
- Database pages 4191
- Old database pages 1527
- Modified db pages 0
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 11038, not young 7859
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 143, created 52453, written 129752
- 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
- Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 4191, unzip_LRU len: 0
- I/O sum[21]:cur[0], unzip sum[0]:cur[0]
- ---BUFFER POOL 7
- Buffer pool size 8191
- Buffer pool size, bytes 134201344
- Free buffers 4000
- Database pages 4191
- Old database pages 1527
- Modified db pages 0
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 286, not young 14298
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 448, created 5560, written 10205
- 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
- Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 4191, unzip_LRU len: 0
- I/O sum[21]:cur[0], unzip sum[0]:cur[0]
- --------------
- ROW OPERATIONS
- --------------
- 0 queries inside InnoDB, 0 queries in queue
- 0 read views open inside InnoDB
- 0 RW transactions active inside InnoDB
- Process ID=1062, Main thread ID=139841544886016 , state=sleeping
- Number of rows inserted 7363728, updated 115920, deleted 0, read 2389239
- 8.86 inserts/s, 0.00 updates/s, 0.00 deletes/s, 8.86 reads/s
- Number of system rows inserted 9229, updated 2019, deleted 8977, read 117606390
- 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 828.31 reads/s
- ----------------------------
- END OF INNODB MONITOR OUTPUT
- ============================
- 1 row in set (0.00 sec)
- (Tue Dec 5 13:48:53 2023)[root@GreatSQL][(none)]>
3. mgr状态检测
188：
- (Tue Dec 5 13:49:31 2023)[root@GreatSQL][(none)]>select * from performance_schema.replication_group_members;SELECT * FROM performance_schema.replication_group_member_stats\G;show master status\G;SELECT MEMBER_ID AS id, COUNT_TRANSACTIONS_IN_QUEUE AS trx_tobe_certified, COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE AS relaylog_tobe_applied, COUNT_TRANSACTIONS_CHECKED AS trx_chkd, COUNT_TRANSACTIONS_REMOTE_APPLIED AS trx_done, COUNT_TRANSACTIONS_LOCAL_PROPOSED AS proposed FROM performance_schema.replication_group_member_stats;SELECT RECEIVED_TRANSACTION_SET FROM performance_schema.replication_connection_status WHERE channel_name = 'group_replication_applier' UNION ALL SELECT variable_value FROM performance_schema.global_variables WHERE variable_name = 'gtid_executed'\G;select now();SELECT MEMBER_ID,COUNT_TRANSACTIONS_ROWS_VALIDATING FROM performance_schema.replication_group_member_stats;
- +---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+----------------------------+
- | CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | MEMBER_COMMUNICATION_STACK |
- +---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+----------------------------+
- | group_replication_applier | a55de711-812e-11ee-b3fc-5254005b7a28 | 192.168.6.190 | 3308 | UNREACHABLE | SECONDARY | 8.0.32 | XCom |
- | group_replication_applier | a5609358-812e-11ee-abe4-525400b01dcf | 192.168.6.188 | 3308 | ONLINE | PRIMARY | 8.0.32 | XCom |
- | group_replication_applier | a5623edf-812e-11ee-92a9-525400980c24 | 192.168.6.189 | 3308 | ONLINE | SECONDARY | 8.0.32 | XCom |
- +---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+----------------------------+
- 3 rows in set (0.00 sec)
- *************************** 1. row ***************************
- CHANNEL_NAME: group_replication_applier
- VIEW_ID: 17005521402960008:4
- MEMBER_ID: a55de711-812e-11ee-b3fc-5254005b7a28
- COUNT_TRANSACTIONS_IN_QUEUE: 0
- COUNT_TRANSACTIONS_CHECKED: 115994
- COUNT_CONFLICTS_DETECTED: 0
- COUNT_TRANSACTIONS_ROWS_VALIDATING: 0
- TRANSACTIONS_COMMITTED_ALL_MEMBERS: a5609358-812e-11ee-abe4-525400b01dcf:1,
- f774dd39-814f-11ee-aae7-525400b01dcf:1-19543900
- LAST_CONFLICT_FREE_TRANSACTION: f774dd39-814f-11ee-aae7-525400b01dcf:19543900
- COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE: 0
- COUNT_TRANSACTIONS_REMOTE_APPLIED: 116005
- COUNT_TRANSACTIONS_LOCAL_PROPOSED: 0
- COUNT_TRANSACTIONS_LOCAL_ROLLBACK: 0
- *************************** 2. row ***************************
- CHANNEL_NAME: group_replication_applier
- VIEW_ID: 17005521402960008:4
- MEMBER_ID: a5609358-812e-11ee-abe4-525400b01dcf
- COUNT_TRANSACTIONS_IN_QUEUE: 0
- COUNT_TRANSACTIONS_CHECKED: 116195
- COUNT_CONFLICTS_DETECTED: 0
- COUNT_TRANSACTIONS_ROWS_VALIDATING: 0
- TRANSACTIONS_COMMITTED_ALL_MEMBERS: a5609358-812e-11ee-abe4-525400b01dcf:1,
- f774dd39-814f-11ee-aae7-525400b01dcf:1-19543900
- LAST_CONFLICT_FREE_TRANSACTION: f774dd39-814f-11ee-aae7-525400b01dcf:19544101
- COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE: 0
- COUNT_TRANSACTIONS_REMOTE_APPLIED: 4
- COUNT_TRANSACTIONS_LOCAL_PROPOSED: 116195
- COUNT_TRANSACTIONS_LOCAL_ROLLBACK: 0
- *************************** 3. row ***************************
- CHANNEL_NAME: group_replication_applier
- VIEW_ID: 17005521402960008:4
- MEMBER_ID: a5623edf-812e-11ee-92a9-525400980c24
- COUNT_TRANSACTIONS_IN_QUEUE: 0
- COUNT_TRANSACTIONS_CHECKED: 269
- COUNT_CONFLICTS_DETECTED: 0
- COUNT_TRANSACTIONS_ROWS_VALIDATING: 0
- TRANSACTIONS_COMMITTED_ALL_MEMBERS: a5609358-812e-11ee-abe4-525400b01dcf:1,
- f774dd39-814f-11ee-aae7-525400b01dcf:1-19543900
- LAST_CONFLICT_FREE_TRANSACTION: f774dd39-814f-11ee-aae7-525400b01dcf:19544101
- COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE: 0
- COUNT_TRANSACTIONS_REMOTE_APPLIED: 269
- COUNT_TRANSACTIONS_LOCAL_PROPOSED: 0
- COUNT_TRANSACTIONS_LOCAL_ROLLBACK: 0
- 3 rows in set (0.00 sec)
- ERROR:
- No query specified
- *************************** 1. row ***************************
- File: binlog.000692
- Position: 246047058
- Binlog_Do_DB:
- Binlog_Ignore_DB:
- Executed_Gtid_Set: a5609358-812e-11ee-abe4-525400b01dcf:1,
- f774dd39-814f-11ee-aae7-525400b01dcf:1-19544101
- 1 row in set (0.00 sec)
- ERROR:
- No query specified
- +--------------------------------------+--------------------+-----------------------+----------+----------+----------+
- | id | trx_tobe_certified | relaylog_tobe_applied | trx_chkd | trx_done | proposed |
- +--------------------------------------+--------------------+-----------------------+----------+----------+----------+
- | a55de711-812e-11ee-b3fc-5254005b7a28 | 0 | 0 | 115994 | 116005 | 0 |
- | a5609358-812e-11ee-abe4-525400b01dcf | 0 | 0 | 116195 | 4 | 116195 |
- | a5623edf-812e-11ee-92a9-525400980c24 | 0 | 0 | 269 | 269 | 0 |
- +--------------------------------------+--------------------+-----------------------+----------+----------+----------+
- 3 rows in set (0.00 sec)
- *************************** 1. row ***************************
- RECEIVED_TRANSACTION_SET: a5609358-812e-11ee-abe4-525400b01dcf:1,
- f774dd39-814f-11ee-aae7-525400b01dcf:1-19543900
- *************************** 2. row ***************************
- RECEIVED_TRANSACTION_SET: a5609358-812e-11ee-abe4-525400b01dcf:1,
- f774dd39-814f-11ee-aae7-525400b01dcf:1-19544101
- 2 rows in set (0.01 sec)
- ERROR:
- No query specified
- +---------------------+
- | now() |
- +---------------------+
- | 2023-12-05 13:49:32 |
- +---------------------+
- 1 row in set (0.00 sec)
- +--------------------------------------+------------------------------------+
- | MEMBER_ID | COUNT_TRANSACTIONS_ROWS_VALIDATING |
- +--------------------------------------+------------------------------------+
- | a55de711-812e-11ee-b3fc-5254005b7a28 | 0 |
- | a5609358-812e-11ee-abe4-525400b01dcf | 0 |
- | a5623edf-812e-11ee-92a9-525400980c24 | 0 |
- +--------------------------------------+------------------------------------+
- 3 rows in set (0.00 sec)
- (Tue Dec 5 13:49:32 2023)[root@GreatSQL][(none)]>
188使用mysqlsh检测：
- MySQL 192.168.6.188:3308 ssl Py > c=dba.get_cluster()
- MySQL 192.168.6.188:3308 ssl Py > c.status()
- {
- "clusterName": "test_mgr01",
- "defaultReplicaSet": {
- "name": "default",
- "primary": "192.168.6.188:3308",
- "ssl": "REQUIRED",
- "status": "OK_NO_TOLERANCE",
- "statusText": "Cluster is NOT tolerant to any failures. 1 member is not active.",
- "topology": {
- "192.168.6.188:3308": {
- "address": "192.168.6.188:3308",
- "memberRole": "PRIMARY",
- "mode": "R/W",
- "readReplicas": {},
- "replicationLag": null,
- "role": "HA",
- "status": "ONLINE",
- "version": "8.0.32"
- },
- "192.168.6.189:3308": {
- "address": "192.168.6.189:3308",
- "memberRole": "SECONDARY",
- "mode": "R/O",
- "readReplicas": {},
- "replicationLag": null,
- "role": "HA",
- "status": "ONLINE",
- "version": "8.0.32"
- },
- "192.168.6.190:3308": {
- "address": "192.168.6.190:3308",
- "memberRole": "SECONDARY",
- "memberState": "(MISSING)",
- "mode": "n/a",
- "readReplicas": {},
- "role": "HA",
- "shellConnectError": "MySQL Error 2003 (HY000): Can't connect to MySQL server on '192.168.6.190:3308' (111)",
- "status": "UNREACHABLE",
- "version": "8.0.32"
- }
- },
- "topologyMode": "Single-Primary"
- },
- "groupInformationSourceMember": "192.168.6.188:3308"
- }
- MySQL 192.168.6.188:3308 ssl Py >
189：
- (Tue Dec 5 13:51:08 2023)[root@GreatSQL][tpcc10]>select * from performance_schema.replication_group_members;SELECT * FROM performance_schema.replication_group_member_stats\G;show master status\G;SELECT MEMBER_ID AS id, COUNT_TRANSACTIONS_IN_QUEUE AS trx_tobe_certified, COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE AS relaylog_tobe_applied, COUNT_TRANSACTIONS_CHECKED AS trx_chkd, COUNT_TRANSACTIONS_REMOTE_APPLIED AS trx_done, COUNT_TRANSACTIONS_LOCAL_PROPOSED AS proposed FROM performance_schema.replication_group_member_stats;SELECT RECEIVED_TRANSACTION_SET FROM performance_schema.replication_connection_status WHERE channel_name = 'group_replication_applier' UNION ALL SELECT variable_value FROM performance_schema.global_variables WHERE variable_name = 'gtid_executed'\G;select now();SELECT MEMBER_ID,COUNT_TRANSACTIONS_ROWS_VALIDATING FROM performance_schema.replication_group_member_stats;
- +---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+----------------------------+
- | CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | MEMBER_COMMUNICATION_STACK |
- +---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+----------------------------+
- | group_replication_applier | a55de711-812e-11ee-b3fc-5254005b7a28 | 192.168.6.190 | 3308 | UNREACHABLE | SECONDARY | 8.0.32 | XCom |
- | group_replication_applier | a5609358-812e-11ee-abe4-525400b01dcf | 192.168.6.188 | 3308 | ONLINE | PRIMARY | 8.0.32 | XCom |
- | group_replication_applier | a5623edf-812e-11ee-92a9-525400980c24 | 192.168.6.189 | 3308 | ONLINE | SECONDARY | 8.0.32 | XCom |
- +---------------------------+--------------------------------------+---------------+-------------+--------------+-------------+----------------+----------------------------+
- 3 rows in set (0.00 sec)
- *************************** 1. row ***************************
- CHANNEL_NAME: group_replication_applier
- VIEW_ID: 17005521402960008:4
- MEMBER_ID: a55de711-812e-11ee-b3fc-5254005b7a28
- COUNT_TRANSACTIONS_IN_QUEUE: 0
- COUNT_TRANSACTIONS_CHECKED: 115994
- COUNT_CONFLICTS_DETECTED: 0
- COUNT_TRANSACTIONS_ROWS_VALIDATING: 0
- TRANSACTIONS_COMMITTED_ALL_MEMBERS: a5609358-812e-11ee-abe4-525400b01dcf:1,
- f774dd39-814f-11ee-aae7-525400b01dcf:1-19543900
- LAST_CONFLICT_FREE_TRANSACTION: f774dd39-814f-11ee-aae7-525400b01dcf:19543900
- COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE: 0
- COUNT_TRANSACTIONS_REMOTE_APPLIED: 116005
- COUNT_TRANSACTIONS_LOCAL_PROPOSED: 0
- COUNT_TRANSACTIONS_LOCAL_ROLLBACK: 0
- *************************** 2. row ***************************
- CHANNEL_NAME: group_replication_applier
- VIEW_ID: 17005521402960008:4
- MEMBER_ID: a5609358-812e-11ee-abe4-525400b01dcf
- COUNT_TRANSACTIONS_IN_QUEUE: 0
- COUNT_TRANSACTIONS_CHECKED: 116195
- COUNT_CONFLICTS_DETECTED: 0
- COUNT_TRANSACTIONS_ROWS_VALIDATING: 0
- TRANSACTIONS_COMMITTED_ALL_MEMBERS: a5609358-812e-11ee-abe4-525400b01dcf:1,
- f774dd39-814f-11ee-aae7-525400b01dcf:1-19543900
- LAST_CONFLICT_FREE_TRANSACTION: f774dd39-814f-11ee-aae7-525400b01dcf:19544101
- COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE: 0
- COUNT_TRANSACTIONS_REMOTE_APPLIED: 4
- COUNT_TRANSACTIONS_LOCAL_PROPOSED: 116195
- COUNT_TRANSACTIONS_LOCAL_ROLLBACK: 0
- *************************** 3. row ***************************
- CHANNEL_NAME: group_replication_applier
- VIEW_ID: 17005521402960008:4
- MEMBER_ID: a5623edf-812e-11ee-92a9-525400980c24
- COUNT_TRANSACTIONS_IN_QUEUE: 0
- COUNT_TRANSACTIONS_CHECKED: 269
- COUNT_CONFLICTS_DETECTED: 0
- COUNT_TRANSACTIONS_ROWS_VALIDATING: 0
- TRANSACTIONS_COMMITTED_ALL_MEMBERS: a5609358-812e-11ee-abe4-525400b01dcf:1,
- f774dd39-814f-11ee-aae7-525400b01dcf:1-19543900
- LAST_CONFLICT_FREE_TRANSACTION: f774dd39-814f-11ee-aae7-525400b01dcf:19544101
- COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE: 0
- COUNT_TRANSACTIONS_REMOTE_APPLIED: 269
- COUNT_TRANSACTIONS_LOCAL_PROPOSED: 0
- COUNT_TRANSACTIONS_LOCAL_ROLLBACK: 0
- 3 rows in set (0.00 sec)
- ERROR:
- No query specified
- *************************** 1. row ***************************
- File: binlog.000026
- Position: 151728036
- Binlog_Do_DB:
- Binlog_Ignore_DB:
- Executed_Gtid_Set: a5609358-812e-11ee-abe4-525400b01dcf:1,
- f774dd39-814f-11ee-aae7-525400b01dcf:1-19544101
- 1 row in set (0.00 sec)
- ERROR:
- No query specified
- +--------------------------------------+--------------------+-----------------------+----------+----------+----------+
- | id | trx_tobe_certified | relaylog_tobe_applied | trx_chkd | trx_done | proposed |
- +--------------------------------------+--------------------+-----------------------+----------+----------+----------+
- | a55de711-812e-11ee-b3fc-5254005b7a28 | 0 | 0 | 115994 | 116005 | 0 |
- | a5609358-812e-11ee-abe4-525400b01dcf | 0 | 0 | 116195 | 4 | 116195 |
- | a5623edf-812e-11ee-92a9-525400980c24 | 0 | 0 | 269 | 269 | 0 |
- +--------------------------------------+--------------------+-----------------------+----------+----------+----------+
- 3 rows in set (0.00 sec)
- *************************** 1. row ***************************
- RECEIVED_TRANSACTION_SET: a5609358-812e-11ee-abe4-525400b01dcf:1,
- f774dd39-814f-11ee-aae7-525400b01dcf:1-19544101
- *************************** 2. row ***************************
- RECEIVED_TRANSACTION_SET: a5609358-812e-11ee-abe4-525400b01dcf:1,
- f774dd39-814f-11ee-aae7-525400b01dcf:1-19544101
- 2 rows in set (0.01 sec)
- ERROR:
- No query specified
- +---------------------+
- | now() |
- +---------------------+
- | 2023-12-05 13:51:08 |
- +---------------------+
- 1 row in set (0.00 sec)
- +--------------------------------------+------------------------------------+
- | MEMBER_ID | COUNT_TRANSACTIONS_ROWS_VALIDATING |
- +--------------------------------------+------------------------------------+
- | a55de711-812e-11ee-b3fc-5254005b7a28 | 0 |
- | a5609358-812e-11ee-abe4-525400b01dcf | 0 |
- | a5623edf-812e-11ee-92a9-525400980c24 | 0 |
- +--------------------------------------+------------------------------------+
- 3 rows in set (0.00 sec)
- (Tue Dec 5 13:51:08 2023)[root@GreatSQL][tpcc10]>
|
