Debian Codegraph @

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

raw
1 # Test of ipv6 format, especially "change master host=..."
2 # Options: --skip-name-resolve, master: --bind-address=::, slave: --bind-address=0.0.0.0
3 # (see corresponding cnf file)
4 #
5
6 --source include/check_ipv6.inc
7 --source include/have_log_bin.inc
8
9 --let $extra_root_users_for_slave= 1
10 --source include/add_extra_root_users.inc
11
12 let $IPv6= ::1;
13 --echo #################### IP: $IPv6 ###########################
14 --source include/rpl_ip_mix.inc
15
16 let $IPv6= ::1/128;
17 #--echo #################### IP: $IPv6 ###########################
18 #--source include/rpl_ip_mix.inc
19
20 let $IPv6= 0000:0000:0000:0000:0000:0000:0000:0001;
21 --echo #################### IP: $IPv6 ###########################
22 --source include/rpl_ip_mix.inc
23
24 let $IPv6= 0:0:0:0:0:0:0:1;
25 --echo #################### IP: $IPv6 ###########################
26 --source include/rpl_ip_mix.inc
27
28 let $IPv6= ::1;
29 --echo #################### IP: $IPv6 mix #######################
30 --echo connect (master,$IPv6,root,,test,MASTER_MYPORT);
31 connect (master,$IPv6,root,,test,$MASTER_MYPORT);
32 --echo connect (slave,127.0.0.1,root,,test,SLAVE_MYPORT);
33 connect (slave,127.0.0.1,root,,test,$SLAVE_MYPORT);
34 --echo connection master;
35 connection master;
36 reset master;
37 source include/show_master_status.inc;
38 --echo connection slave;
39 connection slave;
40 reset slave;
41 let $master_host= query_get_value(SHOW SLAVE STATUS, Master_Host, 1);
42 --echo Master-Host: $master_host
43 eval CHANGE REPLICATION SOURCE to SOURCE_HOST='$IPv6';
44 let $master_host= query_get_value(SHOW SLAVE STATUS, Master_Host, 1);
45 --echo Master-Host: $master_host
46 eval CHANGE REPLICATION SOURCE to SOURCE_HOST='127.0.0.1';
47 let $master_host= query_get_value(SHOW SLAVE STATUS, Master_Host, 1);
48 --echo Master-Host: $master_host
49 eval CHANGE REPLICATION SOURCE to SOURCE_HOST='0:0:0:0:0:0:0:1';
50 let $master_host= query_get_value(SHOW SLAVE STATUS, Master_Host, 1);
51 --echo Master-Host: $master_host
52
53 # clean up
54 --replace_column 2 ####
55 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_USER='root';
56
57 # Current master connects using $IPv6= ::1. This user happens to be deleted
58 # first in the inc file below. With WL#12098, the current user loses
59 # the ability to delete other users if it deletes itself first.
60 # Therefore, connecting with user which is deleted in the end.
61 connect (master_IPv4,127.0.0.1,root,,test,$MASTER_MYPORT);
62 --source include/remove_extra_root_users.inc