Debian Codegraph @

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

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