Debian Codegraph @

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

raw
1 # Test of ipv6 format, especially "change master host=..."
2 # Options: --skip-name-resolve, master: --bind-address=0.0.0.0, slave: --bind-address=::
3 # (see corresponding cnf file)
4 #
5 # Check if ipv6 is available. If not, server is crashing (see BUG#48915).
6
7 --let $extra_root_users_for_slave= 1
8 --source include/add_extra_root_users.inc
9
10 --connection default
11 --disable_query_log
12 --disable_abort_on_error
13 connect (checkcon123456789,::1,root,,test,$SLAVE_MYPORT);
14 if($mysql_errno)
15 {
16 --source include/remove_extra_root_users.inc
17 skip wrong IP for slave;
18 }
19 connection default;
20 disconnect checkcon123456789;
21 --enable_abort_on_error
22 --enable_query_log
23 # end check
24 --source include/have_log_bin.inc
25
26 let $IPv6= ::1;
27 --echo #################### IP: $IPv6 ###########################
28 --source include/rpl_ip_mix2.inc
29
30 let $IPv6= ::1/128;
31 #--echo #################### IP: $IPv6 ###########################
32 #--source include/rpl_ip_mix2.inc
33
34 let $IPv6= 0000:0000:0000:0000:0000:0000:0000:0001;
35 --echo #################### IP: $IPv6 ###########################
36 --source include/rpl_ip_mix2.inc
37
38 let $IPv6= 0:0:0:0:0:0:0:1;
39 --echo #################### IP: $IPv6 ###########################
40 --source include/rpl_ip_mix2.inc
41
42 let $IPv6= ::1;
43 --echo #################### IP: $IPv6 mix #######################
44 --echo connect (master,127.0.0.1,root,,test,MASTER_MYPORT);
45 connect (master,127.0.0.1,root,,test,$MASTER_MYPORT);
46 --echo connect (slave,$IPv6,root,,test,SLAVE_MYPORT);
47 connect (slave,$IPv6,root,,test,$SLAVE_MYPORT);
48 --echo connection master;
49 connection master;
50 reset master;
51 source include/show_master_status.inc;
52 save_master_pos;
53 --echo connection slave;
54 connection slave;
55 reset slave;
56 let $master_host= query_get_value(SHOW SLAVE STATUS, Master_Host, 1);
57 --echo Master-Host: $master_host
58 eval CHANGE REPLICATION SOURCE to SOURCE_HOST='$IPv6';
59 let $master_host= query_get_value(SHOW SLAVE STATUS, Master_Host, 1);
60 --echo Master-Host: $master_host
61 eval CHANGE REPLICATION SOURCE to SOURCE_HOST='127.0.0.1';
62 let $master_host= query_get_value(SHOW SLAVE STATUS, Master_Host, 1);
63 --echo Master-Host: $master_host
64 eval CHANGE REPLICATION SOURCE to SOURCE_HOST='0:0:0:0:0:0:0:1';
65 let $master_host= query_get_value(SHOW SLAVE STATUS, Master_Host, 1);
66 --echo Master-Host: $master_host
67
68 # clean up
69 --replace_column 2 ####
70 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_USER='root';
71
72 --connection master
73 --source include/remove_extra_root_users.inc