1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
|
include/master-slave.inc
Warnings:
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
[connection master]
include/install_semisync.inc
SET @max_binlog_size_save= @@GLOBAL.MAX_BINLOG_SIZE;
SET @@GLOBAL.MAX_BINLOG_SIZE= 4096;
SET GLOBAL rpl_semi_sync_source_timeout= 6000000;
#
# Verify it on AFTER_SYNC wait point
# ==============================================================
# Flush error happens before AFTER_SYNC wait point. So
#
[connection master]
SET GLOBAL rpl_semi_sync_source_wait_point= AFTER_SYNC;
# Disable diff_table test
# Test tables with MyISAM engine when disabling diff_table and
# simulating flush error
include/sync_slave_sql_with_master.inc
# Build connections to master server
# Stress test that execute massive queries on every connection
include/sync_slave_sql_with_master.inc
# Enable diff_table test
# Test tables with InnoDB engine when enableing diff_table
# and simulating flush error
include/sync_slave_sql_with_master.inc
# Build connections to master server
# Stress test that execute massive queries on every connection
include/sync_slave_sql_with_master.inc
# Test if the results are consistent on master and slave
include/diff_tables.inc [master:t1, slave:t1]
include/diff_tables.inc [master:t2, slave:t2]
include/diff_tables.inc [master:t3, slave:t3]
include/diff_tables.inc [master:t4, slave:t4]
include/diff_tables.inc [master:t5, slave:t5]
include/diff_tables.inc [master:t6, slave:t6]
include/diff_tables.inc [master:t7, slave:t7]
include/diff_tables.inc [master:t8, slave:t8]
include/diff_tables.inc [master:t9, slave:t9]
include/diff_tables.inc [master:t10, slave:t10]
include/sync_slave_sql_with_master.inc
#
# Verify it on AFTER_COMMIT wait point
# ==============================================================
#
[connection master]
SET GLOBAL rpl_semi_sync_source_wait_point= AFTER_COMMIT;
# Disable diff_table test
# Test tables with MyISAM engine when disabling diff_table and
# simulating flush error
include/sync_slave_sql_with_master.inc
# Build connections to master server
# Stress test that execute massive queries on every connection
include/sync_slave_sql_with_master.inc
# Enable diff_table test
# Test tables with InnoDB engine when enableing diff_table
# and simulating flush error
include/sync_slave_sql_with_master.inc
# Build connections to master server
# Stress test that execute massive queries on every connection
include/sync_slave_sql_with_master.inc
# Test if the results are consistent on master and slave
include/diff_tables.inc [master:t1, slave:t1]
include/diff_tables.inc [master:t2, slave:t2]
include/diff_tables.inc [master:t3, slave:t3]
include/diff_tables.inc [master:t4, slave:t4]
include/diff_tables.inc [master:t5, slave:t5]
include/diff_tables.inc [master:t6, slave:t6]
include/diff_tables.inc [master:t7, slave:t7]
include/diff_tables.inc [master:t8, slave:t8]
include/diff_tables.inc [master:t9, slave:t9]
include/diff_tables.inc [master:t10, slave:t10]
include/sync_slave_sql_with_master.inc
SET @@GLOBAL.MAX_BINLOG_SIZE= @max_binlog_size_save;
include/uninstall_semisync.inc
include/rpl_end.inc
|
