Debian Codegraph @

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

raw
1 # Test of ipv6 format, especially "change master host=..."
2 # Options: --skip-name-resolve, --bind-address=:: (see corresponding cnf file)
3 # for master and slave.
4 #
5
6 --connection default
7
8 --source include/check_ipv6.inc
9
10 --let $extra_root_users_for_slave= 1
11 --source include/add_extra_root_users.inc
12
13 # Can't be tested with windows due to mixed format like 0::0000:FFFF:127.0.0.1
14 --source include/not_windows.inc
15 --source include/have_log_bin.inc
16
17 let $IPv6= ::1;
18 --echo #################### IP: $IPv6 ###########################
19 --source include/rpl_ipv6.inc
20
21 let $IPv6= ::1/128;
22 #--echo #################### IP: $IPv6 ###########################
23 #--source include/rpl_ipv6.inc
24
25 let $IPv6= 0000:0000:0000:0000:0000:0000:0000:0001;
26 --echo #################### IP: $IPv6 ###########################
27 --source include/rpl_ipv6.inc
28
29 let $IPv6= 0:0:0:0:0:0:0:1;
30 --echo #################### IP: $IPv6 ###########################
31 --source include/rpl_ipv6.inc
32
33 let $IPv6= ::1;
34 --echo #################### IP: $IPv6 mix #######################
35 --echo connect (master,127.0.0.1,root,,test,MASTER_MYPORT);
36 connect (master,127.0.0.1,root,,test,$MASTER_MYPORT);
37 --echo connect (slave,127.0.0.1,root,,test,SLAVE_MYPORT);
38 connect (slave,127.0.0.1,root,,test,$SLAVE_MYPORT);
39 --echo connection master;
40 connection master;
41 reset master;
42 source include/show_master_status.inc;
43 save_master_pos;
44 --echo connection slave;
45 connection slave;
46 reset slave;
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='$IPv6';
50 let $master_host= query_get_value(SHOW SLAVE STATUS, Master_Host, 1);
51 --echo Master-Host: $master_host
52 eval change replication source to source_host='127.0.0.1';
53 let $master_host= query_get_value(SHOW SLAVE STATUS, Master_Host, 1);
54 --echo Master-Host: $master_host
55 eval change replication source to source_host='0:0:0:0:0:0:0:1';
56 let $master_host= query_get_value(SHOW SLAVE STATUS, Master_Host, 1);
57 --echo Master-Host: $master_host
58
59 # clean up
60 --replace_column 2 ####
61 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_USER='root';
62
63 connection master;
64 --source include/remove_extra_root_users.inc