1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
--source include/galera_cluster.inc
--source include/have_innodb.inc
#
# At this time, issing a FLUSH TABLES WITH READ LOCK on one node does not prevent DDLs from other nodes
# from proceeding. The locked node will apply the DDL after it has been unlocked
#
CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
--connection node_2
FLUSH TABLES WITH READ LOCK;
--connection node_1
ALTER TABLE t1 ADD COLUMN f2 INTEGER;
--connection node_2
UNLOCK TABLES;
SHOW CREATE TABLE t1;
DROP TABLE t1;
|