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