mirror of
https://github.com/MariaDB/server.git
synced 2025-11-03 20:36:16 +01:00
42 lines
1,009 B
Text
42 lines
1,009 B
Text
--source include/galera_cluster.inc
|
|
--source include/have_innodb.inc
|
|
|
|
--connection node_1
|
|
CREATE TABLE t1 (f1 INTEGER);
|
|
LOCK TABLE t1 WRITE;
|
|
--echo value prior to RSU:
|
|
SHOW STATUS LIKE 'wsrep_desync_count';
|
|
SHOW VARIABLES LIKE 'wsrep_desync';
|
|
|
|
--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;
|
|
--send 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;
|
|
--send ALTER TABLE t1 ADD COLUMN f3 INTEGER;
|
|
|
|
--sleep 5
|
|
--connection node_1
|
|
--echo value during RSU:
|
|
SHOW STATUS LIKE 'wsrep_desync_count';
|
|
SHOW VARIABLES LIKE 'wsrep_desync';
|
|
UNLOCK TABLES;
|
|
|
|
--connection node_1a
|
|
--reap
|
|
--connection node_1b
|
|
--reap
|
|
|
|
--connection node_1
|
|
--echo value after RSU:
|
|
--sleep 3
|
|
SHOW STATUS LIKE 'wsrep_desync_count';
|
|
SHOW VARIABLES LIKE 'wsrep_desync';
|
|
SET GLOBAL wsrep_desync=0;
|
|
|
|
DROP TABLE t1;
|