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
|
#
# Bug#27122947: RSA PUBLIC KEY GETS CACHED ON SLAVE
# WHICH IS USED BY SUBSEQUENT LOGINS
#
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 new replication user ====
[connection master]
CREATE USER u27122947 IDENTIFIED WITH 'caching_sha2_password' BY 'pwd';
GRANT REPLICATION SLAVE ON *.* TO u27122947;
==== Start using new replication user on slave ====
include/sync_slave_sql_with_master.inc
[connection slave]
include/stop_slave.inc
CHANGE REPLICATION SOURCE TO SOURCE_USER='u27122947', SOURCE_PASSWORD='pwd', SOURCE_PUBLIC_KEY_PATH='MYSQL_TEST_DIR/std_data/rsa_public_key.pem';
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
==== Make sure that replication works ====
[connection master]
CREATE TABLE t1 (c1 INT);
INSERT INTO t1 VALUES (1);
include/sync_slave_sql_with_master.inc
[connection slave]
SELECT * FROM t1;
c1
1
==== Stop slave and used empty values for master_public_key_path ====
[connection slave]
include/stop_slave.inc
CHANGE REPLICATION SOURCE TO SOURCE_USER='u27122947', SOURCE_PASSWORD='pwd', SOURCE_PUBLIC_KEY_PATH='';
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.
==== Remove cached password from master ====
[connection master]
FLUSH PRIVILEGES;
INSERT INTO t1 VALUES (2);
==== Try START SLAVE on slave : I/O thread should throw error ====
[connection slave]
START SLAVE;
Warnings:
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
include/wait_for_slave_io_error.inc [errno=2061]
==== Try setting correct public key ====
[connection slave]
include/stop_slave.inc
CHANGE REPLICATION SOURCE TO SOURCE_USER='u27122947', SOURCE_PASSWORD='pwd', SOURCE_PUBLIC_KEY_PATH='MYSQL_TEST_DIR/std_data/rsa_public_key.pem';
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
==== Try setting master_public_key_path to '' ====
[connection slave]
include/stop_slave.inc
CHANGE REPLICATION SOURCE TO SOURCE_USER='u27122947', SOURCE_PASSWORD='pwd', SOURCE_PUBLIC_KEY_PATH='';
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.
==== IO thread should start without issues because password is still cached ====
include/start_slave.inc
[connection master]
include/sync_slave_sql_with_master.inc
SELECT * FROM t1;
c1
1
2
==== Reset and cleanup ====
[connection slave]
include/stop_slave.inc
CHANGE REPLICATION SOURCE TO SOURCE_USER = 'root', SOURCE_PASSWORD = '';
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/rpl_reset.inc
[connection master]
DROP TABLE t1;
DROP USER u27122947;
include/sync_slave_sql_with_master.inc
include/rpl_end.inc
|
