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