1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
include/have_replication_observers_example_plugin.inc
SET @saved_master_info_repository = @@GLOBAL.master_info_repository;
SET @saved_relay_log_info_repository = @@GLOBAL.relay_log_info_repository;
include/install_replication_observers_example.inc
CALL mtr.add_suppression('For the creation of replication channels the server *');
CALL mtr.add_suppression('For the creation of replication channels the connection metadata *');
CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
SET @original_slave_server_id= @@GLOBAL.server_id;
SET @debug_saved= @@GLOBAL.DEBUG;
SET @@GLOBAL.DEBUG= '+d,validate_replication_observers_plugin_server_channels_init';
SET @@GLOBAL.server_id= 0;
INSERT INTO t1 VALUES(1);
SET @@GLOBAL.server_id= @original_slave_server_id;
SET @@GLOBAL.relay_log_info_repository='FILE';
Warnings:
Warning 1287 '@@relay_log_info_repository' is deprecated and will be removed in a future release.
SET @@GLOBAL.master_info_repository='TABLE';
Warnings:
Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
INSERT INTO t1 VALUES(2);
SET @@GLOBAL.relay_log_info_repository='TABLE';
Warnings:
Warning 1287 '@@relay_log_info_repository' is deprecated and will be removed in a future release.
SET @@GLOBAL.master_info_repository='FILE';
Warnings:
Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
INSERT INTO t1 VALUES(3);
SET @@GLOBAL.master_info_repository = @saved_master_info_repository;
SET @@GLOBAL.relay_log_info_repository = @saved_relay_log_info_repository;
SET @@GLOBAL.DEBUG= @debug_saved;
DROP TABLE t1;
include/uninstall_replication_observers_example.inc
|
