summaryrefslogtreecommitdiff
path: root/mysql-test/suite/galera/t/galera_log_bin.inc
diff options
context:
space:
mode:
authorMarko Mäkelä <marko.makela@mariadb.com>2021-03-27 16:11:26 +0200
committerMarko Mäkelä <marko.makela@mariadb.com>2021-03-27 16:11:26 +0200
commit3157fa182accab86a4dea45edbcbca4eb5157723 (patch)
tree9ba82e0c489eb91efbf1e5863c5a98a29b5ea8c3 /mysql-test/suite/galera/t/galera_log_bin.inc
parent480a06718d137c9ee7784012ccb609b9e79ff08c (diff)
parent48141f3c1787de941d969ad1e6675611b2b650c2 (diff)
downloadmariadb-git-3157fa182accab86a4dea45edbcbca4eb5157723.tar.gz
Merge 10.2 into 10.3
Diffstat (limited to 'mysql-test/suite/galera/t/galera_log_bin.inc')
-rw-r--r--mysql-test/suite/galera/t/galera_log_bin.inc42
1 files changed, 42 insertions, 0 deletions
diff --git a/mysql-test/suite/galera/t/galera_log_bin.inc b/mysql-test/suite/galera/t/galera_log_bin.inc
new file mode 100644
index 00000000000..f1d2a12b9de
--- /dev/null
+++ b/mysql-test/suite/galera/t/galera_log_bin.inc
@@ -0,0 +1,42 @@
+--source include/galera_cluster.inc
+--source include/force_restart.inc
+
+--connection node_1
+reset master;
+--connection node_2
+reset master;
+
+#
+# Test Galera with --log-bin --log-slave-updates .
+# This way the actual MySQL binary log is used,
+# rather than Galera's own implementation
+#
+
+CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
+INSERT INTO t1 VALUES (1);
+
+CREATE TABLE t2 (id INT) ENGINE=InnoDB;
+INSERT INTO t2 VALUES (1);
+INSERT INTO t2 VALUES (1);
+
+--connection node_2
+SELECT COUNT(*) = 1 FROM t1;
+SELECT COUNT(*) = 2 FROM t2;
+
+--connection node_1
+ALTER TABLE t1 ADD COLUMN f2 INTEGER;
+--let $MASTER_MYPORT=$NODE_MYPORT_1
+--source include/show_binlog_events.inc
+
+--connection node_2
+SELECT COUNT(*) = 2 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 't1';
+--let $MASTER_MYPORT=$NODE_MYPORT_2
+--source include/show_binlog_events.inc
+
+DROP TABLE t1;
+DROP TABLE t2;
+
+--echo #cleanup
+--connection node_1
+RESET MASTER;
+