Debian Codegraph @

mysql-test/suite/galera_sr/t/galera_sr_create_drop.test

raw
1 #
2 # Verify that CREATE/DROP DDLs work when streaming replication is on.
3 #
4
5 --source include/galera_cluster.inc
6
7 SET SESSION wsrep_trx_fragment_size=1;
8
9 #
10 # CREATE/DROP TABLE succeeds and the change is propagated to node_2.
11 #
12 CREATE TABLE t1 (f1 INT PRIMARY KEY) ENGINE=InnoDB;
13 --connection node_2
14 SHOW CREATE TABLE t1;
15 --connection node_1
16 DROP TABLE t1;
17 --connection node_2
18 --error ER_NO_SUCH_TABLE
19 SHOW CREATE TABLE t1;
20
21 #
22 # CREATE/DROP DATABASE succeeds and the change is propagated to node_2.
23 #
24 CREATE DATABASE mdev_18587;
25 --connection node_2
26 SHOW DATABASES LIKE 'mdev_18587';
27 --connection node_1
28 DROP DATABASE mdev_18587;
29 --connection node_2
30 SHOW DATABASES LIKE 'mdev_18587';
31 --connection node_1
32
33 SET SESSION wsrep_trx_fragment_size=DEFAULT;