Debian Codegraph @

mysql-test/suite/rpl/r/rpl_plugin_load.result

raw
1 include/master-slave.inc
2 [connection master]
3 Verify that example engine is not installed.
4 SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE='EXAMPLE';
5 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
6 Get binlog position before install plugin.
7 Install example engine.
8 INSTALL PLUGIN example SONAME 'ha_example.so';
9 Get binlog position after install plugin.
10 Compute the difference of the binlog positions.
11 Should be zero as install plugin should not be replicated.
12 Delta
13 0
14 Verify that example engine is installed.
15 SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE='EXAMPLE';
16 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
17 EXAMPLE YES Example storage engine NO NO NO
18 connection slave;
19 Verify that example engine is not installed.
20 connection slave;
21 SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE='EXAMPLE';
22 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
23 Uninstall example engine.
24 connection master;
25 Get binlog position before uninstall plugin.
26 UNINSTALL PLUGIN example;
27 Get binlog position after uninstall plugin.
28 Compute the difference of the binlog positions.
29 Should be zero as uninstall plugin should not be replicated.
30 Delta
31 0
32 Verify that example engine is not installed.
33 SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE='EXAMPLE';
34 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
35 connection slave;
36 include/rpl_end.inc
37 End of test