|
1
by brian
clean slate |
1 |
source include/master-slave.inc; |
2 |
||
3 |
#
|
|
4 |
# Test of init_slave variable
|
|
5 |
#
|
|
6 |
||
7 |
set global max_connections=151; |
|
8 |
||
9 |
connection slave; |
|
10 |
stop slave; |
|
11 |
source include/wait_for_slave_to_stop.inc; |
|
12 |
start slave; |
|
13 |
source include/wait_for_slave_to_start.inc; |
|
14 |
||
15 |
connection master; |
|
16 |
save_master_pos; |
|
17 |
connection slave; |
|
18 |
show variables like 'init_slave'; |
|
19 |
show variables like 'max_connections'; |
|
20 |
sync_with_master; |
|
21 |
reset master; |
|
22 |
connection master; |
|
23 |
show variables like 'init_slave'; |
|
24 |
show variables like 'max_connections'; |
|
25 |
save_master_pos; |
|
26 |
connection slave; |
|
27 |
sync_with_master; |
|
28 |
# Save variable value
|
|
29 |
set @my_global_init_connect= @@global.init_connect; |
|
30 |
set global init_connect="set @c=1"; |
|
31 |
show variables like 'init_connect'; |
|
32 |
connection master; |
|
33 |
save_master_pos; |
|
34 |
connection slave; |
|
35 |
sync_with_master; |
|
36 |
stop slave; |
|
37 |
||
38 |
# Restore changed global variable
|
|
39 |
set global init_connect= @my_global_init_connect; |
|
40 |
set global max_connections= default; |
|
41 |
||
42 |
# End of 4.1 tests
|