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
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
|
include/master-slave.inc
[connection master]
[connection slave]
set @restore_replica_net_timeout= @@global.replica_net_timeout;
set @@global.replica_net_timeout= 10;
SELECT LAST_HEARTBEAT_TIMESTAMP FROM performance_schema.replication_connection_status;
CHANGE REPLICATION SOURCE to SOURCE_HOST='127.0.0.1',SOURCE_PORT=SOURCE_PORT, SOURCE_USER='root';
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.
SELECT HEARTBEAT_INTERVAL FROM performance_schema.replication_connection_configuration;
HEARTBEAT_INTERVAL 5.000
CHANGE REPLICATION SOURCE to SOURCE_HOST='127.0.0.1',SOURCE_PORT=SOURCE_PORT, SOURCE_USER='root', SOURCE_HEARTBEAT_PERIOD= 4294968;
ERROR HY000: The requested value for the heartbeat period is either negative or exceeds the maximum allowed (4294967 seconds).
SELECT HEARTBEAT_INTERVAL FROM performance_schema.replication_connection_configuration;
HEARTBEAT_INTERVAL 5.000
[connection slave]
CHANGE REPLICATION SOURCE to SOURCE_HOST='127.0.0.1',SOURCE_PORT=SOURCE_PORT, SOURCE_USER='root', SOURCE_HEARTBEAT_PERIOD= 0.0009999;
Warnings:
Warning #### The requested value for the heartbeat period is less than 1 millisecond. The value is reset to 0, meaning that heartbeating will effectively be disabled.
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.
SELECT HEARTBEAT_INTERVAL FROM performance_schema.replication_connection_configuration;
HEARTBEAT_INTERVAL 0.000
CHANGE REPLICATION SOURCE to SOURCE_HOST='127.0.0.1',SOURCE_PORT=SOURCE_PORT, SOURCE_USER='root', SOURCE_HEARTBEAT_PERIOD= 4294967;
Warnings:
Warning #### The requested value for the heartbeat period exceeds the value of `replica_net_timeout' seconds. A sensible value for the period should be less than the timeout.
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.
SELECT HEARTBEAT_INTERVAL FROM performance_schema.replication_connection_configuration;
HEARTBEAT_INTERVAL 4294967.000
CHANGE REPLICATION SOURCE to SOURCE_HOST='127.0.0.1',SOURCE_PORT=SOURCE_PORT, SOURCE_USER='root', SOURCE_HEARTBEAT_PERIOD= 0.001;
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.
SELECT HEARTBEAT_INTERVAL FROM performance_schema.replication_connection_configuration;
HEARTBEAT_INTERVAL 0.001
reset slave;
Warnings:
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
set @@global.replica_net_timeout= 5;
CHANGE REPLICATION SOURCE to SOURCE_HOST='127.0.0.1',SOURCE_PORT=SOURCE_PORT, SOURCE_USER='root', SOURCE_HEARTBEAT_PERIOD= 5.001;
Warnings:
Warning #### The requested value for the heartbeat period exceeds the value of `replica_net_timeout' seconds. A sensible value for the period should be less than the timeout.
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.
SELECT HEARTBEAT_INTERVAL FROM performance_schema.replication_connection_configuration;
HEARTBEAT_INTERVAL 5.001
reset slave;
Warnings:
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
set @@global.replica_net_timeout= 5;
Warnings:
Warning 1704 The requested value for the heartbeat period exceeds the value of `replica_net_timeout' seconds. A sensible value for the period should be less than the timeout.
CHANGE REPLICATION SOURCE to SOURCE_HOST='127.0.0.1',SOURCE_PORT=SOURCE_PORT, SOURCE_USER='root', SOURCE_HEARTBEAT_PERIOD= 4;
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.
SELECT HEARTBEAT_INTERVAL FROM performance_schema.replication_connection_configuration;
HEARTBEAT_INTERVAL 4.000
set @@global.replica_net_timeout= 3 /* must be a warning */;
Warnings:
Warning 1704 The requested value for the heartbeat period exceeds the value of `replica_net_timeout' seconds. A sensible value for the period should be less than the timeout.
reset slave;
Warnings:
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
[connection master]
drop table if exists t1;
[connection slave]
set @@global.replica_net_timeout= 10;
CHANGE REPLICATION SOURCE to SOURCE_HOST='127.0.0.1',SOURCE_PORT=SOURCE_PORT, SOURCE_USER='root', SOURCE_HEARTBEAT_PERIOD= 0.5;
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.
SELECT HEARTBEAT_INTERVAL FROM performance_schema.replication_connection_configuration;
HEARTBEAT_INTERVAL 0.500
start slave;
Warnings:
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
[connection master]
create table t1 (f1 int);
include/sync_slave_sql_with_master.inc
include/check_slave_param.inc [Relay_Log_File]
SELECT HEARTBEAT_INTERVAL FROM performance_schema.replication_connection_configuration;
HEARTBEAT_INTERVAL 0.500
A heartbeat has been received by the slave
include/assert.inc [last_heartbeat_timestamp should not be empty]
[connection master]
drop table t1;
include/sync_slave_sql_with_master.inc
set @@global.replica_net_timeout= @restore_replica_net_timeout;
[connection slave]
include/stop_slave.inc
CHANGE REPLICATION SOURCE TO SOURCE_HEARTBEAT_PERIOD= 10;
include/assert.inc [HEARTBEAT_INTERVAL should be 10.000]
# Verify that heartbeat period is not reset to default implicitly and
# received_heartbeat is not set to 0 by this.
CHANGE REPLICATION SOURCE TO SOURCE_RETRY_COUNT= 3;
include/assert.inc [HEARTBEAT_INTERVAL should be 10.000]
include/assert.inc [COUNT_RECEIVED_HEARTBEATS should NOT be set to 0]
include/stop_slave.inc
Warnings:
Note 3084 Replication thread(s) for channel '' are already stopped.
RESET SLAVE;
Warnings:
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
RESET MASTER;
CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION;
include/start_slave.inc
include/assert.inc [HEARTBEAT_INTERVAL should still be 10.000 after RESET SLAVE.]
include/stop_slave_io.inc
CHANGE REPLICATION SOURCE TO SOURCE_HOST= 'localhost', SOURCE_PORT= SOURCE_PORT;
include/start_slave.inc
include/assert.inc [HEARTBEAT_INTERVAL should reset to default.]
#
# Change from default to make sure changing HOST resets heartbeat_interval
# to default.
#
include/stop_slave_io.inc
CHANGE REPLICATION SOURCE TO SOURCE_HEARTBEAT_PERIOD = 10;
include/start_slave.inc
DROP TABLE IF EXISTS t1;
include/sync_slave_sql_with_master.inc
include/stop_slave.inc
CHANGE REPLICATION SOURCE TO SOURCE_HOST= '127.0.0.1';
include/start_slave.inc
include/assert.inc [heartbeat_interval should reset to default on changing host.]
DROP TABLE IF EXISTS t1;
include/sync_slave_sql_with_master.inc
#
# Change from default to make sure changing PORT resets heartbeat_interval
# to default.
#
include/stop_slave.inc
CHANGE REPLICATION SOURCE TO SOURCE_HEARTBEAT_PERIOD = 10;
include/start_slave.inc
DROP TABLE IF EXISTS t1;
include/sync_slave_sql_with_master.inc
include/stop_slave.inc
CHANGE REPLICATION SOURCE TO SOURCE_PORT= SOURCE_PORT;
include/start_slave.inc
include/assert.inc [heartbeat_interval should reset to default on changing port.]
DROP TABLE IF EXISTS t1;
include/sync_slave_sql_with_master.inc
#
# Change from default to make sure changing HOST and PORT resets
# heartbeat_period to default.
#
include/stop_slave.inc
CHANGE REPLICATION SOURCE TO SOURCE_HOST= '127.0.0.1', SOURCE_PORT= SOURCE_PORT;
include/start_slave.inc
include/assert.inc [heartbeat_interval should reset to default on changing host and port.]
DROP TABLE IF EXISTS t1;
include/sync_slave_sql_with_master.inc
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
include/assert.inc [heartbeat_interval should reset to zero by RESET SLAVE ALL.]
CHANGE REPLICATION SOURCE to SOURCE_HOST= '127.0.0.1', SOURCE_PORT= SOURCE_PORT, SOURCE_USER= 'root';
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.
include/start_slave.inc
DROP TABLE IF EXISTS t1;
include/sync_slave_sql_with_master.inc
include/rpl_end.inc
|
