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] SET SESSION DEBUG="+d,ndb_crash_on_drop_SUB_TABLE_DATA"; CREATE TABLE t ( pk01 BINARY(192) NOT NULL, pk02 BINARY(192) NOT NULL DEFAULT 0, pk03 BINARY(192) NOT NULL DEFAULT 0, pk04 BINARY(192) NOT NULL DEFAULT 0, pk05 BINARY(192) NOT NULL DEFAULT 0, pk06 BINARY(192) NOT NULL DEFAULT 0, pk07 BINARY(192) NOT NULL DEFAULT 0, pk08 BINARY(192) NOT NULL DEFAULT 0, pk09 BINARY(192) NOT NULL DEFAULT 0, pk10 BINARY(192) NOT NULL DEFAULT 0, pk11 BINARY(192) NOT NULL DEFAULT 0, pk12 BINARY(192) NOT NULL DEFAULT 0, pk13 BINARY(192) NOT NULL DEFAULT 0, pk14 BINARY(192) NOT NULL DEFAULT 0, pk15 BINARY(192) NOT NULL DEFAULT 0, pk16 BINARY(192) NOT NULL DEFAULT 0, data VARBINARY(26924) NOT NULL, PRIMARY KEY(pk01,pk02,pk03,pk04,pk05,pk06,pk07,pk08,pk09,pk10,pk11,pk12,pk13,pk14,pk15,pk16)) ENGINE ndb; Warnings: Warning 1296 Specified key 'PRIMARY' was too long (max = 3056 bytes); statistics will not be generated SHOW WARNINGS; Level Code Message Warning 1296 Specified key 'PRIMARY' was too long (max = 3056 bytes); statistics will not be generated INSERT INTO t (pk01, data) VALUES (REPEAT(' ', 192), REPEAT('.', 26924)); SELECT LENGTH(pk01), CRC32(pk01), LENGTH(data), CRC32(data) FROM t; LENGTH(pk01) CRC32(pk01) LENGTH(data) CRC32(data) 192 1459861267 26924 3689915749 UPDATE t SET data = repeat(':', 26924) where pk01 = REPEAT(' ', 192); SELECT LENGTH(pk01), CRC32(pk01), LENGTH(data), CRC32(data) FROM t; LENGTH(pk01) CRC32(pk01) LENGTH(data) CRC32(data) 192 1459861267 26924 491613150 ******* Select from Slave ************* SELECT LENGTH(pk01), CRC32(pk01), LENGTH(data), CRC32(data) FROM t; LENGTH(pk01) CRC32(pk01) LENGTH(data) CRC32(data) 192 1459861267 26924 491613150 DELETE FROM t where pk01 = REPEAT(' ', 192); SELECT LENGTH(pk01), CRC32(pk01), LENGTH(data), CRC32(data) FROM t; LENGTH(pk01) CRC32(pk01) LENGTH(data) CRC32(data) ******* Select from Slave ************* SELECT LENGTH(pk01), CRC32(pk01), LENGTH(data), CRC32(data) FROM t; LENGTH(pk01) CRC32(pk01) LENGTH(data) CRC32(data) SET SESSION DEBUG="-d,ndb_crash_on_drop_SUB_TABLE_DATA"; DROP TABLE t; CREATE TABLE t ( pk01 CHAR(255) NOT NULL, pk02 CHAR(255) NOT NULL, pk03 CHAR(255) NOT NULL, data VARBINARY(26924) NOT NULL, PRIMARY KEY(pk01,pk02,pk03) ) ENGINE ndb; Warnings: Warning 1296 Specified key 'PRIMARY' was too long (max = 3056 bytes); statistics will not be generated INSERT INTO t (pk01, pk02, pk03, data) VALUES ("xyz", "xyz", "xyz", REPEAT('.', 26924)); SELECT pk01, LENGTH(data), CRC32(data) FROM t; pk01 LENGTH(data) CRC32(data) xyz 26924 3689915749 Update PK's to an 'equal' 'XYZ' value which is now included in BEFORE values UPDATE t SET pk01 = "XYZ", pk02 = "XYZ", pk03 = "XYZ", data = repeat(':', 26924) where pk01 = "xyz"; SELECT pk01, LENGTH(data), CRC32(data) FROM t; pk01 LENGTH(data) CRC32(data) XYZ 26924 491613150 ******* Select from Slave ************* SELECT pk01, LENGTH(data), CRC32(data) FROM t; pk01 LENGTH(data) CRC32(data) XYZ 26924 491613150 Update PK's to non-equal 'XXX' values -> Update as delete+insert All PK values is included in BEFORE values UPDATE t SET pk01 = "XXX", pk02 = "XXX", pk03 = "XXX", data = repeat(':', 26924) where pk01 = "xyz"; SELECT pk01, LENGTH(data), CRC32(data) FROM t; pk01 LENGTH(data) CRC32(data) XXX 26924 491613150 ******* Select from Slave ************* SELECT pk01, LENGTH(data), CRC32(data) FROM t; pk01 LENGTH(data) CRC32(data) XXX 26924 491613150 DELETE FROM t; SELECT pk01, LENGTH(data), CRC32(data) FROM t; pk01 LENGTH(data) CRC32(data) ******* Select from Slave ************* SELECT pk01, LENGTH(data), CRC32(data) FROM t; pk01 LENGTH(data) CRC32(data) DROP TABLE t; include/rpl_end.inc