Debian Codegraph @

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

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 Verify that example engine is not installed.
7 SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE='EXAMPLE';
8 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
9 Get binlog position before install plugin.
10 Install example engine.
11 INSTALL PLUGIN example SONAME 'ha_example.so';
12 Get binlog position after install plugin.
13 Compute the difference of the binlog positions.
14 Should be zero as install plugin should not be replicated.
15 Delta
16 0
17 Verify that example engine is installed.
18 SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE='EXAMPLE';
19 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
20 EXAMPLE YES Example storage engine NO NO NO
21 include/sync_slave_sql_with_master.inc
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.
31 Delta
32 0
33 Verify that example engine is not installed.
34 SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE='EXAMPLE';
35 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
36 include/sync_slave_sql_with_master.inc
37 include/rpl_end.inc
38 End of test