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