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
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
|
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]
#
# Create a new channel from the slave to the third server.
# There shall be an error
[connection server_2]
CHANGE REPLICATION SOURCE TO SOURCE_HOST = "127.0.0.1", SOURCE_PORT = MASTER_PORT FOR CHANNEL "channel_3";;
ERROR HY000: To have multiple channels, repository cannot be of type FILE; Please check the repository configuration and convert them to TABLE.
# Convert only master_info_repository to table.
# The same error shall persist
include/stop_slave.inc
SET @@GLOBAL.master_info_repository ="TABLE";
Warnings:
Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
call mtr.add_suppression("Replica: Cannot create new connection metadata structure when repositories are of type FILE. Convert replica repositories to TABLE to replicate from multiple sources.");
CHANGE REPLICATION SOURCE TO SOURCE_HOST = "127.0.0.1", SOURCE_USER = "root", SOURCE_PORT = MASTER_PORT FOR CHANNEL "channel_3";;
ERROR HY000: To have multiple channels, repository cannot be of type FILE; Please check the repository configuration and convert them to TABLE.
# Convert only relay log info repository to TABLE
# The same error shall remain
SET @@GLOBAL.master_info_repository = "FILE";
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.
CHANGE REPLICATION SOURCE TO SOURCE_HOST = "127.0.0.1", SOURCE_USER = "root", SOURCE_PORT = MASTER_PORT FOR CHANNEL "channel_3";;
ERROR HY000: To have multiple channels, repository cannot be of type FILE; Please check the repository configuration and convert them to TABLE.
#
# Convert both repositories to TABLE. CHANGE MASTER command passes
#
SET @@GLOBAL.master_info_repository = "TABLE";
Warnings:
Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
CHANGE REPLICATION SOURCE TO SOURCE_HOST ="127.0.0.1", SOURCE_USER ="root", SOURCE_PORT=MASTER_PORT FOR CHANNEL "channel_3";
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.
# Slave now is a multisourced slave.
# Restart the slave and check that slave threads are not started because
# the repositories are of type FILE
call mtr.add_suppression("Replica: This replica was a multisourced replica previously*");
call mtr.add_suppression("Failed to create or recover replication info repositories");
include/rpl_restart_server.inc [server_number=2]
SHOW SLAVE STATUS;
Warnings:
Level Warning
Code 1287
Message 'SHOW SLAVE STATUS' is deprecated and will be removed in a future release. Please use SHOW REPLICA STATUS instead
include/assert.inc [there shall be only 0 rows as the slave is not configured.]
#
# Test that if slave server is started with TABLE, replication proceeds
# as usual.
include/rpl_restart_server.inc [server_number=2 parameters: --master-info-repository=TABLE --relay-log-info-repository=TABLE]
include/assert.inc [there shall be only 2 rows as slave is restarted properly]
#
# Set slave repostiories to FILE. An error is generated.
#
SET @@GLOBAL.master_info_repository = "FILE";
ERROR HY000: Failure while changing the type of replication repository: Repository conversion is possible when only default channel exists.
SET @@GLOBAL.relay_log_info_repository = "FILE";
ERROR HY000: Failure while changing the type of replication repository: Repository conversion is possible when only default channel exists.
SHOW VARIABLES LIKE '%info_repository%';
Variable_name Value
master_info_repository TABLE
relay_log_info_repository TABLE
#
# Currently slave repositores are of type TABLE. Try again
# again setting to TABLE. Returns success doing nothing.
#
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.
include/stop_slave.inc [FOR CHANNEL 'channel_3']
Warnings:
Note 3084 Replication thread(s) for channel 'channel_3' are already stopped.
RESET SLAVE ALL FOR CHANNEL 'channel_3';
Warnings:
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
include/rpl_restart_server.inc [server_number=2 parameters: --master-info-repository=FILE --relay-log-info-repository=FILE]
include/rpl_end.inc
|
