mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 10:56:12 +01:00
45 lines
1.2 KiB
Text
45 lines
1.2 KiB
Text
connection node_2;
|
|
connection node_1;
|
|
connection node_1;
|
|
CREATE TABLE t1 (f1 INTEGER);
|
|
LOCK TABLE t1 WRITE;
|
|
value prior to RSU:
|
|
SHOW STATUS LIKE 'wsrep_desync_count';
|
|
Variable_name Value
|
|
wsrep_desync_count 0
|
|
SHOW VARIABLES LIKE 'wsrep_desync';
|
|
Variable_name Value
|
|
wsrep_desync OFF
|
|
connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
|
|
connection node_1a;
|
|
SET SESSION wsrep_sync_wait = 0;
|
|
SET SESSION wsrep_osu_method = RSU;
|
|
ALTER TABLE t1 ADD COLUMN f2 INTEGER;;
|
|
connect node_1b, 127.0.0.1, root, , test, $NODE_MYPORT_1;
|
|
connection node_1b;
|
|
SET SESSION wsrep_sync_wait = 0;
|
|
SET SESSION wsrep_osu_method = RSU;
|
|
ALTER TABLE t1 ADD COLUMN f3 INTEGER;;
|
|
connection node_1;
|
|
value during RSU:
|
|
SHOW STATUS LIKE 'wsrep_desync_count';
|
|
Variable_name Value
|
|
wsrep_desync_count 2
|
|
SHOW VARIABLES LIKE 'wsrep_desync';
|
|
Variable_name Value
|
|
wsrep_desync OFF
|
|
UNLOCK TABLES;
|
|
connection node_1a;
|
|
connection node_1b;
|
|
connection node_1;
|
|
value after RSU:
|
|
SHOW STATUS LIKE 'wsrep_desync_count';
|
|
Variable_name Value
|
|
wsrep_desync_count 0
|
|
SHOW VARIABLES LIKE 'wsrep_desync';
|
|
Variable_name Value
|
|
wsrep_desync OFF
|
|
SET GLOBAL wsrep_desync=0;
|
|
Warnings:
|
|
Warning 1231 'wsrep_desync' is already OFF.
|
|
DROP TABLE t1;
|