mirror of
https://github.com/MariaDB/server.git
synced 2026-01-24 20:34:52 +01:00
92 lines
2.4 KiB
Text
92 lines
2.4 KiB
Text
# Test clone with insert
|
|
|
|
--source include/have_innodb.inc
|
|
--source include/have_debug.inc
|
|
--source include/have_debug_sync.inc
|
|
--source include/count_sessions.inc
|
|
|
|
connect (con1,localhost,root,,);
|
|
connect (con2,localhost,root,,);
|
|
connect (con3,localhost,root,,);
|
|
|
|
--let $CLONE_DATADIR = $MYSQL_TMP_DIR/data_new
|
|
--let $MYSQLD_DATADIR = `SELECT @@datadir`
|
|
|
|
--replace_result $MARIADB_CLONE_SO CLONE_PLUGIN
|
|
--eval INSTALL PLUGIN clone SONAME '$MARIADB_CLONE_SO'
|
|
|
|
DELIMITER |;
|
|
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|
|
|
DELIMITER ;|
|
|
|
|
--echo # Case 1 - Normal page archiving process using clone client.
|
|
|
|
CREATE TABLE t1 (a INT AUTO_INCREMENT, b LONGBLOB, c LONGBLOB, key k1(a))ENGINE=InnoDB;
|
|
CREATE TABLE t2 (a INT PRIMARY KEY AUTO_INCREMENT, b LONGBLOB, c LONGBLOB)ENGINE=InnoDB;
|
|
|
|
--connection con1
|
|
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';
|
|
--replace_result $CLONE_DATADIR CLONE_DATADIR
|
|
--send_eval CLONE LOCAL DATA DIRECTORY = '$CLONE_DATADIR'
|
|
|
|
--connection con2
|
|
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';
|
|
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';
|
|
|
|
--connection con1
|
|
--reap
|
|
|
|
select count(*), max(a) from t1;
|
|
select count(*), max(a) from t2;
|
|
|
|
--echo # Restart server on cloned data directory
|
|
--let restart_noprint=1
|
|
--let restart_parameters=--datadir=$CLONE_DATADIR
|
|
--source include/restart_mysqld.inc
|
|
|
|
select count(*), max(a) from t1;
|
|
select count(*), max(a) from t2;
|
|
|
|
INSERT INTO t1 (b,c) VALUES (REPEAT(a,600), REPEAT(b,600));
|
|
INSERT INTO t2 (b,c) VALUES (REPEAT(a,600), REPEAT(b,600));
|
|
|
|
#Cleanup
|
|
--let restart_parameters=
|
|
--source include/restart_mysqld.inc
|
|
|
|
--connection con1
|
|
DROP TABLE t1;
|
|
DROP TABLE t2;
|
|
|
|
SET DEBUG_SYNC = 'RESET';
|
|
|
|
--rmdir $CLONE_DATADIR
|
|
|
|
DROP PROCEDURE prepare_data;
|
|
|
|
UNINSTALL PLUGIN clone;
|
|
|
|
--disconnect con1
|
|
--disconnect con2
|
|
--disconnect con3
|