Debian Codegraph @

mysql-test/suite/rpl/t/rpl_slave_alias_replica.test

raw
1 # ==== Purpose ====
2 #
3 # Test verifies that SQL statements which use keyword 'REPLICA' a synonym for
4 # 'SLAVE' work as expected.
5 #
6 # ==== Implementation ====
7 #
8 # List of commands being verified are
9 # On Master: SHOW REPLICA HOSTS
10 # : Privilege "REPLICA"
11 #
12 # On Slave: START REPLICA
13 # START REPLICA UNTIL
14 # STOP REPLICA
15 # SHOW REPLICA STATUS
16 # RESET REPLICA ALL
17 # REPLICA_POS
18 #
19 # ==== References ====
20 #
21 # MDEV-20601: Make REPLICA a synonym for SLAVE in SQL statements
22 #
23
24 --source include/have_innodb.inc
25 --source include/master-slave.inc
26
27 --echo "Command: STOP SLAVE --> STOP REPLICA"
28 --connection slave
29 STOP REPLICA;
30 --source include/wait_for_slave_io_to_stop.inc
31 --source include/wait_for_slave_sql_to_stop.inc
32
33 --connection master
34 CREATE USER 'repl_user';
35 --echo "Privilege: SLAVE --> REPLICA"
36 GRANT REPLICATION REPLICA on *.* TO repl_user;
37 FLUSH PRIVILEGES;
38
39 --connection slave
40 --echo "SHOW SLAVE STATUS --> SHOW REPLICA STATUS"
41 --let $master_user= query_get_value(SHOW REPLICA STATUS, Master_User, 1)
42 CHANGE MASTER TO MASTER_USER= 'repl_user';
43 --echo "Command: START SLAVE --> START REPLICA"
44 START REPLICA;
45 --source include/wait_for_slave_io_to_start.inc
46 --source include/wait_for_slave_sql_to_start.inc
47
48 --connection master
49 --sync_slave_with_master
50
51 --connection master
52 --echo "Command: SHOW SLAVE HOSTS --> SHOW REPLICA HOSTS"
53 let $show_statement= SHOW REPLICA HOSTS;
54 let $field= Server_id;
55 # Slave's server_id 2
56 let $condition= ='2';
57 source include/wait_show_condition.inc;
58 DROP USER 'repl_user';
59 --sync_slave_with_master
60
61 --echo "Command: SHOW SLAVE IO/SQL THREAD --> SHOW REPLICA IO/SQL THREAD"
62 STOP REPLICA IO_THREAD;
63 STOP REPLICA SQL_THREAD;
64 --source include/wait_for_slave_io_to_stop.inc
65 --source include/wait_for_slave_sql_to_stop.inc
66 --echo "Command: RESET SLAVE ALL --> RESET REPLICA ALL"
67 RESET REPLICA ALL;
68 set @@global.gtid_slave_pos= "";
69
70 --connection master
71 RESET MASTER;
72 CREATE TABLE t(f INT) ENGINE=INNODB;
73 INSERT INTO t VALUES (10);
74 let $master_log_file= query_get_value(SHOW MASTER STATUS, File, 1);
75 let $master_pos= query_get_value(SHOW MASTER STATUS, Position, 1);
76 DROP TABLE t;
77
78 --connection slave
79 --replace_result $MASTER_MYPORT MASTER_PORT
80 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1',MASTER_PORT=$MASTER_MYPORT,MASTER_USER='$master_user';
81 --echo "Command: START SLAVE UNTIL --> START REPLICA UNTIL"
82 --replace_result $master_log_file MASTER_LOG_FILE $master_pos MASTER_POS
83 --eval START REPLICA UNTIL MASTER_LOG_FILE='$master_log_file', MASTER_LOG_POS=$master_pos
84 --source include/wait_for_slave_sql_to_stop.inc
85 --source include/stop_slave_io.inc
86
87 SELECT * FROM t;
88 --let $slave_param= Exec_Master_Log_Pos
89 --let $slave_param_value= $master_pos
90 --source include/check_slave_param.inc
91
92 --replace_result $MASTER_MYPORT MASTER_PORT
93 --echo "MASTER_USE_GTID=SLAVE_POS --> MASTER_USE_GTID=REPLICA_POS"
94 --replace_result $MASTER_MYPORT MASTER_PORT
95 --eval CHANGE MASTER TO master_host = '127.0.0.1', master_port = $MASTER_MYPORT, MASTER_USE_GTID=REPLICA_POS
96 --source include/start_slave.inc
97
98 --connection master
99 CREATE TABLE t2 (f INT PRIMARY KEY) ENGINE=INNODB;
100 INSERT INTO t2 VALUES (10);
101 DROP TABLE t2;
102
103 --source include/rpl_end.inc