1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
CREATE SCHEMA A REPLICATE = TRUE;
SHOW CREATE SCHEMA A;
Database Create Database
A CREATE DATABASE `A` COLLATE = utf8_general_ci
USE A;
CREATE TABLE A (A SERIAL);
SHOW CREATE TABLE A;
Table Create Table
A CREATE TABLE `A` (
`A` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
UNIQUE KEY `A` (`A`) USING BTREE
) ENGINE=InnoDB COLLATE = utf8_general_ci
CREATE TABLE B (A SERIAL) REPLICATE = FALSE;
SHOW CREATE TABLE B;
Table Create Table
B CREATE TABLE `B` (
`A` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
UNIQUE KEY `A` (`A`) USING BTREE
) ENGINE=InnoDB COLLATE = utf8_general_ci REPLICATE = FALSE
SELECT SCHEMA_NAME, IS_REPLICATED FROM DATA_DICTIONARY.SCHEMAS WHERE SCHEMA_NAME="A";
SCHEMA_NAME IS_REPLICATED
A YES
SELECT TABLE_NAME, IS_REPLICATED FROM DATA_DICTIONARY.TABLES WHERE TABLE_SCHEMA="A";
TABLE_NAME IS_REPLICATED
A YES
B NO
DROP SCHEMA A;
CREATE SCHEMA A REPLICATE = FALSE;
SHOW CREATE SCHEMA A;
Database Create Database
A CREATE DATABASE `A` COLLATE = utf8_general_ci REPLICATE = FALSE
USE A;
CREATE TABLE A (A SERIAL);
SHOW CREATE TABLE A;
Table Create Table
A CREATE TABLE `A` (
`A` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
UNIQUE KEY `A` (`A`) USING BTREE
) ENGINE=InnoDB COLLATE = utf8_general_ci REPLICATE = FALSE
CREATE TABLE B (A SERIAL) REPLICATE = TRUE;
SHOW CREATE TABLE B;
Table Create Table
B CREATE TABLE `B` (
`A` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
UNIQUE KEY `A` (`A`) USING BTREE
) ENGINE=InnoDB COLLATE = utf8_general_ci REPLICATE = FALSE
SELECT SCHEMA_NAME, IS_REPLICATED FROM DATA_DICTIONARY.SCHEMAS WHERE SCHEMA_NAME="A";
SCHEMA_NAME IS_REPLICATED
A NO
SELECT TABLE_NAME, IS_REPLICATED FROM DATA_DICTIONARY.TABLES WHERE TABLE_SCHEMA="A";
TABLE_NAME IS_REPLICATED
A NO
B NO
DROP SCHEMA A;
|