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
|
call mtr.add_suppression("Invalid .* username when attempting to connect to the source server");
SET GLOBAL master_info_repository='TABLE';
Warnings:
Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
SET GLOBAL relay_log_info_repository='TABLE';
Warnings:
Warning 1287 '@@relay_log_info_repository' is deprecated and will be removed in a future release.
#
# 1. Without having a default channel configured
#
# Create two additional replication channels
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_LOG_FILE='binlog-ch1.000001', SOURCE_LOG_POS=4 FOR CHANNEL 'ch1';
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_LOG_FILE='binlog-ch2.000001', SOURCE_LOG_POS=4 FOR CHANNEL 'ch2';
# Execute mysqldump with --dump-replica
CHANGE MASTER TO MASTER_LOG_FILE='binlog-ch1.000001', MASTER_LOG_POS=4 FOR CHANNEL 'ch1';
CHANGE MASTER TO MASTER_LOG_FILE='binlog-ch2.000001', MASTER_LOG_POS=4 FOR CHANNEL 'ch2';
# Execute mysql using the dump as input
include/stop_slave.inc
#
# 2. With a default channel configured
#
# Setup the default replication channel
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_LOG_FILE="binlog-default.000001", SOURCE_LOG_POS=4 FOR CHANNEL '';
# Execute mysqldump with --dump-replica
CHANGE MASTER TO MASTER_LOG_FILE='binlog-default.000001', MASTER_LOG_POS=4 FOR CHANNEL '';
CHANGE MASTER TO MASTER_LOG_FILE='binlog-ch1.000001', MASTER_LOG_POS=4 FOR CHANNEL 'ch1';
CHANGE MASTER TO MASTER_LOG_FILE='binlog-ch2.000001', MASTER_LOG_POS=4 FOR CHANNEL 'ch2';
# Execute mysql using the dump as input
include/stop_slave.inc
RESET SLAVE ALL;
Warnings:
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
SET @@global.master_info_repository='SAVE_CM_REPO_TYPE';
SET @@global.relay_log_info_repository='SAVE_AM_REPO_TYPE';
|
