扫码关注官方微信

扫码下载APP
返回顶部
首页 > 资讯 > 数据库 >mysql5.7GeleraCluster安装部署(二)
  • 635

0
分享到

mysql5.7GeleraCluster安装部署(二)

2024-04-02 19:04:59 635人浏览 独家记忆
摘要

此次是在Centos7.2上搭建的，与之前的6.5上稍有不同。 1、设置SElinux 在/etc/sysconfig/selinux文件，修改SELINUX=disabled。 2、设置防火墙，或者关

此次是在Centos7.2上搭建的，与之前的6.5上稍有不同。
1、设置SElinux
在/etc/sysconfig/selinux文件，修改SELINUX=disabled。
2、设置防火墙，或者关闭防火墙，安装完成后再开启。
wsrep(Write-Set Replication)
#mkdir -p /app/Mysql/3306
#mkdir -p /app/mysql/binlog
1、安装RPM包
# 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.################################# [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.14################################# [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           ################################# [100%]
[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.################################# [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.################################# [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.2################################# [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、创建并配置参数文件
---创建并配置my.cnf文件
# 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.197: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 <info@codership.com>            |
| wsrep_provider_version       | 3.23(rac090bc)                               |
| wsrep_ready                  | ON                                           |
+------------------------------+----------------------------------------------+
57 rows in set (0.00 sec)


节点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:4567,192.168.56.112:4567,192.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:3306,10.70.161.197:3306 |
| wsrep_desync_count           | 0                                     |
| wsrep_evs_delayed            |                                       |
| wsrep_evs_evict_list         |                                       |
| wsrep_evs_repl_latency       | 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 <info@codership.com>     |
| wsrep_provider_version       | 3.23(rac090bc)                        |
| wsrep_ready                  | ON                                    |
+------------------------------+---------------------------------------+
57 rows in set (0.01 sec)

节点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:4567,192.168.56.112:4567,192.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:3306,10.70.161.198:3306,10.70.161.197:3306 |
| wsrep_desync_count           | 0                                                       |
| wsrep_evs_delayed            |                                                         |
| wsrep_evs_evict_list         |                                                         |
| wsrep_evs_repl_latency       | 0.00046872/0.000656263/0.000845957/0.000152154/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 <info@codership.com>                       |
| wsrep_provider_version       | 3.23(rac090bc)                                          |
| wsrep_ready                  | ON                                                      |
+------------------------------+---------------------------------------------------------+
57 rows in set (0.00 sec)


----------------------End-By:TangYun-2018.04.25---------------------------------------------

您可能感兴趣的文档:

--结束END--

本文标题: mysql5.7GeleraCluster安装部署(二)

本文链接: https://lsjlt.com/news/49693.html(转载时请注明来源链接)

有问题或投稿请发送至: 邮箱/279061341@qq.com    QQ/279061341

猜你喜欢
  • mysql5.7GeleraCluster安装部署(二)
    此次是在CENTOS7.2上搭建的，与之前的6.5上稍有不同。 1、设置SELinux 在/etc/sysconfig/selinux文件，修改SELINUX=disabled。 2、设置防火墙，或者关...
    99+
    2024-04-02
  • Centos7.5安装mysql5.7.24二进制包方式部署
    一、环境准备： 操作系统：CentOS Linux release 7.5.1804 (Core) mysql版本：mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz IP...
    99+
    2024-04-02
  • sqlserver2014部署安装
    百度云网址链接： https://pan.baidu.com/s/1BwgdnESI8Fqlos9EIOLv1A 提取码: wsy5 解压ISO镜像文件，点击setup安装程序       进入安装界面       点击全新SQ...
    99+
    2014-07-23
    sqlserver2014部署安装
  • DolphinScheduler安装部署
    文章目录 1.安装环境及软件准备1.1环境 2.准备工作3.安装DolphinScheduler3.1DolphinSchedule源数据库配置3.2DolphinScheduler配置及...
    99+
    2023-09-12
    数据库 mysql apache
  • DVWA安装部署
    DVWA安装部署 前言一、DVWA是什么？二、phpstudy安装部署三、DVWA安装部署 前言 为了更好、更具体的学习了解网络安全相关的知识，笔者开始着手学习渗透测试相关内容。相关系列...
    99+
    2023-08-31
    php 安全 web安全
  • 安装golang部署
    一、前言Go是一门非常受欢迎的开源编程语言，其诞生于Google，目的是为了解决通用编程语言缺乏简洁、高效和安全性问题。越来越多的企业开始使用Go作为后端开发语言，例如Uber、Netflix等。在本篇文章中，我们将介绍如何在Linux系统...
    99+
    2023-05-22
  • 项目上线部署--》服务器部署流程（二）安装Nginx、Node.js、MySQL
    阅读本篇文章前请先阅读项目上线部署--》服务器部署流程（一）  目录 🌟安装Nginx 先登录远程服务器，安装依赖包 下载并解压包  🌟安装Node.js  安装nodejs进程管理工具  🌟...
    99+
    2023-09-30
    javascript node.js 服务器 nginx
  • influxdb-cluster安装部署
    参考资料 Influx Proxy 是一个基于高可用、一致性哈希的 InfluxDB 集群代理服务，实现了 InfluxDB 高可用集群的部署方案，具有动态扩/缩容、故障恢复、数据同步等能力。 相关文档：https://github.com...
    99+
    2019-10-06
    influxdb-cluster安装部署 数据库入门 数据库基础教程 数据库 mysql
  • 安装部署MySQL HA
    1.部署MHA接下来部署MHA，具体的搭建环境如下（所有操作系统均为CentOS7.4 64bit）：IP地址主机名角色软件192.168.12.106Master.cnmanagermha4mysql-manager、mha4mysql-...
    99+
    2014-06-28
    安装部署MySQL HA 数据库入门 数据库基础教程 数据库 mysql
  • zabbix3.0 LNMP安装部署
    安装前准备：1.1本实例运行环境说明：操作系统版本：CentOS 7首先，要先搭建Zabbix运行环境：LNMP(Linux + nginx+ MySQL + PHP(5.4以上))CentOS 7Ning...
    99+
    2024-04-02
  • vCenter 6.0安装部署
    本文主要测试vCenter 6.0的安装部署，vCenter6.0的坑爹之处是要8G内存才能安装，加上ESXi6.0需要至少4G内存，让我不得不买了2条8G的笔记本内存条，否则都无法完成这个测试。后面有时间...
    99+
    2024-04-02
  • Zabbix 3.0 安装部署
    zabbix软件包下载zabbix-3.0.1.tar.gzhttp://heanet.dl.sourceforge.net/project/zabbix/ZABBIX%20Latest%20Stable/...
    99+
    2024-04-02
  • redis 3.0.7 安装部署
    ############################基础环境OS: centos 6.6DB: redis 3.0.7#############################1.下载源码包,稳定版本&...
    99+
    2024-04-02
  • MHA的安装部署
    本篇内容主要讲解“MHA的安装部署”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“MHA的安装部署”吧! MHA 0.56 is n...
    99+
    2024-04-02
  • xxl-job安装部署
    一、简介 XXL-JOB是一个分布式任务调度平台，其核心设计目标是开发迅速、学习简单、轻量级、易扩展。现已开放源代码并接入多家公司线上产品线，开箱即用。 中文文档English Documentation 二、安装 xxl-job需要的提前...
    99+
    2023-09-04
    linux 运维 服务器
  • 安装部署wordpress(Ubuntu)
    wordpress是一个目前流行的基于web的内容管理系统软件。它是基于PHP语言和MySQL数据库开发的，用户可以在支持 PHP 和 MySQL数据库的服务器上快速轻松的部署自己的网站（博客，外贸网站等等）。WordPress有非常多的第...
    99+
    2023-09-09
    php 开发语言 Powered by 金山文档
  • Python的安装部署
    为了更好的学习，我们在Windows和Linux上都安装Python 2.7和Python 3.5https://www.python.org/downloads/为了避免冲突，把Python3.5解压后的python.exe改为pytho...
    99+
    2023-01-31
    Python
  • Nagios+PNP安装部署
        下载所需要的相关软件包，本文使用的nagios版本是3.4.3，nagios-plugins版本是2.2.1，nrpe版本是2.15。配置好yum源后即可开始下面的安装。一、安装相关软件包#y...
    99+
    2023-06-06
  • 离线安装CDH-cdh5.8.3及二进制部署Mysql5.7教程
    下面一起来了解下离线安装CDH-cdh5.8.3及二进制部署Mysql5.7教程，相信大家看完肯定会受益匪浅，文字在精不在多，希望离线安装CDH-cdh5.8.3及二进制部署Mysql5.7教程这篇短内容是...
    99+
    2024-04-02
  • 通过 MySQL 8.0 二进制安装包部署多实例
    解压安装包 cd /usr/local tar xvf mysql-8.0.12-linux-glibc2.12-x86_64.tar.xz mv mysql-8.0.12-linux-glibc2.12-...
    99+
    2024-04-02
软考高级职称资格查询
热门wiki
近期文章
推荐阅读
热门问答
热门标签
编程网，编程工程师的家园，是目前国内优秀的开源技术社区之一，形成了由开源软件库、代码分享、资讯、协作翻译、讨论区和博客等几大频道内容，为IT开发者提供了一个发现、使用、并交流开源技术的平台。

  • 官方手机版

  • 微信公众号

  • 商务合作