INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN'; CREATE PROCEDURE prepare_data(IN val INT) BEGIN DECLARE i INT DEFAULT 1; WHILE i <= val DO INSERT INTO t1 (b,c) VALUES (REPEAT(a,600), REPEAT(b,600)); INSERT INTO t2 (b,c) VALUES (REPEAT(a,600), REPEAT(b,600)); SET i = i + 1; END WHILE; END| # Case 1 - Normal page archiving process using clone client. CREATE TABLE t1 (a INT AUTO_INCREMENT, b LONGBLOB, c LONGBLOB, key k1(a)); CREATE TABLE t2 (a INT PRIMARY KEY AUTO_INCREMENT, b LONGBLOB, c LONGBLOB); SET DEBUG_SYNC = 'clone_file_copy SIGNAL page_signal WAIT_FOR go_page'; SET DEBUG_SYNC = 'clone_page_copy SIGNAL redo_signal WAIT_FOR go_redo'; SET DEBUG_SYNC = 'clone_donor_after_saving_dynamic_metadata SIGNAL meta_signal WAIT_FOR go_meta'; SET GLOBAL clone_autotune_concurrency = OFF; SET GLOBAL clone_max_concurrency = 8; CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR'; SET DEBUG_SYNC = 'now WAIT_FOR page_signal'; CALL prepare_data(50); SET DEBUG_SYNC = 'now SIGNAL go_page'; SET DEBUG_SYNC = 'now WAIT_FOR redo_signal'; CALL prepare_data(10); SET DEBUG_SYNC = 'now SIGNAL go_redo'; SET DEBUG_SYNC = 'now WAIT_FOR meta_signal'; SET GLOBAL debug="+d,periodical_checkpoint_disabled"; CALL prepare_data(10); UPDATE t1 SET a = 100 where a = 1; UPDATE t2 SET a = 200 where a = 1; SET DEBUG_SYNC = 'now SIGNAL go_meta'; select count(*) from t1; count(*) 70 select count(*) from t2; count(*) 70 # restart: --datadir=CLONE_DATADIR INSERT INTO t1 (b,c) VALUES (REPEAT(a,600), REPEAT(b,600)); INSERT INTO t2 (b,c) VALUES (REPEAT(a,600), REPEAT(b,600)); select count(*), max(a) from t1; count(*) max(a) 71 101 select count(*), max(a) from t2; count(*) max(a) 71 201 # restart: DROP TABLE t1; DROP TABLE t2; SET DEBUG_SYNC = 'RESET'; DROP PROCEDURE prepare_data; UNINSTALL PLUGIN clone;