Debian Codegraph @

mysql-test/suite/galera/t/galera_schema.test

raw
1 --source include/galera_cluster.inc
2
3 CREATE TABLE IF NOT EXISTS wsrep_cluster
4 (
5 cluster_uuid CHAR(36) PRIMARY KEY,
6 view_id BIGINT NOT NULL,
7 view_seqno BIGINT NOT NULL,
8 protocol_version INT NOT NULL,
9 capabilities INT NOT NULL
10 ) ENGINE=InnoDB;
11
12 CREATE TABLE IF NOT EXISTS wsrep_cluster_members
13 (
14 node_uuid CHAR(36) PRIMARY KEY,
15 cluster_uuid CHAR(36) NOT NULL,
16 node_name CHAR(32) NOT NULL,
17 node_incoming_address VARCHAR(256) NOT NULL
18 ) ENGINE=InnoDB;
19
20 CREATE TABLE IF NOT EXISTS wsrep_cluster_members_history
21 (
22 node_uuid CHAR(36) PRIMARY KEY,
23 cluster_uuid CHAR(36) NOT NULL,
24 last_view_id BIGINT NOT NULL,
25 last_view_seqno BIGINT NOT NULL,
26 node_name CHAR(32) NOT NULL,
27 node_incoming_address VARCHAR(256) NOT NULL
28 ) ENGINE=InnoDB;
29
30 CREATE TABLE IF NOT EXISTS wsrep_streaming_log
31 (
32 node_uuid CHAR(36),
33 trx_id BIGINT,
34 seqno BIGINT,
35 flags INT NOT NULL,
36 frag LONGBLOB NOT NULL,
37 PRIMARY KEY (node_uuid, trx_id, seqno)
38 ) ENGINE=InnoDB;
39
40 DELETE FROM wsrep_cluster;
41 DELETE FROM wsrep_cluster_members;
42
43 ALTER TABLE wsrep_cluster STATS_PERSISTENT=0;
44 ALTER TABLE wsrep_cluster_members STATS_PERSISTENT=0;
45 ALTER TABLE wsrep_cluster_members_history STATS_PERSISTENT=0;
46 ALTER TABLE wsrep_streaming_log STATS_PERSISTENT=0;
47
48 SHOW CREATE TABLE wsrep_cluster;
49 SHOW CREATE TABLE wsrep_cluster_members;
50 SHOW CREATE TABLE wsrep_cluster_members_history;
51 SHOW CREATE TABLE wsrep_streaming_log;
52
53 SHOW CREATE TABLE mysql.wsrep_cluster;
54 SHOW CREATE TABLE mysql.wsrep_cluster_members;
55 #SHOW CREATE TABLE mysql.wsrep_cluster_members_history;
56 SHOW CREATE TABLE mysql.wsrep_streaming_log;
57
58 DROP TABLE wsrep_cluster;
59 DROP TABLE wsrep_cluster_members;
60 DROP TABLE wsrep_cluster_members_history;
61 DROP TABLE wsrep_streaming_log;