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
|
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]
#### Initialize ####
SET @save_log_output = @@global.log_output;
SET @@global.log_output = 'TABLE';
SET @save_long_query_time = @@global.long_query_time;
SET @@global.long_query_time = 1;
SET @save_terminology_use_previous = @@global.terminology_use_previous;
Warnings:
Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release.
#### Test terminology_use_previous = 0 ####
* Set option
SET @@global.terminology_use_previous = 0;
Warnings:
Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release.
SELECT @@global.terminology_use_previous;
@@global.terminology_use_previous
NONE
Warnings:
Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release.
* Clear log tables
TRUNCATE mysql.slow_log;
* Pause source during REGISTER REPLICA to make it go to slow log
[connection slave]
include/stop_slave_io.inc
# Adding debug point 'syncpoint_begin_register_replica' to @@GLOBAL.debug
START REPLICA IO_THREAD;
SET @@session.debug_sync = "now WAIT_FOR reached_begin_register_replica";
* Sleep 2 seconds
* Allow REGISTER REPLICA to finish
SET @@session.debug_sync = "now SIGNAL continue_begin_register_replica";
include/wait_for_slave_io_to_start.inc
* Verify the logs contain the correct term, and not the incorrect one
include/assert.inc [Slow log should contain "Register Replica"]
include/assert.inc [Slow log should not contain "no_Register Replica"]
#### Test terminology_use_previous = 1 ####
* Set option
SET @@global.terminology_use_previous = 1;
Warnings:
Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release.
SELECT @@global.terminology_use_previous;
@@global.terminology_use_previous
BEFORE_8_0_26
Warnings:
Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release.
* Clear log tables
TRUNCATE mysql.slow_log;
* Pause source during REGISTER REPLICA to make it go to slow log
[connection slave]
include/stop_slave_io.inc
# Adding debug point 'syncpoint_begin_register_replica' to @@GLOBAL.debug
START REPLICA IO_THREAD;
SET @@session.debug_sync = "now WAIT_FOR reached_begin_register_replica";
* Sleep 2 seconds
* Allow REGISTER REPLICA to finish
SET @@session.debug_sync = "now SIGNAL continue_begin_register_replica";
include/wait_for_slave_io_to_start.inc
* Verify the logs contain the correct term, and not the incorrect one
include/assert.inc [Slow log should contain "Register Slave"]
include/assert.inc [Slow log should not contain "no_Register Slave"]
#### Clean up ####
[connection master]
SET @@global.log_output = @save_log_output;
TRUNCATE TABLE mysql.general_log;
TRUNCATE TABLE mysql.slow_log;
SET @@global.long_query_time = @save_long_query_time;
SET @@global.terminology_use_previous = @save_terminology_use_previous;
Warnings:
Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release.
# Removing debug point 'syncpoint_begin_register_replica' from @@GLOBAL.debug
include/rpl_end.inc
|
