# Test clone command --source include/not_asan_mac.inc --source include/have_example_plugin.inc --source include/have_log_bin.inc --source ../include/clone_connection_begin.inc --let $CLONE_DATADIR = $MYSQL_TMP_DIR/data_new --disable_query_log call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* Non innodb table: .* is not cloned and is empty."); call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* Clone removing all user data for provisioning: .*"); --enable_query_log CREATE TABLE t1(col1 INT PRIMARY KEY, col2 char(64), FULLTEXT KEY fts_index(col2)); INSERT INTO t1 VALUES(10, 'clone row 1'); INSERT INTO t1 VALUES(20, 'clone row 2'); INSERT INTO t1 VALUES(30, 'clone row 3'); SELECT * from t1 ORDER BY col1; SELECT count(*) FROM mysql.general_log; SELECT count(*) FROM mysql.slow_log; # Create MyIsam and CSV tables in common schema CREATE TABLE t_myisam(col1 INT PRIMARY KEY, col2 char(64)) ENGINE=MyISAM; INSERT INTO t_myisam VALUES(10, 'myisam not cloned row 1'); SELECT * from t_myisam ORDER BY col1; CREATE TABLE t_csv(col1 INT NOT NULL, col2 char(64) NOT NULL) ENGINE=CSV; INSERT INTO t_csv VALUES(10, 'csv not cloned row 1'); SELECT * from t_csv ORDER BY col1; # Create MyIsam and CSV tables in separate schema CREATE SCHEMA non_innodb; CREATE TABLE non_innodb.t_myisam(col1 INT PRIMARY KEY, col2 char(64)) ENGINE=MyISAM; INSERT INTO non_innodb.t_myisam VALUES(10, 'myisam not cloned row 1'); INSERT INTO non_innodb.t_myisam VALUES(20, 'myisam not cloned row 2'); INSERT INTO non_innodb.t_myisam VALUES(30, 'myisam not cloned row 3'); SELECT * from non_innodb.t_myisam ORDER BY col1; CREATE TABLE non_innodb.t_csv(col1 INT NOT NULL, col2 char(64) NOT NULL) ENGINE=CSV; INSERT INTO non_innodb.t_csv VALUES(10, 'csv not cloned row 1'); INSERT INTO non_innodb.t_csv VALUES(20, 'csv not cloned row 2'); INSERT INTO non_innodb.t_csv VALUES(30, 'csv not cloned row 3'); SELECT * from non_innodb.t_csv ORDER BY col1; # Create MyIsam, CSV and InnoDB tables in separate schema, set it to read only CREATE SCHEMA schema_read_only; CREATE TABLE schema_read_only.t_myisam(col1 INT PRIMARY KEY, col2 char(64)) ENGINE=MyISAM; INSERT INTO schema_read_only.t_myisam VALUES(10, 'myisam not cloned row 1'); INSERT INTO schema_read_only.t_myisam VALUES(20, 'myisam not cloned row 2'); INSERT INTO schema_read_only.t_myisam VALUES(30, 'myisam not cloned row 3'); SELECT * from schema_read_only.t_myisam ORDER BY col1; CREATE TABLE schema_read_only.t_csv(col1 INT NOT NULL, col2 char(64) NOT NULL) ENGINE=CSV; INSERT INTO schema_read_only.t_csv VALUES(10, 'csv not cloned row 1'); INSERT INTO schema_read_only.t_csv VALUES(20, 'csv not cloned row 2'); INSERT INTO schema_read_only.t_csv VALUES(30, 'csv not cloned row 3'); SELECT * from schema_read_only.t_csv ORDER BY col1; CREATE TABLE schema_read_only.t_innodb(col1 INT PRIMARY KEY, col2 char(64)) ENGINE=InnoDB; INSERT INTO schema_read_only.t_innodb VALUES(10, 'innodb cloned row 1'); INSERT INTO schema_read_only.t_innodb VALUES(20, 'innodb cloned row 2'); INSERT INTO schema_read_only.t_innodb VALUES(30, 'innodb cloned row 3'); SELECT * from schema_read_only.t_innodb ORDER BY col1; ALTER SCHEMA schema_read_only READ ONLY=1; --echo #BEGIN Bug 32199611: CLONE PLUGIN INSTALLATION FAILS IN PFS TABLE CREATION # We would need to remove it once this deprecated variable is removed. Currently # it is required for clone to work with this variable as some users are using it. SET LOCAL explicit_defaults_for_timestamp = OFF; SHOW VARIABLES LIKE 'explicit_defaults_for_timestamp'; --replace_result $CLONE_PLUGIN CLONE_PLUGIN --eval INSTALL PLUGIN clone SONAME '$CLONE_PLUGIN' UNINSTALL PLUGIN clone; SET LOCAL explicit_defaults_for_timestamp = default; --echo #End Bug 32199611: CLONE PLUGIN INSTALLATION FAILS IN PFS TABLE CREATION # Install Clone Plugin --replace_result $CLONE_PLUGIN CLONE_PLUGIN --eval INSTALL PLUGIN clone SONAME '$CLONE_PLUGIN' # Install optional dynamic example plugin --replace_result $EXAMPLE_PLUGIN EXAMPLE_PLUGIN --eval INSTALL PLUGIN example SONAME '$EXAMPLE_PLUGIN' SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE '%clone%'; if ($skip_space_validation) { # Bug#32354908 CLONE DONOR'S INNODB_VALIDATE_TABLESPACE_PATHS=OFF LEADS ER_TABLESPACE_MISSING # Restart DB with tablespace validation skipped. --source ../include/clone_connection_end.inc --let restart_parameters="restart: --skip-innodb-validate-tablespace-paths" --source include/restart_mysqld.inc --source ../include/clone_connection_begin.inc } # Clone data --connection clone_conn_1 --source ../include/clone_command.inc if (!$clone_remote_replace) { --connection default # Restart server on cloned data directory --replace_result $CLONE_DATADIR CLONE_DATADIR --let restart_parameters="restart: --datadir=$CLONE_DATADIR" --source include/restart_mysqld.inc } # Validate data SELECT * from t1 ORDER BY col1; INSERT INTO t1 VALUES(40, 'clone row 4'); SELECT * from t1 ORDER BY col1; # Check MyISAM and CSV table data INSERT INTO t_myisam VALUES(40, 'myisam not cloned row 4'); SELECT * from t_myisam ORDER BY col1; INSERT INTO t_csv VALUES(40, 'csv not cloned row 4'); SELECT * from t_csv ORDER BY col1; INSERT INTO non_innodb.t_myisam VALUES(40, 'myisam not cloned row 4'); SELECT * from non_innodb.t_myisam ORDER BY col1; INSERT INTO non_innodb.t_csv VALUES(40, 'csv not cloned row 4'); SELECT * from non_innodb.t_csv ORDER BY col1; # Check tables in read only schema --error ER_SCHEMA_READ_ONLY INSERT INTO schema_read_only.t_myisam VALUES(40, 'myisam not cloned row 4'); SELECT * from schema_read_only.t_myisam ORDER BY col1; --error ER_SCHEMA_READ_ONLY INSERT INTO schema_read_only.t_csv VALUES(40, 'csv not cloned row 4'); SELECT * from schema_read_only.t_csv ORDER BY col1; --error ER_SCHEMA_READ_ONLY INSERT INTO schema_read_only.t_innodb VALUES(40, 'innodb cloned row 4'); SELECT * from schema_read_only.t_innodb ORDER BY col1; SHOW CREATE SCHEMA schema_read_only; # Validate query log tables; SELECT count(*) FROM mysql.general_log; SELECT count(*) FROM mysql.slow_log; SET GLOBAL general_log = ON; SET GLOBAL slow_query_log = ON; #Cleanup if (!$clone_remote_replace) { --let restart_parameters="restart:" --source include/restart_mysqld.inc } --connection default SELECT * from t1 ORDER BY col1; DROP TABLE t1; DROP TABLE t_myisam; DROP TABLE t_csv; DROP TABLE non_innodb.t_myisam; DROP TABLE non_innodb.t_csv; DROP SCHEMA non_innodb; ALTER SCHEMA schema_read_only READ ONLY=0; DROP SCHEMA schema_read_only; if (!$clone_remote_replace) { --force-rmdir $CLONE_DATADIR } UNINSTALL PLUGIN example; # Clean recipient by cloning the cleaned up donor if ($clone_remote_replace) { --connection clone_conn_1 --let $clone_err = ER_SCHEMA_READ_ONLY --source ../include/clone_command.inc --let $clone_err = 0 ALTER SCHEMA schema_read_only READ ONLY=0; --source ../include/clone_command.inc } --source ../include/clone_connection_end.inc UNINSTALL PLUGIN clone; --echo # --echo # BUG#34828542: P_S.clone_status.gtid_executed does not have enough --echo # column size --echo # --echo # Install Plugin --replace_result $CLONE_PLUGIN CLONE_PLUGIN --eval INSTALL PLUGIN clone SONAME '$CLONE_PLUGIN' --echo # Test case set up. SET @gtid_next_saved = @@SESSION.GTID_NEXT; SET @gtid_mode_saved = @@GLOBAL.GTID_MODE; SET @enforce_gtid_consistency_saved = @@GLOBAL.ENFORCE_GTID_CONSISTENCY; SET @@GLOBAL.ENFORCE_GTID_CONSISTENCY=ON; SET @@GLOBAL.GTID_MODE=OFF_PERMISSIVE; SET @@GLOBAL.GTID_MODE=ON_PERMISSIVE; SET @@GLOBAL.GTID_MODE=ON; delimiter //; CREATE PROCEDURE p1() BEGIN DECLARE x INT DEFAULT 0; WHILE x <= 2000 DO SET gtid_next=CONCAT(UUID(),':',4000); COMMIT; SET x = x + 1; END WHILE; END// DELIMITER ;// CALL p1(); --echo # Restore GTID settings. SET @@SESSION.GTID_NEXT= @gtid_next_saved; SET @@GLOBAL.GTID_MODE=ON_PERMISSIVE; SET @@GLOBAL.GTID_MODE=OFF_PERMISSIVE; SET @@GLOBAL.GTID_MODE= @gtid_mode_saved; SET @@GLOBAL.ENFORCE_GTID_CONSISTENCY=@enforce_gtid_consistency_saved; --echo # Clone database. --source ../include/clone_command_send.inc --reap --echo # Restart cloned database --replace_result $CLONE_DATADIR CLONE_DATADIR --let restart_parameters="restart: --datadir=$CLONE_DATADIR" --source include/restart_mysqld.inc --echo # Check the length of gtid_executed > 4096 after bug fix. SELECT length(gtid_executed) from performance_schema.clone_status; #Cleanup --let restart_parameters="restart:" --source include/restart_mysqld.inc DROP PROCEDURE p1; RESET MASTER; UNINSTALL PLUGIN clone; --force-rmdir $CLONE_DATADIR