|
1
by brian
clean slate |
1 |
# TBF - difference in row level logging |
2 |
# Temp tables are not replicated in rbr, but it is still good to hit rbr with everthing |
|
3 |
||
4 |
# See SHOW SLAVE STATUS displays well after RESET SLAVE (it should display the |
|
5 |
# --master-* options from mysqld, as this is what is going to be used next time |
|
6 |
# slave threads will be started). In bug 985, it displayed old values (of before |
|
7 |
# RESET SLAVE). |
|
8 |
# See if slave crashes when doing a CREATE TEMPORARY TABLE twice, separated by |
|
9 |
# RESET SLAVE. |
|
10 |
||
11 |
-- source include/master-slave.inc
|
|
12 |
connection master; |
|
13 |
save_master_pos; |
|
14 |
connection slave; |
|
15 |
sync_with_master; |
|
16 |
source include/show_slave_status2.inc; |
|
17 |
||
18 |
stop slave; |
|
19 |
change master to master_user='test'; |
|
20 |
source include/show_slave_status2.inc; |
|
21 |
||
22 |
reset slave; |
|
23 |
source include/show_slave_status2.inc; |
|
24 |
||
25 |
change master to master_user='root'; |
|
26 |
start slave; |
|
27 |
sync_with_master; |
|
28 |
source include/show_slave_status2.inc; |
|
29 |
||
30 |
# test of crash with temp tables & RESET SLAVE |
|
31 |
# (test to see if RESET SLAVE clears temp tables in memory and disk) |
|
32 |
stop slave; |
|
33 |
reset slave; |
|
34 |
start slave; |
|
35 |
connection master; |
|
36 |
create temporary table t1 (a int); |
|
37 |
save_master_pos; |
|
38 |
connection slave; |
|
39 |
sync_with_master; |
|
40 |
stop slave; |
|
41 |
reset slave; |
|
42 |
start slave; |
|
43 |
sync_with_master; |
|
44 |
show status like 'slave_open_temp_tables'; |