######################################### # Author: Serge Kozlov skozlov@mysql.com # Date: 07/10/2006 # Purpose: Showing data from work tables on master and on slave # Requirements: ######################################### --echo ==========MASTER========== SELECT COUNT(*) FROM t1; SELECT * FROM t1 ORDER BY a; SELECT COUNT(*) FROM t2; SELECT * FROM t2 ORDER BY a; sync_slave_with_master; --echo ==========SLAVE=========== USE test_rpl; SELECT COUNT(*) FROM t1; SELECT * FROM t1 ORDER BY a; SELECT COUNT(*) FROM t2; SELECT * FROM t2 ORDER BY a; connection master;
Name | Type | Size | Permission | Actions |
---|---|---|---|---|
rpl_mixed_check_db.inc | File | 396 B | 0644 |
|
rpl_mixed_check_event.inc | File | 430 B | 0644 |
|
rpl_mixed_check_select.inc | File | 568 B | 0644 |
|
rpl_mixed_check_table.inc | File | 446 B | 0644 |
|
rpl_mixed_check_user.inc | File | 522 B | 0644 |
|
rpl_mixed_check_view.inc | File | 452 B | 0644 |
|
rpl_mixed_clear_tables.inc | File | 257 B | 0644 |
|
rpl_mixed_ddl.inc | File | 2.92 KB | 0644 |
|
rpl_mixed_dml.inc | File | 10.61 KB | 0644 |
|
rpl_mixed_show_binlog_format.inc | File | 388 B | 0644 |
|
rpl_partition.inc | File | 3.82 KB | 0644 |
|