CREATE TABLE t1 ( a int primary key ) ENGINE = NDB; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int NOT NULL, PRIMARY KEY (`a`) ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci RESET MASTER; # Drop mysql.ndb_schema from NDB Dropping table ndb_schema...OK # mysqld1: Wait until ready again... # mysqld2: Wait until ready again... # mysqld3: Wait until ready again... # mysqld4: Wait until ready again... # mysqld5: Wait until ready again... # mysqld6: Wait until ready again... # Check if a LOST_EVENTS event was written to the binlog include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info ALTER TABLE t1 ADD COLUMN b int not null; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int NOT NULL, `b` int NOT NULL, PRIMARY KEY (`a`) ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci DROP TABLE t1; CREATE TABLE t1 ( a int primary key ) ENGINE = NDB; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int NOT NULL, PRIMARY KEY (`a`) ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci RESET MASTER; # Drop mysql.ndb_apply_status from NDB Dropping table ndb_apply_status...OK # mysqld1: Wait until ready again... # mysqld2: Wait until ready again... # mysqld3: Wait until ready again... # mysqld4: Wait until ready again... # mysqld5: Wait until ready again... # mysqld6: Wait until ready again... # Check if a LOST_EVENTS event was written to the binlog include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info binlog.000001 # Incident # # #1 (LOST_EVENTS) binlog.000001 # Rotate # # binlog.000002;pos=POS ALTER TABLE t1 ADD COLUMN b int not null; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int NOT NULL, `b` int NOT NULL, PRIMARY KEY (`a`) ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci DROP TABLE t1; CREATE TABLE t1 ( a int primary key ) ENGINE = NDB; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int NOT NULL, PRIMARY KEY (`a`) ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci RESET MASTER; # Drop mysql.ndb_schema_result from NDB Dropping table ndb_schema_result...OK # mysqld1: Wait until ready again... # mysqld2: Wait until ready again... # mysqld3: Wait until ready again... # mysqld4: Wait until ready again... # mysqld5: Wait until ready again... # mysqld6: Wait until ready again... # Check if a LOST_EVENTS event was written to the binlog include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info ALTER TABLE t1 ADD COLUMN b int not null; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int NOT NULL, `b` int NOT NULL, PRIMARY KEY (`a`) ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci DROP TABLE t1;