mirror of
https://github.com/MariaDB/server.git
synced 2025-10-30 18:36:12 +01:00
9b6f87b62a
galera.galera_log_bin test created the test tables and executed initial DML into node 2 Then connection is switched to node 1, where ALTER TABLE was attempted. But there is no guarantee that the table to alter was yet replicated to node 1. The fix in this commit, creates the test tables in node 1 instead, so it is guaranteed that they are available for the later ALTER Signed-off-by: Julius Goryavsky <julius.goryavsky@mariadb.com>
46 lines
1 KiB
PHP
46 lines
1 KiB
PHP
--source include/galera_cluster.inc
|
|
--source include/force_restart.inc
|
|
|
|
--connection node_2
|
|
set global wsrep_on=OFF;
|
|
reset master;
|
|
set global wsrep_on=ON;
|
|
--connection node_1
|
|
set global wsrep_on=OFF;
|
|
reset master;
|
|
set global wsrep_on=ON;
|
|
|
|
#
|
|
# 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';
|
|
--source include/show_binlog_events.inc
|
|
|
|
DROP TABLE t1;
|
|
DROP TABLE t2;
|
|
|
|
--echo #cleanup
|
|
--connection node_1
|
|
SET GLOBAL wsrep_on=OFF;
|
|
RESET MASTER;
|
|
SET GLOBAL wsrep_on=ON;
|