mirror of
https://github.com/MariaDB/server.git
synced 2025-10-30 18:36:12 +01:00
913efaa328
Actual problem was that we tried to calculate persistent statistics to wsrep_schema tables in this case wsrep_streaming_log. These tables should not have persistent statistics. Therefore, in table creation tables should be created with STATS_PERSISTENT=0 table option. During rolling-upgrade tables naturally already exists, thus we need to alter them to contain STATS_PERSISTENT=0 table option.
61 lines
1.7 KiB
Text
61 lines
1.7 KiB
Text
--source include/galera_cluster.inc
|
|
|
|
CREATE TABLE IF NOT EXISTS wsrep_cluster
|
|
(
|
|
cluster_uuid CHAR(36) PRIMARY KEY,
|
|
view_id BIGINT NOT NULL,
|
|
view_seqno BIGINT NOT NULL,
|
|
protocol_version INT NOT NULL,
|
|
capabilities INT NOT NULL
|
|
) ENGINE=InnoDB;
|
|
|
|
CREATE TABLE IF NOT EXISTS wsrep_cluster_members
|
|
(
|
|
node_uuid CHAR(36) PRIMARY KEY,
|
|
cluster_uuid CHAR(36) NOT NULL,
|
|
node_name CHAR(32) NOT NULL,
|
|
node_incoming_address VARCHAR(256) NOT NULL
|
|
) ENGINE=InnoDB;
|
|
|
|
CREATE TABLE IF NOT EXISTS wsrep_cluster_members_history
|
|
(
|
|
node_uuid CHAR(36) PRIMARY KEY,
|
|
cluster_uuid CHAR(36) NOT NULL,
|
|
last_view_id BIGINT NOT NULL,
|
|
last_view_seqno BIGINT NOT NULL,
|
|
node_name CHAR(32) NOT NULL,
|
|
node_incoming_address VARCHAR(256) NOT NULL
|
|
) ENGINE=InnoDB;
|
|
|
|
CREATE TABLE IF NOT EXISTS wsrep_streaming_log
|
|
(
|
|
node_uuid CHAR(36),
|
|
trx_id BIGINT,
|
|
seqno BIGINT,
|
|
flags INT NOT NULL,
|
|
frag LONGBLOB NOT NULL,
|
|
PRIMARY KEY (node_uuid, trx_id, seqno)
|
|
) ENGINE=InnoDB;
|
|
|
|
DELETE FROM wsrep_cluster;
|
|
DELETE FROM wsrep_cluster_members;
|
|
|
|
ALTER TABLE wsrep_cluster STATS_PERSISTENT=0;
|
|
ALTER TABLE wsrep_cluster_members STATS_PERSISTENT=0;
|
|
ALTER TABLE wsrep_cluster_members_history STATS_PERSISTENT=0;
|
|
ALTER TABLE wsrep_streaming_log STATS_PERSISTENT=0;
|
|
|
|
SHOW CREATE TABLE wsrep_cluster;
|
|
SHOW CREATE TABLE wsrep_cluster_members;
|
|
SHOW CREATE TABLE wsrep_cluster_members_history;
|
|
SHOW CREATE TABLE wsrep_streaming_log;
|
|
|
|
SHOW CREATE TABLE mysql.wsrep_cluster;
|
|
SHOW CREATE TABLE mysql.wsrep_cluster_members;
|
|
#SHOW CREATE TABLE mysql.wsrep_cluster_members_history;
|
|
SHOW CREATE TABLE mysql.wsrep_streaming_log;
|
|
|
|
DROP TABLE wsrep_cluster;
|
|
DROP TABLE wsrep_cluster_members;
|
|
DROP TABLE wsrep_cluster_members_history;
|
|
DROP TABLE wsrep_streaming_log;
|