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
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
|
include/have_replication_observers_example_plugin.inc
include/master-slave.inc
Warnings:
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
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.
[connection master]
#
# Stop slave and install plugin.
#
include/stop_slave.inc
include/install_replication_observers_example.inc
#
# Cause a reset slave notification.
#
RESET SLAVE;
Warnings:
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
#
# Cause a connect notification.
#
include/start_slave.inc
#
# Execute some transactions on master to cause the other notifications.
#
CREATE TABLE t1 (c1 INT) Engine=InnoDB;
INSERT t1 VALUES(1);
DROP TABLE t1;
include/sync_slave_sql_with_master.inc
#
# Stop slave and uninstall plugin.
#
include/stop_slave.inc
include/uninstall_replication_observers_example.inc
#
# Verify that all relay hooks were called.
#
Matching lines are:
replication_observers_example_plugin:binlog_relay_after_reset_slave'
Occurrences of 'replication_observers_example_plugin:binlog_relay_after_reset_slave' in the input file: 1
Matching lines are:
replication_observers_example_plugin:binlog_relay_thread_start'
Occurrences of 'replication_observers_example_plugin:binlog_relay_thread_start' in the input file: 1
Matching lines are:
replication_observers_example_plugin:binlog_relay_before_request_transmit'
Occurrences of 'replication_observers_example_plugin:binlog_relay_before_request_transmit' in the input file: 1
Matching lines are:
replication_observers_example_plugin:binlog_relay_after_read_event'
Occurrences of 'replication_observers_example_plugin:binlog_relay_after_read_event' in the input file: 1
Matching lines are:
replication_observers_example_plugin:binlog_relay_after_queue_event'
Occurrences of 'replication_observers_example_plugin:binlog_relay_after_queue_event' in the input file: 1
Matching lines are:
replication_observers_example_plugin:binlog_relay_applier_start'
Occurrences of 'replication_observers_example_plugin:binlog_relay_applier_start' in the input file: 1
Matching lines are:
replication_observers_example_plugin:binlog_relay_applier_stop'
Occurrences of 'replication_observers_example_plugin:binlog_relay_applier_stop' in the input file: 1
Matching lines are:
replication_observers_example_plugin:binlog_relay_thread_stop'
Occurrences of 'replication_observers_example_plugin:binlog_relay_thread_stop' in the input file: 1
include/rpl_end.inc
|
