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