--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;