connection node_2; connection node_1; connection node_1a; SET SESSION wsrep_sync_wait = 0; connection node_1; CREATE TABLE t1 (f1 INTEGER, f2 varchar(1024)) Engine=InnoDB; CREATE TABLE ten (f1 INTEGER) ENGINE=InnoDB; INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10); SET GLOBAL innodb_disallow_writes=ON; INSERT INTO t1 (f2) SELECT 'abcde ' FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4;; connection node_2; INSERT INTO t1 (f2) SELECT 'fghij ' FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4; SELECT COUNT(*) AS EXPECT_10000 FROM t1; EXPECT_10000 10000 connection node_1a; SET GLOBAL innodb_disallow_writes=OFF; connection node_1; SELECT COUNT(*) AS EXPECT_20000 FROM t1; EXPECT_20000 20000 connection node_2; SELECT COUNT(*) AS EXPECT_20000 FROM t1; EXPECT_20000 20000 connection node_1; connection node_2; DROP TABLE t1; DROP TABLE ten; disconnect node_1a;