| 1 |
include/only_with_option.inc [GLOBAL.replica_transaction_retries > 2] |
| 2 |
include/master-slave.inc |
| 3 |
Warnings: |
| 4 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 5 |
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. |
| 6 |
[connection master] |
| 7 |
SET SESSION binlog_rows_query_log_events = ON; |
| 8 |
CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 INT, INDEX(c2)) ENGINE = InnoDB; |
| 9 |
include/sync_slave_sql_with_master.inc |
| 10 |
include/stop_slave.inc |
| 11 |
[connection master] |
| 12 |
INSERT INTO t1 VALUES (0, 0); |
| 13 |
[connection slave] |
| 14 |
# Adding debug point 'error_on_rows_query_event_apply' to @@GLOBAL.debug |
| 15 |
include/start_slave.inc |
| 16 |
SET DEBUG_SYNC = "now WAIT_FOR end_retries_on_rows_query_event_apply"; |
| 17 |
[connection master] |
| 18 |
include/sync_slave_sql_with_master.inc |
| 19 |
# Removing debug point 'error_on_rows_query_event_apply' from @@GLOBAL.debug |
| 20 |
[connection master] |
| 21 |
DROP TABLE t1; |
| 22 |
SET SESSION binlog_rows_query_log_events = BINLOG_ROWS_QUERY_LOG_EVENTS; |
| 23 |
include/rpl_end.inc |