1--source include/galera_cluster.inc 2--source include/have_innodb.inc 3 4CREATE TABLE parent ( 5 id INT NOT NULL, 6 PRIMARY KEY (id) 7) ENGINE=InnoDB; 8 9CREATE TABLE child ( 10 id INT, 11 parent_id INT, 12 FOREIGN KEY (parent_id) 13 REFERENCES parent(id) 14 ON UPDATE SET NULL 15 ON DELETE SET NULL 16) ENGINE=InnoDB; 17 18INSERT INTO parent VALUES (1),(2); 19INSERT INTO child VALUES (1,1),(2,2); 20 21--connection node_2 22DELETE FROM parent WHERE id = 1; 23SELECT parent_id IS NULL FROM child WHERE id = 1; 24 25--connection node_1 26SELECT parent_id IS NULL FROM child WHERE id = 1; 27 28UPDATE parent SET id = 3 WHERE id = 2; 29SELECT parent_id IS NULL FROM child WHERE id = 2; 30 31--connection node_2 32SELECT parent_id IS NULL FROM child WHERE id = 2; 33 34--connection node_1 35DROP TABLE child; 36DROP TABLE parent; 37