Debian Codegraph @

mysql-test/suite/galera/t/galera_server.test

raw
1 # Test for CREATE/ALTER/DROP SERVER in Galera cluster
2
3 --source include/galera_cluster.inc
4
5 --connection node_1
6 --echo # On node_1
7 CREATE SERVER s1
8 FOREIGN DATA WRAPPER mysql
9 OPTIONS (HOST 'foo');
10
11 --connection node_2
12 --echo # On node_2
13 SELECT * FROM mysql.servers;
14 ALTER SERVER s1
15 OPTIONS (HOST 'bar');
16
17 --connection node_1
18 --echo # On node_1
19 SELECT * FROM mysql.servers;
20 DROP SERVER s1;
21
22 --connection node_2
23 --echo # On node_2
24 SELECT COUNT(*)=0 FROM mysql.servers;
25
26 --source include/galera_end.inc
27 --echo # End of test