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] call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT"); call mtr.add_suppression("Replica SQL for channel '': The incident LOST_EVENTS occurred on the source."); call mtr.add_suppression("Non-transactional changes were not written to the binlog. An incident event has been written to the binary log which will stop the replicas."); SET GLOBAL max_binlog_stmt_cache_size = 4096; Warnings: Warning 1745 Option binlog_stmt_cache_size (32768) is greater than max_binlog_stmt_cache_size (4096); setting binlog_stmt_cache_size equal to max_binlog_stmt_cache_size. SET GLOBAL binlog_stmt_cache_size = 4096; # Adding debug point 'simulate_write_trans_without_gtid' to @@GLOBAL.debug CREATE TABLE t1(c1 INT PRIMARY KEY, data TEXT(30000)) ENGINE=MyIsam; # # A single statement on non-transactional table causes to log an incident # event without a GTID due to the fact that the stmt_cache is not big # enough to accommodate the changes. # Got one of the listed errors include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Incident # # #1 (LOST_EVENTS) master-bin.000001 # Rotate # # master-bin.000002;pos=POS # # Verify that we can skip the incident event by setting # --replica-skip-errors=1590 on slave. # include/sync_slave_sql_with_master.inc [connection master] DROP TABLE t1; # Removing debug point 'simulate_write_trans_without_gtid' from @@GLOBAL.debug SET GLOBAL max_binlog_stmt_cache_size= ORIGINAL_VALUE; SET GLOBAL binlog_stmt_cache_size= ORIGINAL_VALUE; include/rpl_end.inc