Debian Codegraph @

mysql-test/suite/innodb/r/create_tablespace_replication.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 # connection master
7 USE test;
8 DROP TABLE IF EXISTS t1;
9 CREATE TABLESPACE s_1 ADD DATAFILE 's_1.ibd' ENGINE InnoDB;
10 CREATE TABLESPACE s_2 ADD DATAFILE 's_2.ibd' ENGINE InnoDB;
11 CREATE TABLE t1 (a int) ENGINE=innodb TABLESPACE=s_1;
12 CREATE TABLE t2 (a int) ENGINE=innodb TABLESPACE=s_1;
13 # Check tablespace on master
14 === information_schema.innodb_tables and innodb_tablespaces ===
15 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
16 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
17 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
18 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
19 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
20 test/t1 s_1 161 4 Dynamic 0 General
21 test/t2 s_1 161 4 Dynamic 0 General
22 INSERT INTO t1 VALUES ( 11);
23 INSERT INTO t2 VALUES ( 22);
24 SELECT * FROM t1;
25 a
26 11
27 SELECT * FROM t2;
28 a
29 22
30 include/sync_slave_sql_with_master.inc
31 # connection slave
32 # Check tablespace on slave
33 === information_schema.innodb_tables and innodb_tablespaces ===
34 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
35 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
36 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
37 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
38 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
39 test/t1 s_1 161 4 Dynamic 0 General
40 test/t2 s_1 161 4 Dynamic 0 General
41 USE test;
42 SHOW TABLES;
43 Tables_in_test
44 t1
45 t2
46 SHOW CREATE TABLE t1;
47 Table Create Table
48 t1 CREATE TABLE `t1` (
49 `a` int DEFAULT NULL
50 ) /*!50100 TABLESPACE `s_1` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
51 SHOW CREATE TABLE t2;
52 Table Create Table
53 t2 CREATE TABLE `t2` (
54 `a` int DEFAULT NULL
55 ) /*!50100 TABLESPACE `s_1` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
56 # connection master
57 USE test;
58 DROP TABLE t1,t2;
59 DROP TABLESPACE s_1;
60 include/sync_slave_sql_with_master.inc
61 # connection slave
62 === information_schema.innodb_tables and innodb_tablespaces ===
63 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
64 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
65 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
66 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
67 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
68 # connection master
69 USE test;
70 DROP TABLESPACE s_2;
71 include/rpl_end.inc