2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
Verify that example engine is not installed.
8
SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE='EXAMPLE';
9
ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
10
Get binlog position before install plugin.
11
Install example engine.
12
INSTALL PLUGIN example SONAME 'ha_example.so';
13
Get binlog position after install plugin.
14
Compute the difference of the binlog positions.
15
Should be zero as install plugin should not be replicated.
18
Verify that example engine is installed.
19
SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE='EXAMPLE';
20
ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
21
EXAMPLE YES Example storage engine NO NO NO
22
connection slave: Verify that example engine is not installed.
23
SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE='EXAMPLE';
24
ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
25
connection master: Uninstall example engine.
26
Get binlog position before uninstall plugin.
27
UNINSTALL PLUGIN example;
28
Get binlog position after uninstall plugin.
29
Compute the difference of the binlog positions.
30
Should be zero as uninstall plugin should not be replicated.
33
Verify that example engine is not installed.
34
SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE='EXAMPLE';
35
ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS