--echo # --echo # MDEV-9044 : Getting binlog corruption on my Galera cluster (10.1.8) --echo # making it impossible to async slave. --echo # --source include/have_innodb.inc --source include/galera_cluster.inc --connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3 --disable_query_log --eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_USER='root', MASTER_SSL_VERIFY_SERVER_CERT=0, MASTER_PORT=$NODE_MYPORT_1; --enable_query_log START SLAVE; --connection node_1 SELECT @@GLOBAL.BINLOG_CACHE_SIZE; CREATE TABLE t1 (c1 INTEGER PRIMARY KEY, c2 VARCHAR(12000)) ENGINE=INNODB; CREATE TABLE t2 (c1 INTEGER PRIMARY KEY) ENGINE=INNODB; START TRANSACTION; INSERT INTO t1 VALUES(1, REPEAT('-', 10000)); COMMIT; INSERT INTO t2 VALUES(1); save_master_pos; --connection node_2 SELECT c1, LENGTH(c2) FROM t1; SELECT * FROM t2; --connection node_3 sync_with_master; SELECT c1, LENGTH(c2) FROM t1; SELECT * FROM t2; --echo # Cleanup --connection node_1 DROP TABLE t1, t2; save_master_pos; --connection node_3 sync_with_master; STOP SLAVE; RESET SLAVE ALL;