Debian Codegraph @

mysql-test/suite/innodb/t/portability_basic.test

raw
1 # ***************************************************
2 # wl#8619: Test the basic functionality of portability
3 # Test by moving --datadir location to new location
4 # start the server with only by providing the --datadir
5 # Here in this case no need to pass the option
6 # --innodb-directories
7 # ****************************************************
8 --source include/have_innodb_max_16k.inc
9 --source include/have_innodb_default_undo_tablespaces.inc
10
11 let $MYSQLD_OLD_DATADIR = `select @@datadir`;
12
13 # Create new datadir folders like data
14 --mkdir $MYSQL_TMP_DIR/new_datadir
15 --mkdir $MYSQL_TMP_DIR/new_datadir/data
16 let $MYSQLD_NEW_DATADIR = $MYSQL_TMP_DIR/new_datadir/data;
17 --mkdir $MYSQLD_NEW_DATADIR/#innodb_redo
18 --mkdir $MYSQLD_NEW_DATADIR/test
19 --mkdir $MYSQLD_NEW_DATADIR/mysql
20 --mkdir $MYSQLD_NEW_DATADIR/sys
21 --mkdir $MYSQLD_NEW_DATADIR/performance_schema
22 --mkdir $MYSQLD_NEW_DATADIR/mtr
23
24 --echo ## create tables and tablespaces without absolute paths
25 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' Engine=InnoDB;
26
27 CREATE TABLE tab1(c1 int, c2 varchar(10)) TABLESPACE=ts1;
28
29 INSERT INTO tab1 VALUES(1, 'VISH');
30
31 CREATE TABLE tab2(c1 int, c2 varchar(10)) Engine=InnoDB;
32
33 INSERT INTO tab2 VALUES(2, 'VISH');
34
35 CREATE INDEX ix1 ON tab1(c2) USING BTREE;
36
37 CREATE INDEX ix1 ON tab2(c2) ;
38
39 # Create new undo tablespaces
40 CREATE UNDO TABLESPACE undo_003 ADD DATAFILE 'undo_003.ibu';
41 CREATE UNDO TABLESPACE undo_004 ADD DATAFILE 'undo_004.ibu';
42
43 # Check from metadata info
44 SELECT file_name,file_type,tablespace_name FROM
45 INFORMATION_SCHEMA.FILES
46 WHERE FILE_TYPE LIKE '%undo%';
47
48 --echo ## Stop DB server
49 --source include/shutdown_mysqld.inc
50
51 --echo # Copy whole --datadir files into new location
52 --copy_file $MYSQLD_OLD_DATADIR/auto.cnf $MYSQLD_NEW_DATADIR/auto.cnf
53 --copy_file $MYSQLD_OLD_DATADIR/ib_buffer_pool $MYSQLD_NEW_DATADIR/ib_buffer_pool
54 --copy_file $MYSQLD_OLD_DATADIR/ibdata1 $MYSQLD_NEW_DATADIR/ibdata1
55 --copy_files_wildcard $MYSQLD_OLD_DATADIR $MYSQLD_NEW_DATADIR *.ibd
56 --copy_files_wildcard $MYSQLD_OLD_DATADIR $MYSQLD_NEW_DATADIR undo*
57 --copy_files_wildcard $MYSQLD_OLD_DATADIR/#innodb_redo/ $MYSQLD_NEW_DATADIR/#innodb_redo #ib_redo*
58
59 --copy_files_wildcard $MYSQLD_OLD_DATADIR/test/ $MYSQLD_NEW_DATADIR/test/ *.*
60 --copy_files_wildcard $MYSQLD_OLD_DATADIR/sys/ $MYSQLD_NEW_DATADIR/sys/ *.*
61 --copy_files_wildcard $MYSQLD_OLD_DATADIR/performance_schema/ $MYSQLD_NEW_DATADIR/performance_schema/ *.*
62 --copy_files_wildcard $MYSQLD_OLD_DATADIR/mysql/ $MYSQLD_NEW_DATADIR/mysql/ *.*
63 --copy_files_wildcard $MYSQLD_OLD_DATADIR/mtr/ $MYSQLD_NEW_DATADIR/mtr/ *.*
64
65 --echo ## Start with new --datadir
66 --let $restart_parameters="restart: --datadir=$MYSQLD_NEW_DATADIR"
67 --source include/start_mysqld_no_echo.inc
68
69 --echo ## Check datadir started with new one
70 --replace_result $MYSQLD_NEW_DATADIR NEW_DATADIR
71 SELECT @@datadir;
72
73 --echo ## Check with SHOW
74 SHOW CREATE TABLE tab1;
75
76 SHOW CREATE TABLE tab2;
77
78 --echo ## Check with DML and DDL
79 SELECT * FROM tab1;
80
81 SELECT * FROM tab2;
82
83 ALTER UNDO TABLESPACE innodb_undo_001 SET INACTIVE;
84 let $inactive_undo_space = innodb_undo_001;
85 source include/wait_until_undo_space_is_empty.inc;
86
87 ALTER UNDO TABLESPACE innodb_undo_002 SET INACTIVE;
88 let $inactive_undo_space = innodb_undo_002;
89 source include/wait_until_undo_space_is_empty.inc;
90
91 SELECT name,space_type,state
92 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
93 WHERE space_type = 'Undo';
94
95 DELETE FROM tab1;
96
97 DELETE FROM tab2;
98
99 ALTER TABLE tab1 add column c3 varchar(10);
100
101 INSERT INTO tab1 VALUES(1, 'VISH','NATH');
102
103 INSERT INTO tab2 VALUES(2, 'VISH');
104
105 SELECT * FROM tab1;
106
107 SELECT * FROM tab2;
108
109 SELECT name,space_type,state
110 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
111 WHERE space_type = 'Undo';
112
113 ALTER UNDO TABLESPACE innodb_undo_001 SET ACTIVE;
114 ALTER UNDO TABLESPACE innodb_undo_002 SET ACTIVE;
115
116 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
117 let $inactive_undo_space = undo_003;
118 source include/wait_until_undo_space_is_empty.inc;
119
120 ALTER UNDO TABLESPACE undo_004 SET INACTIVE;
121 let $inactive_undo_space = undo_004;
122 source include/wait_until_undo_space_is_empty.inc;
123
124 SELECT name,space_type,state
125 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
126 WHERE space_type = 'Undo';
127
128 --echo # Clean up new datadir
129 DROP TABLE tab1;
130 DROP TABLE tab2;
131 DROP TABLESPACE ts1;
132 DROP UNDO TABLESPACE undo_003;
133 DROP UNDO TABLESPACE undo_004;
134
135 --echo # Stop DB server with new datadir
136 --source include/shutdown_mysqld.inc
137
138 # Clean up new datadir while server is OFF
139 --force-rmdir $MYSQL_TMP_DIR/new_datadir
140
141 --echo # Re-start with old --datadir
142 --replace_result $MYSQLD_OLD_DATADIR OLD_DATADIR
143 --let $restart_parameters="restart: --datadir=$MYSQLD_OLD_DATADIR"
144 --source include/start_mysqld.inc
145
146 --echo # Check --datadir started with old
147 --replace_result $MYSQLD_OLD_DATADIR OLD_DATADIR
148 SELECT @@datadir;
149
150 # Clean up old datadir
151 DROP TABLE tab1;
152 DROP TABLE tab2;
153 DROP TABLESPACE ts1;
154 SELECT name,space_type,state
155 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
156 WHERE space_type = 'Undo';
157
158 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
159 let $inactive_undo_space = undo_003;
160 source include/wait_until_undo_space_is_empty.inc;
161
162 ALTER UNDO TABLESPACE undo_004 SET INACTIVE;
163 let $inactive_undo_space = undo_004;
164 source include/wait_until_undo_space_is_empty.inc;
165
166 SELECT name,space_type,state
167 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
168 WHERE space_type = 'Undo';
169 DROP UNDO TABLESPACE undo_003;
170 DROP UNDO TABLESPACE undo_004;
171