Galera集群同步但缺少变量wsrep_cluster_size

Question

我有一个Galera集群正在运行，并且处于同步状态，但是它缺少wsrep_cluster_size，请参见下面的命令屏幕快照。

MariaDB [(none)]> show variables like 'wsrep_cluster_size';
Empty set (0.01 sec)

详细信息：

第一台服务器上的配置：

#
# This group is read both by the client and the server
# use it for options that affect everything
#
[client-server]

[galera]
wsrep_on=ON
wsrep_provider=/usr/lib64/galera/libgalera_smm.so
wsrep_cluster_address='gcomm://192.168.56.70,192.168.56.71'
wsrep_cluster_name='setsv-db'
wsrep_node_address='192.168.56.70'
wsrep_node_name='setsv'
wsrep_sst_method=xtrabackup
#wsrep_sst_method=rsync
wsrep_sst_auth=sst_user:sst_user_password
wsrep_provider_options="socket.ssl=true; socket.ssl_key=/etc/pki/galera/server-key.pem; socket.ssl_cert=/etc/pki/galera/server-cert.pem; socket.ssl_ca=/etc/pki/galera/ca-cert.pem"
binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2

第二台服务器上的配置：

#
# This group is read both by the client and the server
# use it for options that affect everything
#
[client-server]

[galera]
wsrep_on=ON
wsrep_provider=/usr/lib64/galera/libgalera_smm.so
wsrep_cluster_address='gcomm://192.168.56.70,192.168.56.71'
wsrep_cluster_name='setsv-db'
wsrep_node_address='192.168.56.71'
wsrep_node_name='setsv-dr'
wsrep_sst_method=xtrabackup
#wsrep_sst_method=rsync
wsrep_sst_auth=sst_user:sst_user_password
wsrep_provider_options="socket.ssl=true; socket.ssl_key=/etc/pki/galera/server-key.pem; socket.ssl_cert=/etc/pki/galera/server-cert.pem; socket.ssl_ca=/etc/pki/galera/ca-cert.pem"
binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2

Answer 1

现在不用担心了。我以前调用了错误的SQL命令，应该是GLOBAL STATUS：

SHOW GLOBAL STATUS LIKE 'wsrep_%';