EVOLUTION-MANAGER

Edit File: galera_as_master.result

connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3; START SLAVE; connection node_1; CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB; INSERT INTO t1 VALUES(1); # Disable binary logging for current session SET SQL_LOG_BIN=OFF; CREATE TABLE t2 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB; INSERT INTO t2 VALUES(1); INSERT INTO t1 VALUES(2); CREATE TABLE test.t3 AS SELECT * from t1; SET SQL_LOG_BIN=ON; INSERT INTO t1 VALUES(3); CREATE TABLE test.t4 AS SELECT * from t1; connection node_2; SELECT * FROM t1; f1 1 2 3 SELECT * FROM t2; f1 1 SELECT * FROM t3; f1 1 2 SELECT * FROM t4; f1 1 2 3 connection node_3; SHOW TABLES; Tables_in_test t1 t4 SELECT * FROM t1; f1 1 3 SELECT * FROM t4; f1 1 2 3 # Cleanup connection node_1; DROP TABLE t1, t4; SET SQL_LOG_BIN=OFF; DROP TABLE t2, t3; connection node_3; STOP SLAVE; RESET SLAVE ALL; CALL mtr.add_suppression('You need to use --log-bin to make --binlog-format work'); connection node_1; RESET MASTER;