| 1 |
Backup restored |
| 2 |
Restart server 1 to trigger schema synchronization |
| 3 |
# restart |
| 4 |
SHOW TABLES; |
| 5 |
Tables_in_test |
| 6 |
t1 |
| 7 |
t2 |
| 8 |
t3 |
| 9 |
t4 |
| 10 |
t5 |
| 11 |
SHOW CREATE TABLE t1; |
| 12 |
Table Create Table |
| 13 |
t1 CREATE TABLE `t1` ( |
| 14 |
`a` int NOT NULL, |
| 15 |
`b` varchar(255) DEFAULT NULL, |
| 16 |
PRIMARY KEY (`a`) |
| 17 |
) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 18 |
SELECT * FROM t1; |
| 19 |
a b |
| 20 |
1 a |
| 21 |
2 bb |
| 22 |
3 ccc |
| 23 |
SHOW CREATE TABLE t2; |
| 24 |
Table Create Table |
| 25 |
t2 CREATE TABLE `t2` ( |
| 26 |
`c1` int NOT NULL AUTO_INCREMENT, |
| 27 |
`c2` int unsigned NOT NULL, |
| 28 |
`c3` float DEFAULT NULL, |
| 29 |
`c4` varchar(255) DEFAULT NULL, |
| 30 |
`c5` time DEFAULT NULL, |
| 31 |
`c6` date DEFAULT NULL, |
| 32 |
`c7` datetime DEFAULT NULL, |
| 33 |
`c8` blob, |
| 34 |
`c9` char(30) DEFAULT NULL, |
| 35 |
`c10` varbinary(255) DEFAULT NULL, |
| 36 |
PRIMARY KEY (`c1`), |
| 37 |
UNIQUE KEY `xc2` (`c2`) |
| 38 |
) ENGINE=ndbcluster AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 39 |
SELECT * FROM t2; |
| 40 |
c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 |
| 41 |
1 1 2.5 a 23:59:59 2018-01-30 2018-01-30 13:46:00 b c d |
| 42 |
SHOW CREATE TABLE t3; |
| 43 |
Table Create Table |
| 44 |
t3 CREATE TABLE `t3` ( |
| 45 |
`c1` int NOT NULL, |
| 46 |
`c2` int GENERATED ALWAYS AS ((`c1` * `c1`)) VIRTUAL, |
| 47 |
PRIMARY KEY (`c1`) |
| 48 |
) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 49 |
INSERT INTO t3(c1) VALUES(14); |
| 50 |
SELECT * FROM t3; |
| 51 |
c1 c2 |
| 52 |
14 196 |
| 53 |
2 4 |
| 54 |
SHOW CREATE TABLE t4; |
| 55 |
Table Create Table |
| 56 |
t4 CREATE TABLE `t4` ( |
| 57 |
`c1` int NOT NULL AUTO_INCREMENT, |
| 58 |
`c2` varchar(100) DEFAULT NULL, |
| 59 |
`c3` varchar(100) DEFAULT NULL, |
| 60 |
PRIMARY KEY (`c1`) |
| 61 |
) ENGINE=ndbcluster AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='NDB_TABLE=READ_BACKUP=0,PARTITION_BALANCE=FOR_RP_BY_NODE' |
| 62 |
SELECT * FROM t4; |
| 63 |
c1 c2 c3 |
| 64 |
1 a a |
| 65 |
SHOW CREATE TABLE t5; |
| 66 |
Table Create Table |
| 67 |
t5 CREATE TABLE `t5` ( |
| 68 |
`a` int NOT NULL, |
| 69 |
`b` varchar(255) DEFAULT NULL, |
| 70 |
PRIMARY KEY (`a`) |
| 71 |
) /*!50100 TABLESPACE `ts1` STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 72 |
SELECT * FROM t5; |
| 73 |
a b |
| 74 |
1 Lipstick on a pig |
| 75 |
SELECT |
| 76 |
RPAD(CONCAT(database_name, '.', table_name),30,' ') 'table', |
| 77 |
extra_metadata_version, |
| 78 |
LENGTH(extra_metadata) len, |
| 79 |
IF(extra_metadata_version = 'SDI', JSON_EXTRACT(CONVERT(extra_metadata USING utf8mb4), '$.mysqld_version_id'), NULL) mysqld_version_id, |
| 80 |
IF(extra_metadata_version = 'SDI', JSON_EXTRACT(CONVERT(extra_metadata USING utf8mb4), '$.dd_version'), NULL) dd_version, |
| 81 |
IF(extra_metadata_version = 'SDI', JSON_EXTRACT(CONVERT(extra_metadata USING utf8mb4), '$.sdi_version'), NULL) sdi_version |
| 82 |
FROM ndbinfo.dictionary_tables |
| 83 |
ORDER BY 1,2; |
| 84 |
table extra_metadata_version len mysqld_version_id dd_version sdi_version |
| 85 |
mysql.NDB$BLOB_#_# NULL NULL NULL NULL NULL |
| 86 |
mysql.ndb_apply_status FRM 8716 NULL NULL NULL |
| 87 |
mysql.ndb_index_stat_head NULL NULL NULL NULL NULL |
| 88 |
mysql.ndb_index_stat_sample NULL NULL NULL NULL NULL |
| 89 |
mysql.ndb_schema FRM 8810 NULL NULL NULL |
| 90 |
mysql.ndb_schema_result NULL NULL NULL NULL NULL |
| 91 |
mysql.ndb_sql_metadata NULL NULL NULL NULL NULL |
| 92 |
test.NDB$BLOB_#_# NULL NULL NULL NULL NULL |
| 93 |
test.t1 SDI 4726 80018 80017 80016 |
| 94 |
test.t2 SDI 11176 80018 80017 80016 |
| 95 |
test.t3 SDI 4747 80018 80017 80016 |
| 96 |
test.t4 SDI 5505 80018 80017 80016 |
| 97 |
test.t5 SDI 4781 80018 80017 80016 |
| 98 |
DROP TABLE t1, t2, t3, t4, t5; |
| 99 |
ALTER TABLESPACE ts1 |
| 100 |
DROP DATAFILE 'ts1_datafile.dat'; |
| 101 |
DROP TABLESPACE ts1; |
| 102 |
DROP LOGFILE GROUP lg1 |
| 103 |
ENGINE NDB; |