Debian Codegraph @

mysql-test/suite/clone/r/remote_insert.result

raw
1 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
2 CREATE PROCEDURE prepare_data(IN val INT)
3 BEGIN
4 DECLARE i INT DEFAULT 1;
5 WHILE i <= val DO
6 INSERT INTO t1 (b,c) VALUES (REPEAT(a,600), REPEAT(b,600));
7 INSERT INTO t2 (b,c) VALUES (REPEAT(a,600), REPEAT(b,600));
8 SET i = i + 1;
9 END WHILE;
10 END|
11 # Case 1 - Normal page archiving process using clone client.
12 CREATE TABLE t1 (a INT AUTO_INCREMENT, b LONGBLOB, c LONGBLOB, key k1(a));
13 CREATE TABLE t2 (a INT PRIMARY KEY AUTO_INCREMENT, b LONGBLOB, c LONGBLOB);
14 SET DEBUG_SYNC = 'clone_file_copy SIGNAL page_signal WAIT_FOR go_page';
15 SET DEBUG_SYNC = 'clone_page_copy SIGNAL redo_signal WAIT_FOR go_redo';
16 SET GLOBAL clone_autotune_concurrency = OFF;
17 SET GLOBAL clone_max_concurrency = 8;
18 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
19 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
20 SET DEBUG_SYNC = 'now WAIT_FOR page_signal';
21 CALL prepare_data(50);
22 SET DEBUG_SYNC = 'now SIGNAL go_page';
23 SET DEBUG_SYNC = 'now WAIT_FOR redo_signal';
24 CALL prepare_data(10);
25 SET DEBUG_SYNC = 'now SIGNAL go_redo';
26 select count(*) from t1;
27 count(*)
28 60
29 select count(*) from t2;
30 count(*)
31 60
32 # restart: --datadir=CLONE_DATADIR
33 INSERT INTO t1 (b,c) VALUES (REPEAT(a,600), REPEAT(b,600));
34 INSERT INTO t2 (b,c) VALUES (REPEAT(a,600), REPEAT(b,600));
35 select count(*), max(a) from t1;
36 count(*) max(a)
37 61 61
38 select count(*), max(a) from t2;
39 count(*) max(a)
40 61 61
41 # restart:
42 DROP TABLE t1;
43 DROP TABLE t2;
44 SET DEBUG_SYNC = 'RESET';
45 DROP PROCEDURE prepare_data;
46 UNINSTALL PLUGIN clone;