1connection node_2;
2connection node_1;
3CREATE TABLE IF NOT EXISTS wsrep_cluster
4(
5cluster_uuid CHAR(36) PRIMARY KEY,
6view_id BIGINT NOT NULL,
7view_seqno BIGINT NOT NULL,
8protocol_version INT NOT NULL,
9capabilities INT NOT NULL
10) ENGINE=InnoDB;
11CREATE TABLE IF NOT EXISTS wsrep_cluster_members
12(
13node_uuid CHAR(36) PRIMARY KEY,
14cluster_uuid CHAR(36) NOT NULL,
15node_name CHAR(32) NOT NULL,
16node_incoming_address VARCHAR(256) NOT NULL
17) ENGINE=InnoDB;
18CREATE TABLE IF NOT EXISTS wsrep_cluster_members_history
19(
20node_uuid CHAR(36) PRIMARY KEY,
21cluster_uuid CHAR(36) NOT NULL,
22last_view_id BIGINT NOT NULL,
23last_view_seqno BIGINT NOT NULL,
24node_name CHAR(32) NOT NULL,
25node_incoming_address VARCHAR(256) NOT NULL
26) ENGINE=InnoDB;
27CREATE TABLE IF NOT EXISTS wsrep_streaming_log
28(
29node_uuid CHAR(36),
30trx_id BIGINT,
31seqno BIGINT,
32flags INT NOT NULL,
33frag LONGBLOB NOT NULL,
34PRIMARY KEY (node_uuid, trx_id, seqno)
35) ENGINE=InnoDB;
36DELETE FROM wsrep_cluster;
37DELETE FROM wsrep_cluster_members;
38ALTER TABLE wsrep_cluster STATS_PERSISTENT=0;
39ALTER TABLE wsrep_cluster_members STATS_PERSISTENT=0;
40ALTER TABLE wsrep_cluster_members_history STATS_PERSISTENT=0;
41ALTER TABLE wsrep_streaming_log STATS_PERSISTENT=0;
42SHOW CREATE TABLE wsrep_cluster;
43Table	Create Table
44wsrep_cluster	CREATE TABLE `wsrep_cluster` (
45  `cluster_uuid` char(36) NOT NULL,
46  `view_id` bigint(20) NOT NULL,
47  `view_seqno` bigint(20) NOT NULL,
48  `protocol_version` int(11) NOT NULL,
49  `capabilities` int(11) NOT NULL,
50  PRIMARY KEY (`cluster_uuid`)
51) ENGINE=InnoDB DEFAULT CHARSET=latin1 STATS_PERSISTENT=0
52SHOW CREATE TABLE wsrep_cluster_members;
53Table	Create Table
54wsrep_cluster_members	CREATE TABLE `wsrep_cluster_members` (
55  `node_uuid` char(36) NOT NULL,
56  `cluster_uuid` char(36) NOT NULL,
57  `node_name` char(32) NOT NULL,
58  `node_incoming_address` varchar(256) NOT NULL,
59  PRIMARY KEY (`node_uuid`)
60) ENGINE=InnoDB DEFAULT CHARSET=latin1 STATS_PERSISTENT=0
61SHOW CREATE TABLE wsrep_cluster_members_history;
62Table	Create Table
63wsrep_cluster_members_history	CREATE TABLE `wsrep_cluster_members_history` (
64  `node_uuid` char(36) NOT NULL,
65  `cluster_uuid` char(36) NOT NULL,
66  `last_view_id` bigint(20) NOT NULL,
67  `last_view_seqno` bigint(20) NOT NULL,
68  `node_name` char(32) NOT NULL,
69  `node_incoming_address` varchar(256) NOT NULL,
70  PRIMARY KEY (`node_uuid`)
71) ENGINE=InnoDB DEFAULT CHARSET=latin1 STATS_PERSISTENT=0
72SHOW CREATE TABLE wsrep_streaming_log;
73Table	Create Table
74wsrep_streaming_log	CREATE TABLE `wsrep_streaming_log` (
75  `node_uuid` char(36) NOT NULL,
76  `trx_id` bigint(20) NOT NULL,
77  `seqno` bigint(20) NOT NULL,
78  `flags` int(11) NOT NULL,
79  `frag` longblob NOT NULL,
80  PRIMARY KEY (`node_uuid`,`trx_id`,`seqno`)
81) ENGINE=InnoDB DEFAULT CHARSET=latin1 STATS_PERSISTENT=0
82SHOW CREATE TABLE mysql.wsrep_cluster;
83Table	Create Table
84wsrep_cluster	CREATE TABLE `wsrep_cluster` (
85  `cluster_uuid` char(36) NOT NULL,
86  `view_id` bigint(20) NOT NULL,
87  `view_seqno` bigint(20) NOT NULL,
88  `protocol_version` int(11) NOT NULL,
89  `capabilities` int(11) NOT NULL,
90  PRIMARY KEY (`cluster_uuid`)
91) ENGINE=InnoDB DEFAULT CHARSET=latin1 STATS_PERSISTENT=0
92SHOW CREATE TABLE mysql.wsrep_cluster_members;
93Table	Create Table
94wsrep_cluster_members	CREATE TABLE `wsrep_cluster_members` (
95  `node_uuid` char(36) NOT NULL,
96  `cluster_uuid` char(36) NOT NULL,
97  `node_name` char(32) NOT NULL,
98  `node_incoming_address` varchar(256) NOT NULL,
99  PRIMARY KEY (`node_uuid`)
100) ENGINE=InnoDB DEFAULT CHARSET=latin1 STATS_PERSISTENT=0
101SHOW CREATE TABLE mysql.wsrep_streaming_log;
102Table	Create Table
103wsrep_streaming_log	CREATE TABLE `wsrep_streaming_log` (
104  `node_uuid` char(36) NOT NULL,
105  `trx_id` bigint(20) NOT NULL,
106  `seqno` bigint(20) NOT NULL,
107  `flags` int(11) NOT NULL,
108  `frag` longblob NOT NULL,
109  PRIMARY KEY (`node_uuid`,`trx_id`,`seqno`)
110) ENGINE=InnoDB DEFAULT CHARSET=latin1 STATS_PERSISTENT=0
111DROP TABLE wsrep_cluster;
112DROP TABLE wsrep_cluster_members;
113DROP TABLE wsrep_cluster_members_history;
114DROP TABLE wsrep_streaming_log;
115