Mysql5.7GeleraCluster installation and deployment (2)
This time it is built on CENTOS7.2, which is slightly different from the previous 6.5.
1. Set SELinux
In the / etc/sysconfig/selinux file, modify the SELINUX=disabled.
2. Set up the firewall, or turn it off, and then turn it on after the installation is complete.
Wsrep (Write-Set Replication)
# mkdir-p / app/mysql/3306
# mkdir-p / app/mysql/binlog
1. Install the RPM package
# rpm-e mariadb-libs-1:5.5.52-1.el7.x86_64-- nodeps
# rpm-e mariadb-libs-5.5.44-2.el7.centos.x86_64-- nodeps
# rpm-ivh mysql-wsrep-common-5.7-5.7.21-25.14.el7.x86_64.rpm
Warning: mysql-wsrep-common-5.7-5.7.21-25.14.el7.x86_64.rpm: Header V4 RSA/SHA512 Signature, key ID bc19ddba: NOKEY
Preparing... # # [100%]
Updating / installing...
1:mysql-wsrep-common-5.7-5.7.21-25.00 # [100%]
[root@mysql01 soft] # rpm-ivh mysql-wsrep-libs-5.7-5.7.21-25.14.el7.x86_64.rpm
Warning: mysql-wsrep-libs-5.7-5.7.21-25.14.el7.x86_64.rpm: Header V4 RSA/SHA512 Signature, key ID bc19ddba: NOKEY
Preparing... # # [100%]
Updating / installing...
1:mysql-wsrep-libs-5.7-5.7.21-25.14mm # [100%]
[root@mysql01 soft] # rpm-ivh galera-3-25.3.23-2.el7.x86_64.rpm
Warning: galera-3-25.3.23-2.el7.x86_64.rpm: Header V4 RSA/SHA512 Signature, key ID bc19ddba: NOKEY
Error: Failed dependencies:
Libboost_program_options.so.1.53.0 () (64bit) is needed by galera-3-25.3.23-2.el7.x86_64
# yum install boost-devel.x86_64
# rpm-ivh galera-3-25.3.23-2.el7.x86_64.rpm
Warning: galera-3-25.3.23-2.el7.x86_64.rpm: Header V4 RSA/SHA512 Signature, key ID bc19ddba: NOKEY
Preparing... # # [100%]
Updating / installing...
1:galera-3-25.3.23-2.el7 # #
[root@mysql01 soft] # rpm-ivh mysql-wsrep-client-5.7-5.7.21-25.14.el7.x86_64.rpm
Warning: mysql-wsrep-client-5.7-5.7.21-25.14.el7.x86_64.rpm: Header V4 RSA/SHA512 Signature, key ID bc19ddba: NOKEY
Preparing... # # [100%]
Updating / installing...
1:mysql-wsrep-client-5.7-5.7.21-25.00 # [100%]
# rpm-ivh mysql-wsrep-server-5.7-5.7.21-25.14.el7.x86_64.rpm
Warning: mysql-wsrep-server-5.7-5.7.21-25.14.el7.x86_64.rpm: Header V4 RSA/SHA512 Signature, key ID bc19ddba: NOKEY
Error: Failed dependencies:
Lsof is needed by mysql-wsrep-server-5.7-5.7.21-25.14.el7.x86_64
Socat is needed by mysql-wsrep-server-5.7-5.7.21-25.14.el7.x86_64
# yum install lsof-y
# yum install socat-y
# rpm-ivh mysql-wsrep-server-5.7-5.7.21-25.14.el7.x86_64.rpm
Warning: mysql-wsrep-server-5.7-5.7.21-25.14.el7.x86_64.rpm: Header V4 RSA/SHA512 Signature, key ID bc19ddba: NOKEY
Preparing... # # [100%]
Updating / installing...
1:mysql-wsrep-server-5.7-5.7.21-25.00 # [100%]
# rpm-ivh mysql-wsrep-libs-compat-5.7-5.7.21-25.14.el7.x86_64.rpm
Warning: mysql-wsrep-libs-compat-5.7-5.7.21-25.14.el7.x86_64.rpm: Header V4 RSA/SHA512 Signature, key ID bc19ddba: NOKEY
Preparing... # # [100%]
Updating / installing...
1:mysql-wsrep-libs-compat-5.7-5.7.2percent # [100%]
# yum install rsync-y
# rpm-ivh jemalloc-3.6.0-8.el7.centos.x86_64.rpm
Preparing... # # [100%]
Updating / installing...
1:jemalloc-3.6.0-8.el7.centos # # [100%]
# ls-l / usr/lib64/libjemalloc.so.1
-rwxr-xr-x 1 root root 232808 Sep 14 2014 / usr/lib64/libjemalloc.so.1
2. Create and configure parameter files
-create and configure my.cnf files
# cat / etc/my.cnf
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128m
[mysqld]
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
# These are commonly set, remove the # and set as required.
# basedir =.
# datadir =.
# port =.
# server_id =.
# socket =.
Explicit_defaults_for_timestamp=true
Log_timestamps=SYSTEM
Character_set_server = utf8
Server-id=31
Basedir=/usr
User=mysql
Skip-name-resolve
Lower_case_table_names=1
Max_connections=1000
Max_connect_errors=1000
Datadir=/app/mysql/3306
Default-storage-engine = InnoDB
Socket=/app/mysql/3306/mysql.sock
Innodb_autoinc_lock_mode=2
Innodb_flush_log_at_trx_commit=0
Innodb_buffer_pool_size=6G
Thread_cache_size=64
Max_allowed_packet=128M
# pid_file=/app/mysql/mysqld.pid
Port=3306
Log-error=/app/mysql/mysql.err
# add for bin-log
Log-bin=ON
Log-bin=/app/mysql/binlog/mysql-bin
Log-bin-index=/app/mysql/binlog/mysql-bin.index
Expire-logs-days=32
Max-binlog-size=512M
# binlog_format=mixed
Binlog-format=ROW
Log-slave-updates=on
# # add for cluster
Wsrep_cluster_name='uni_cluster'
Wsrep-provider=/usr/lib64/galera-3/libgalera_smm.so
Wsrep_node_name = uni01
# wsrep_cluster_address=gcomm://
Wsrep_cluster_address=gcomm://10.70.67.31,10.70.161.115,10.70.161.91
Wsrep_node_address='10.70.67.31'
# wsrep_node_incoming_address='10.70.161.197:4567'
Wsrep_provider_options = "gmcast.listen_addr=tcp://10.70.67.31:4567"
Wsrep_sst_donor='uni01,uni02,uni03'
Wsrep_sst_method=rsync
# wsrep_slave_threads=16
Wsrep_sst_auth=tyuni:TyunI#2018
Slow_query_log=on
Sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128m
# sort_buffer_size = 2m
# read_rnd_buffer_size = 2m
# sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[client]
Socket=/app/mysql/3306/mysql.sock
# default-character-set=utf8
[mysql]
# default-character-set=utf8
Socket=/app/mysql/3306/mysql.sock
[mysqldump]
Max_allowed_packet = 512m
[mysqld_safe]
Malloc-lib=/usr/lib64/libjemalloc.so.1
# id mysql
Uid=27 (mysql) gid=27 (mysql) groups=27 (mysql)
# chmod-R 775 / app/mysql
# chown-R mysql.mysql / app/mysql
Mysqld-initialize-user=mysql
4eVsE:i0okKy
# mysql_ssl_rsa_setup
Cd / usr/lib/systemd/system
Vi mysqld.service
# cat mysqld.service
# Copyright (c) 2015, 2016, Oracle and/or its affiliates. All rights reserved.
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; version 2 of the License.
#
# This program is distributed in the hope that it will be useful
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
#
# systemd service file for MySQL forking server
# Modified for wsrep (Galera): Recovery
#
[Unit]
Description=MySQL Server
Documentation=man:mysqld (8)
Documentation= http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
Type=forking
# PIDFile=/var/run/mysqld/mysqld.pid
PIDFile=/app/mysql/mysqld.pid
# Disable service start and stop timeout logic of systemd for mysqld service.
TimeoutSec=0
# Execute pre and post scripts as root
PermissionsStartOnly=true
# Needed to create system tables and to check for cluster crash recovery
# ExecStartPre=/usr/bin/mysqld_pre_systemd-pre
# Start main service
# ExecStart=/usr/sbin/mysqld-- daemonize-- pid-file=/app/mysql/mysqld.pid $MYSQLD_OPTS $MYSQLD_RECOVER_START
ExecStart=/usr/sbin/mysqld-daemonize-pid-file=/app/mysql/mysqld.pid $MYSQLD_OPTS
# Needed to reset cluster crash recovery
# ExecStartPost=/usr/bin/mysqld_pre_systemd-post
# Use this to switch malloc implementation
EnvironmentFile=-/etc/sysconfig/mysql
# Sets open_files_limit
LimitNOFILE = 65535
Restart=on-failure
# Dirty hack to prevent fast restart in case of configuration problem.
# Longer-term fix will be to ensure exit status 1 for "RestartPreventExitStatus=1" below.
RestartSec=1
RestartPreventExitStatus=1
PrivateTmp=false
Systemctl daemon-reload
Systemctl enable mysqld.service
Systemctl is-enabled mysqld
Systemctl start mysqld.service
Mysql-uroot-p
Set password=password ("My#Sql2018")
Grant usage on *. * to tyuni@'10.70.161.%' identified by 'TyunI#2018'
Grant all privileges on *. * to tyuni@'10.70.161.%'
Flush privileges
Systemctl stop mysqld.service
Systemctl start mysqld.service
Tyuni:TyunI#2018
Mysqld start-wsrep-cluster-address= "gcomm://"
Mysql > show global status like 'wsrep%'
+-+ +
| | Variable_name | Value |
+-+ +
| | wsrep_local_state_uuid | 41c1fd6a-485a-11e8-bbca-17d012bd2e14 |
| | wsrep_protocol_version | 8 |
| | wsrep_last_committed | 0 | |
| | wsrep_replicated | 0 | |
| | wsrep_replicated_bytes | 0 | |
| | wsrep_repl_keys | 0 | |
| | wsrep_repl_keys_bytes | 0 | |
| | wsrep_repl_data_bytes | 0 | |
| | wsrep_repl_other_bytes | 0 | |
| | wsrep_received | 2 | |
| | wsrep_received_bytes | 142 | |
| | wsrep_local_commits | 0 | |
| | wsrep_local_cert_failures | 0 | |
| | wsrep_local_replays | 0 | |
| | wsrep_local_send_queue | 0 | |
| | wsrep_local_send_queue_max | 1 | |
| | wsrep_local_send_queue_min | 0 | |
| | wsrep_local_send_queue_avg | 0.000000 | |
| | wsrep_local_recv_queue | 0 | |
| | wsrep_local_recv_queue_max | 2 | |
| | wsrep_local_recv_queue_min | 0 | |
| | wsrep_local_recv_queue_avg | 0.500000 | |
| | wsrep_local_cached_downto | 18446744073709551615 | |
| | wsrep_flow_control_paused_ns | 0 | |
| | wsrep_flow_control_paused | 0.000000 | |
| | wsrep_flow_control_sent | 0 | |
| | wsrep_flow_control_recv | 0 | |
| | wsrep_cert_deps_distance | 0.000000 | |
| | wsrep_apply_oooe | 0.000000 | |
| | wsrep_apply_oool | 0.000000 | |
| | wsrep_apply_window | 0.000000 | |
| | wsrep_commit_oooe | 0.000000 | |
| | wsrep_commit_oool | 0.000000 | |
| | wsrep_commit_window | 0.000000 | |
| | wsrep_local_state | 4 |
| | wsrep_local_state_comment | Synced |
| | wsrep_cert_index_size | 0 | |
| | wsrep_causal_reads | 0 | |
| | wsrep_cert_interval | 0.000000 | |
| | wsrep_incoming_addresses | 10.70.161.197purl 3306 |
| | wsrep_desync_count | 0 | |
| | wsrep_evs_delayed |
| | wsrep_evs_evict_list |
| | wsrep_evs_repl_latency | 3.28e-06/5.2706e-06/1.1043e-05/2.97663e-06/5 |
| | wsrep_evs_state | OPERATIONAL |
| | wsrep_gcomm_uuid | c00e5c51-4859-11e8-bc39-5f72a1dcd0e7 |
| | wsrep_cluster_conf_id | 1 | |
| | wsrep_cluster_size | 1 | |
| | wsrep_cluster_state_uuid | 41c1fd6a-485a-11e8-bbca-17d012bd2e14 |
| | wsrep_cluster_status | Primary |
| | wsrep_connected | ON |
| | wsrep_local_bf_aborts | 0 | |
| | wsrep_local_index | 0 | |
| | wsrep_provider_name | Galera |
| | wsrep_provider_vendor | Codership Oy |
| | wsrep_provider_version | 3.23 (rac090bc) |
| | wsrep_ready | ON |
+-+ +
57 rows in set (0.00 sec)
Node 2:
# yum install rsync-y
# cat / etc/my.cnf.d/wsrep.cnf
# * * upgrade to a newer version of MySQL.
[mysqld]
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128m
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
# These are commonly set, remove the # and set as required.
# basedir =.
# datadir =.
# port =.
# server_id =.
# socket =.
Explicit_defaults_for_timestamp=true
Log_timestamps=SYSTEM
Character_set_server = utf8
Server-id=198
Basedir=/usr
User=mysql
Skip-name-resolve
Lower_case_table_names=1
Max_connections=1000
Max_connect_errors=1000
Datadir=/app/mysql/3306
Default-storage-engine = InnoDB
Socket=/app/mysql/3306/mysql.sock
Innodb_autoinc_lock_mode=2
Innodb_flush_log_at_trx_commit=0
Innodb_buffer_pool_size=6G
# pid_file=/app/mysql/mysqld.pid
Port=3306
Log-error=/app/mysql/mysql.err
# add for bin-log
Log-bin=ON
Log-bin=/app/mysql/binlog/mysql-bin
Log-bin-index=/app/mysql/binlog/mysql-bin.index
Expire-logs-days=15
Max-binlog-size=512M
# binlog_format=mixed
Binlog-format=ROW
Log-slave-updates=on
# # add for cluster
Wsrep_cluster_name='uni_cluster'
Wsrep-provider=/usr/lib64/galera-3/libgalera_smm.so
Wsrep_node_name = uni02
Wsrep_cluster_address=gcomm://10.70.161.197,10.70.161.198,10.70.161.91
Wsrep_node_address='10.70.161.198'
# wsrep_node_incoming_address='10.70.161.197:4567'
Wsrep_provider_options = "gmcast.listen_addr=tcp://10.70.161.198:4567"
# wsrep_cluster_address=gcomm://192.168.56.111:4567192.168.56.112:4567192.168.56.113:4567
Wsrep_sst_donor='uni01,uni02,uni03'
Wsrep_sst_method=rsync
# wsrep_slave_threads=16
Wsrep_sst_auth=tyuni:TyunI#2018
Slow_query_log=on
Sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128m
# sort_buffer_size = 2m
# read_rnd_buffer_size = 2m
# sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[client]
Socket=/app/mysql/3306/mysql.sock
# default-character-set=utf8
[mysql]
# default-character-set=utf8
Socket=/app/mysql/3306/mysql.sock
[mysqldump]
Max_allowed_packet = 512m
[mysqld_safe]
Malloc-lib=/usr/lib64/libjemalloc.so.1
Mysql > show global status like 'wsrep%'
+-+
| | Variable_name | Value |
+-+
| | wsrep_local_state_uuid | 41c1fd6a-485a-11e8-bbca-17d012bd2e14 |
| | wsrep_protocol_version | 8 |
| | wsrep_last_committed | 0 | |
| | wsrep_replicated | 0 | |
| | wsrep_replicated_bytes | 0 | |
| | wsrep_repl_keys | 0 | |
| | wsrep_repl_keys_bytes | 0 | |
| | wsrep_repl_data_bytes | 0 | |
| | wsrep_repl_other_bytes | 0 | |
| | wsrep_received | 3 | |
| | wsrep_received_bytes | 220 | |
| | wsrep_local_commits | 0 | |
| | wsrep_local_cert_failures | 0 | |
| | wsrep_local_replays | 0 | |
| | wsrep_local_send_queue | 0 | |
| | wsrep_local_send_queue_max | 1 | |
| | wsrep_local_send_queue_min | 0 | |
| | wsrep_local_send_queue_avg | 0.000000 | |
| | wsrep_local_recv_queue | 0 | |
| | wsrep_local_recv_queue_max | 1 | |
| | wsrep_local_recv_queue_min | 0 | |
| | wsrep_local_recv_queue_avg | 0.000000 | |
| | wsrep_local_cached_downto | 18446744073709551615 | |
| | wsrep_flow_control_paused_ns | 0 | |
| | wsrep_flow_control_paused | 0.000000 | |
| | wsrep_flow_control_sent | 0 | |
| | wsrep_flow_control_recv | 0 | |
| | wsrep_cert_deps_distance | 0.000000 | |
| | wsrep_apply_oooe | 0.000000 | |
| | wsrep_apply_oool | 0.000000 | |
| | wsrep_apply_window | 0.000000 | |
| | wsrep_commit_oooe | 0.000000 | |
| | wsrep_commit_oool | 0.000000 | |
| | wsrep_commit_window | 0.000000 | |
| | wsrep_local_state | 4 |
| | wsrep_local_state_comment | Synced |
| | wsrep_cert_index_size | 0 | |
| | wsrep_causal_reads | 0 | |
| | wsrep_cert_interval | 0.000000 | |
| | wsrep_incoming_addresses | 10.70.161.198 purl 3306 Magazine 10.70.161.197Vera 3306 |
| | wsrep_desync_count | 0 | |
| | wsrep_evs_delayed |
| | wsrep_evs_evict_list |
| | wsrep_evs_repl_latency | 0 / 0 / 0 | 0 / 0 / 0 |
| | wsrep_evs_state | OPERATIONAL |
| | wsrep_gcomm_uuid | 8b09545b-485e-11e8-a794-4e977f6db8c0 |
| | wsrep_cluster_conf_id | 46 | |
| | wsrep_cluster_size | 2 | |
| | wsrep_cluster_state_uuid | 41c1fd6a-485a-11e8-bbca-17d012bd2e14 |
| | wsrep_cluster_status | Primary |
| | wsrep_connected | ON |
| | wsrep_local_bf_aborts | 0 | |
| | wsrep_local_index | 0 | |
| | wsrep_provider_name | Galera |
| | wsrep_provider_vendor | Codership Oy |
| | wsrep_provider_version | 3.23 (rac090bc) |
| | wsrep_ready | ON |
+-+
57 rows in set (0.01 sec)
Node 3:
# yum install rsync-y
# cat / etc/my.cnf.d/wsrep.cnf
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128m
[mysqld]
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
# These are commonly set, remove the # and set as required.
# basedir =.
# datadir =.
# port =.
# server_id =.
# socket =.
Explicit_defaults_for_timestamp=true
Log_timestamps=SYSTEM
Character_set_server = utf8
Server-id=91
Basedir=/usr
User=mysql
Skip-name-resolve
Lower_case_table_names=1
Max_connections=1000
Max_connect_errors=1000
Datadir=/app/mysql/3306
Default-storage-engine = InnoDB
Socket=/app/mysql/3306/mysql.sock
Innodb_autoinc_lock_mode=2
Innodb_flush_log_at_trx_commit=0
Innodb_buffer_pool_size=6G
# pid_file=/app/mysql/mysqld.pid
Port=3306
Log-error=/app/mysql/mysql.err
# add for bin-log
Log-bin=ON
Log-bin=/app/mysql/binlog/mysql-bin
Log-bin-index=/app/mysql/binlog/mysql-bin.index
Expire-logs-days=15
Max-binlog-size=512M
# binlog_format=mixed
Binlog-format=ROW
Log-slave-updates=on
# # add for cluster
Wsrep_cluster_name='uni_cluster'
Wsrep-provider=/usr/lib64/galera-3/libgalera_smm.so
Wsrep_node_name = uni03
Wsrep_cluster_address=gcomm://10.70.161.197,10.70.161.198,10.70.161.91
Wsrep_node_address='10.70.161.91'
# wsrep_node_incoming_address='10.70.161.197:4567'
Wsrep_provider_options = "gmcast.listen_addr=tcp://10.70.161.91:4567"
# wsrep_cluster_address=gcomm://192.168.56.111:4567192.168.56.112:4567192.168.56.113:4567
Wsrep_sst_donor='uni01,uni02,uni03'
Wsrep_sst_method=rsync
# wsrep_slave_threads=16
Wsrep_sst_auth=tyuni:TyunI#2018
Slow_query_log=on
Sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128m
# sort_buffer_size = 2m
# read_rnd_buffer_size = 2m
# sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[client]
Socket=/app/mysql/3306/mysql.sock
# default-character-set=utf8
[mysql]
# default-character-set=utf8
Socket=/app/mysql/3306/mysql.sock
[mysqldump]
Max_allowed_packet = 512m
[mysqld_safe]
Malloc-lib=/usr/lib64/libjemalloc.so.1
Mysql > show global status like 'wsrep%'
+-+
| | Variable_name | Value |
+-+
| | wsrep_local_state_uuid | 41c1fd6a-485a-11e8-bbca-17d012bd2e14 |
| | wsrep_protocol_version | 8 |
| | wsrep_last_committed | 1 | |
| | wsrep_replicated | 0 | |
| | wsrep_replicated_bytes | 0 | |
| | wsrep_repl_keys | 0 | |
| | wsrep_repl_keys_bytes | 0 | |
| | wsrep_repl_data_bytes | 0 | |
| | wsrep_repl_other_bytes | 0 | |
| | wsrep_received | 3 | |
| | wsrep_received_bytes | 289 |
| | wsrep_local_commits | 0 | |
| | wsrep_local_cert_failures | 0 | |
| | wsrep_local_replays | 0 | |
| | wsrep_local_send_queue | 0 | |
| | wsrep_local_send_queue_max | 1 | |
| | wsrep_local_send_queue_min | 0 | |
| | wsrep_local_send_queue_avg | 0.000000 | |
| | wsrep_local_recv_queue | 0 | |
| | wsrep_local_recv_queue_max | 1 | |
| | wsrep_local_recv_queue_min | 0 | |
| | wsrep_local_recv_queue_avg | 0.000000 | |
| | wsrep_local_cached_downto | 18446744073709551615 | |
| | wsrep_flow_control_paused_ns | 0 | |
| | wsrep_flow_control_paused | 0.000000 | |
| | wsrep_flow_control_sent | 0 | |
| | wsrep_flow_control_recv | 0 | |
| | wsrep_cert_deps_distance | 0.000000 | |
| | wsrep_apply_oooe | 0.000000 | |
| | wsrep_apply_oool | 0.000000 | |
| | wsrep_apply_window | 0.000000 | |
| | wsrep_commit_oooe | 0.000000 | |
| | wsrep_commit_oool | 0.000000 | |
| | wsrep_commit_window | 0.000000 | |
| | wsrep_local_state | 4 |
| | wsrep_local_state_comment | Synced |
| | wsrep_cert_index_size | 0 | |
| | wsrep_causal_reads | 0 | |
| | wsrep_cert_interval | 0.000000 | |
| | wsrep_incoming_addresses | 10.70.161.91 Freud 3306 Magi 10.70.161.1983306 Magi 10.70.161.197 Freud 3306 |
| | wsrep_desync_count | 0 | |
| | wsrep_evs_delayed |
| | wsrep_evs_evict_list |
| | wsrep_evs_repl_latency | 0.00046872According 0.000656263Universe 0.000845957According to 0.000152154Accord 7 |
| | wsrep_evs_state | OPERATIONAL |
| | wsrep_gcomm_uuid | 68a3d1f0-4863-11e8-bb94-96ef6746cd06 |
| | wsrep_cluster_conf_id | 47 |
| | wsrep_cluster_size | 3 | |
| | wsrep_cluster_state_uuid | 41c1fd6a-485a-11e8-bbca-17d012bd2e14 |
| | wsrep_cluster_status | Primary |
| | wsrep_connected | ON |
| | wsrep_local_bf_aborts | 0 | |
| | wsrep_local_index | 0 | |
| | wsrep_provider_name | Galera |
| | wsrep_provider_vendor | Codership Oy |
| | wsrep_provider_version | 3.23 (rac090bc) |
| | wsrep_ready | ON |
+-+
57 rows in set (0.00 sec)
-- End-By:TangYun-2018.04.25-
