pxc1:192.168.7.71
pxc2:192.168.7.72
pxc3:192.168.7.73

firewalld 和 selinux都關(guān)閉，保證時(shí)間同步；如果已安裝mysql，必須卸載！?。?br /> OS 版本

[root@pxc1 ~]#cat /etc/redhat-release 
CentOS Linux release 7.7.1908 (Core)

操作步驟
pxc1主機(jī)
1.安裝輔助工具Ansible，前提三臺(tái)主機(jī)做好key驗(yàn)證

[root@pxc1 ~]#yum -y install ansible

1.1/etc/ansible/hosts配置，在最后一行后面添加以下配置

[pxcservers]
192.168.7.71
192.168.7.72
192.168.7.73

1.2/etc/ansible/ansible.cfg配置

module_name = shell  #115行，將默認(rèn)的模塊command該為shell
host_key_checking = False #71行，去掉前面的注釋

2.安裝Percona XtraDB Cluster 5.7

# 1.使用清華大學(xué)的yum源，官方源太慢了
[root@pxc1 ~]#vim /etc/yum.repos.d/pxc.repo
[percona]
name=percona_repo
baseurl=https://mirrors.tuna.tsinghua.edu.cn/percona/release/$releasever/RPMS/$basearch
enabled=1
gpgcheck=0

# 2.同時(shí)將配置文件傳給pxc2和pxc3
[root@pxc1 ~]#ansible \\\'pxcservers:!192.168.7.71\\\' -m copy -a \\\'src=/etc/yum.repos.d/pxc.repo dest=/etc/yum.repos.d\\\'
192.168.7.73 | CHANGED => {

# 3.查看三臺(tái)主機(jī)的pxc.repo文件是否一致
[root@pxc1 ~]#ansible \\\'pxcservers\\\'  -a \\\'cat /etc/yum.repos.d/pxc.repo\\\'
192.168.7.73 | CHANGED | rc=0 >>
[percona]
name=percona_repo
baseurl=https://mirrors.tuna.tsinghua.edu.cn/percona/release/$releasever/RPMS/$basearch
enabled=1
gpgcheck=0

192.168.7.72 | CHANGED | rc=0 >>
[percona]
name=percona_repo
baseurl=https://mirrors.tuna.tsinghua.edu.cn/percona/release/$releasever/RPMS/$basearch
enabled=1
gpgcheck=0

192.168.7.71 | CHANGED | rc=0 >>
[percona]
name=percona_repo
baseurl=https://mirrors.tuna.tsinghua.edu.cn/percona/release/$releasever/RPMS/$basearch
enabled=1
gpgcheck=0

# 4.執(zhí)行以下命令，在三臺(tái)主機(jī)都安裝PXC 5.7
[root@pxc1 ~]#ansible \\\'pxcservers\\\'  -a \\\'yum install Percona-XtraDB-Cluster-57 -y\\\'

3.修改配置文件

# /etc/my.cnf為主配置文件，當(dāng)前版本中，其余的配置文件都放在/etc/percona-xtradb-cluster.conf.d目錄里，包括Mysqld.cnf，MYSQLd_safe.cnf，wsrep.cnf 三個(gè)文件

[root@pxc1 ~]#tree /etc/percona-xtradb-cluster.conf.d/
/etc/percona-xtradb-cluster.conf.d/
├── mysqld.cnf
├── mysqld_safe.cnf
└── wsrep.cnf

0 directories, 3 files
[root@pxc1 ~]#egrep -v ^#|^$ /etc/percona-xtradb-cluster.conf.d/wsrep.cnf
[mysqld]
wsrep_provider=/usr/lib64/galera3/libgalera_smm.so
wsrep_cluster_address=gcomm://192.168.7.71,192.168.7.72,192.168.7.73 #集群中每個(gè)幾點(diǎn)的IP
binlog_format=ROW
default_storage_engine=InnoDB
wsrep_slave_threads= 8
wsrep_log_conflicts
innodb_autoinc_lock_mode=2
wsrep_node_address=192.168.7.71 #取消行首注釋，指定本節(jié)點(diǎn)的IP
wsrep_cluster_name=pxc-cluster
wsrep_node_name=pxc-cluster-node-1 #本節(jié)點(diǎn)在集群中的名稱
pxc_strict_mode=ENFORCING
wsrep_sst_method=xtrabackup-v2
wsrep_sst_auth=sstuser:123.com #取消行首注釋，并且修改密碼

3.1將配置文件copy給pxc2，pxc3兩臺(tái)主機(jī)，然后稍作修改，主要項(xiàng)是wsrep_node_address和wsrep_node_name

# 1.copy
[root@pxc1 ~]#ansible \\\'pxcservers:!192.168.7.71\\\' -m copy -a \\\'src=/etc/percona-xtradb-cluster.conf.d/wsrep.cnf dest=/etc/percona-xtradb-cluster.conf.d\\\'

# 2.修改pxc2主機(jī)的配置文件
[root@pxc1 ~]#ansible \\\'192.168.7.72\\\' -a \\\'sed -i -e s/wsrep_node_address=192.168.7.71/wsrep_node_address=192.168.7.72/ -e s/wsrep_node_name=pxc-cluster-node-1/wsrep_node_name=pxc-cluster-node-2/ /etc/percona-xtradb-cluster.conf.d/wsrep.cnf\\\'

# 3.修改pxc3主機(jī)的配置文件
[root@pxc1 ~]#ansible \\\'192.168.7.73\\\' -a \\\'sed -i -e s/wsrep_node_address=192.168.7.71/wsrep_node_address=192.168.7.73/ -e s/wsrep_node_name=pxc-cluster-node-1/wsrep_node_name=pxc-cluster-node-3/ /etc/percona-xtradb-cluster.conf.d/wsrep.cnf\\\'

# 4.查看三個(gè)幾點(diǎn)的配置文件信息
[root@pxc1 ~]#ansible \\\'pxcservers\\\' -a \\\'egrep -v ^#|^$ /etc/percona-xtradb-cluster.conf.d/wsrep.cnf\\\'
[root@pxc1 ~]#ansible \\\'pxcservers\\\' -a \\\'egrep -v ^#|^$ /etc/percona-xtradb-cluster.conf.d/wsrep.cnf\\\'
192.168.7.72 | CHANGED | rc=0 >>
[mysqld]
wsrep_provider=/usr/lib64/galera3/libgalera_smm.so
wsrep_cluster_address=gcomm://192.168.7.71,192.168.7.72,192.168.7.73
binlog_format=ROW
default_storage_engine=InnoDB
wsrep_slave_threads= 8
wsrep_log_conflicts
innodb_autoinc_lock_mode=2
wsrep_node_address=192.168.7.72
wsrep_cluster_name=pxc-cluster
wsrep_node_name=pxc-cluster-node-2
pxc_strict_mode=ENFORCING
wsrep_sst_method=xtrabackup-v2
wsrep_sst_auth=sstuser:123.com

192.168.7.73 | CHANGED | rc=0 >>
[mysqld]
wsrep_provider=/usr/lib64/galera3/libgalera_smm.so
wsrep_cluster_address=gcomm://192.168.7.71,192.168.7.72,192.168.7.73
binlog_format=ROW
default_storage_engine=InnoDB
wsrep_slave_threads= 8
wsrep_log_conflicts
innodb_autoinc_lock_mode=2
wsrep_node_address=192.168.7.73
wsrep_cluster_name=pxc-cluster
wsrep_node_name=pxc-cluster-node-3
pxc_strict_mode=ENFORCING
wsrep_sst_method=xtrabackup-v2
wsrep_sst_auth=sstuser:123.com

192.168.7.71 | CHANGED | rc=0 >>
[mysqld]
wsrep_provider=/usr/lib64/galera3/libgalera_smm.so
wsrep_cluster_address=gcomm://192.168.7.71,192.168.7.72,192.168.7.73
binlog_format=ROW
default_storage_engine=InnoDB
wsrep_slave_threads= 8
wsrep_log_conflicts
innodb_autoinc_lock_mode=2
wsrep_node_address=192.168.7.71
wsrep_cluster_name=pxc-cluster
wsrep_node_name=pxc-cluster-node-1
pxc_strict_mode=ENFORCING
wsrep_sst_method=xtrabackup-v2
wsrep_sst_auth=sstuser:123.com

注：盡管Galera Cluster不再需要通過(guò)binlog的形式進(jìn)行同步，但還是建議在配置文件中開(kāi)啟二進(jìn)制日志功能，原因是后期如果有新節(jié)點(diǎn)需要加入，老節(jié)點(diǎn)通過(guò)SST全量傳輸?shù)姆绞较蛐鹿?jié)點(diǎn)傳輸數(shù)據(jù)，很可能會(huì)拖垮集群性能，所以讓新節(jié)點(diǎn)先通過(guò)binlog方式完成同步后再加入集群會(huì)是一種更好的選擇
4.啟動(dòng)集群中的第一個(gè)節(jié)點(diǎn)

[root@pxc1 ~]#systemctl start mysql@bootstrap.service
[root@pxc1 ~]#systemctl enable mysql@bootstrap.service

# PXC最常使用的端口號(hào)如下，其中3306、4567啟動(dòng)的時(shí)候就會(huì)監(jiān)聽(tīng)
4567：組成員之間進(jìn)行溝通的端口號(hào)
3306：數(shù)據(jù)庫(kù)對(duì)外服務(wù)的端口號(hào)
4444：請(qǐng)求SST的端口號(hào)
4568：用于傳輸IST的端口號(hào)

5.修改初始化密碼，并且創(chuàng)建及授權(quán)sstuser用戶

[root@pxc1 ~]#mysql -p`awk /root@localhost/\\\'{print $NF}\\\' /var/log/mysqld.log`
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \\\\g.
Your MySQL connection id is 22
Server version: 5.7.27-30-57-log

Copyright (c) 2009-2019 Percona LLC and/or its affiliates
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type \\\'help;\\\' or \\\'\\\\h\\\' for help. Type \\\'\\\\c\\\' to clear the current input statement.

mysql> alter user \\\'root\\\'@\\\'localhost\\\' identified by \\\'123.com\\\';
Query OK, 0 rows affected (0.01 sec)

mysql> create user \\\'sstuser\\\'@\\\'localhost\\\' identified by \\\'123.com\\\';
Query OK, 0 rows affected (0.01 sec)

mysql> grant reload,lock tables,process,replication client on *.* to \\\'sstuser\\\'@\\\'localhost\\\';
Query OK, 0 rows affected (0.00 sec)

6.查看相關(guān)的狀態(tài)變量

mysql> show status like \\\'wsrep_cluster_size\\\';
 -------------------- ------- 
| Variable_name      | Value |
 -------------------- ------- 
| wsrep_cluster_size | 1     |
 -------------------- ------- 
1 row in set (0.01 sec)
# 表示該Galera集群中只有一個(gè)節(jié)點(diǎn)

mysql> show status like \\\'wsrep_cluster_status\\\';
 ---------------------- --------- 
| Variable_name        | Value   |
 ---------------------- --------- 
| wsrep_cluster_status | Primary |
 ---------------------- --------- 
1 row in set (0.00 sec)
# 表示該節(jié)點(diǎn)在集群中的狀態(tài)為Primary，且已經(jīng)完全連接并準(zhǔn)備好

mysql> show status like \\\'wsrep_local_state%\\\';
 --------------------------- -------------------------------------- 
| Variable_name             | Value                                |
 --------------------------- -------------------------------------- 
| wsrep_local_state_uuid    | b0fdc391-156e-11ea-89de-331ca2945d2c |
| wsrep_local_state         | 4                                    |
| wsrep_local_state_comment | Synced                               |
 --------------------------- -------------------------------------- 
3 rows in set (0.00 sec)
#狀態(tài)為Synced(4)，表示數(shù)據(jù)已同步完成(因?yàn)槭堑谝粋€(gè)引導(dǎo)節(jié)點(diǎn)，無(wú)數(shù)據(jù)需要同步)。 如果狀態(tài)是Joiner, 意味著 SST 沒(méi)有完成. 只有所有節(jié)點(diǎn)狀態(tài)是Synced，才可以加新節(jié)點(diǎn)

7.啟動(dòng)PXC集群中pxc2,pxc3節(jié)點(diǎn)

[root@pxc1 ~]#ansible \\\'pxcservers:!192.168.7.71\\\' -a \\\'systemctl enable --now mysql\\\'

pxc2主機(jī)
8.查看集群狀態(tài)，驗(yàn)證集群是否成功（也可以是其它任意節(jié)點(diǎn)）

[root@pxc2 ~]#mysql -p123.com
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \\\\g.
Your MySQL connection id is 12
Server version: 5.7.27-30-57-log Percona XtraDB Cluster (GPL), Release rel30, Revision 64987d4, WSREP version 31.39, wsrep_31.39

Copyright (c) 2009-2019 Percona LLC and/or its affiliates
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type \\\'help;\\\' or \\\'\\\\h\\\' for help. Type \\\'\\\\c\\\' to clear the current input statement.

mysql> show variables like \\\'wsrep_node_name\\\';
 ----------------- -------------------- 
| Variable_name   | Value              |
 ----------------- -------------------- 
| wsrep_node_name | pxc-cluster-node-2 |
 ----------------- -------------------- 
1 row in set (0.01 sec)

mysql> show variables like \\\'wsrep_node_address\\\';
 -------------------- -------------- 
| Variable_name      | Value        |
 -------------------- -------------- 
| wsrep_node_address | 192.168.7.72 |
 -------------------- -------------- 
1 row in set (0.00 sec)

mysql> show variables like \\\'wsrep_on\\\';
 --------------- ------- 
| Variable_name | Value |
 --------------- ------- 
| wsrep_on      | ON    |
 --------------- ------- 
1 row in set (0.00 sec)

mysql> show status like \\\'wsrep_cluster_size\\\';
 -------------------- ------- 
| Variable_name      | Value |
 -------------------- ------- 
| wsrep_cluster_size | 3     |
 -------------------- ------- 
1 row in set (0.00 sec)

pxc3主機(jī)
9.創(chuàng)建數(shù)據(jù)庫(kù)（也可以是其它任意節(jié)點(diǎn)）

# 查看當(dāng)前的數(shù)據(jù)庫(kù)
mysql> show databases;
 -------------------- 
| Database           |
 -------------------- 
| information_schema |
| mysql              |
| performance_schema |
| sys                |
 -------------------- 
4 rows in set (0.00 sec)

# 創(chuàng)建db1數(shù)據(jù)庫(kù)
[root@pxc1 ~]#ansible \\\'192.168.7.73\\\' -a \\\'mysql -p123.com -e create database db1;\\\\n\\\'
192.168.7.73 | CHANGED | rc=0 >>
PAGER set to stdoutmysql: [Warning] Using a password on the command line interface can be insecure.

# 查看集群中的其它節(jié)點(diǎn)是否同步新建的db1數(shù)據(jù)庫(kù)
[root@pxc1 ~]#ansible \\\'pxcservers\\\' -a \\\'mysql -p123.com -e show databases\\\\n\\\'
192.168.7.73 | CHANGED | rc=0 >>
PAGER set to stdout
Database
information_schema
db1
mysql
performance_schema
sysmysql: [Warning] Using a password on the command line interface can be insecure.

192.168.7.72 | CHANGED | rc=0 >>
PAGER set to stdout
Database
information_schema
db1
mysql
performance_schema
sysmysql: [Warning] Using a password on the command line interface can be insecure.

192.168.7.71 | CHANGED | rc=0 >>
PAGER set to stdout
Database
information_schema
db1
mysql
performance_schema
sysmysql: [Warning] Using a password on the command line interface can be insecure.

10.在集群中的所有節(jié)點(diǎn)同時(shí)創(chuàng)建db2數(shù)據(jù)庫(kù)，只有一個(gè)節(jié)點(diǎn)會(huì)成功

[root@pxc1 ~]#ansible \\\'pxcservers\\\' -a \\\'mysql -p123.com -e create database db2\\\\n\\\'
192.168.7.73 | FAILED | rc=1 >>
PAGER set to stdoutmysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1007 (HY000) at line 1: Can\\\'t create database \\\'db2\\\'; database existsnon-zero return code

192.168.7.72 | CHANGED | rc=0 >>
PAGER set to stdoutmysql: [Warning] Using a password on the command line interface can be insecure.

192.168.7.71 | FAILED | rc=1 >>
PAGER set to stdoutmysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1007 (HY000) at line 1: Can\\\'t create database \\\'db2\\\'; database existsnon-zero return code

在PXC集群中加入節(jié)點(diǎn)

一個(gè)節(jié)點(diǎn)加入到Galera集群有兩種情況：新節(jié)點(diǎn)加入集群、暫時(shí)離組的成員再次加入集群  
1）節(jié)點(diǎn)加入Galera集群
新節(jié)點(diǎn)加入集群時(shí)，需要從當(dāng)前集群中選擇一個(gè)Donor節(jié)點(diǎn)來(lái)同步數(shù)據(jù)，也就是所謂的
state_snapshot_tranfer(SST)過(guò)程。SST同步數(shù)據(jù)的方式由選項(xiàng)wsrep_sst_method決定，一般選擇的是xtrabackup。必須注意，新節(jié)點(diǎn)加入Galera時(shí)，會(huì)刪除新節(jié)點(diǎn)上所有已有數(shù)據(jù)，再通過(guò)xtrabackup(假設(shè)使用的是該方式)從Donor處完整備份所有數(shù)據(jù)進(jìn)行恢復(fù)。所以，如果數(shù)據(jù)量很大，新節(jié)點(diǎn)加入過(guò)程會(huì)很慢。而且，在一個(gè)新節(jié)點(diǎn)成為Synced狀態(tài)之前，不要同時(shí)加入其它新節(jié)點(diǎn)，否則很容易將集群壓垮。
如果是這種情況，可以考慮使用wsrep_sst_method=rsync來(lái)做增量同步，既然是增量同步，最好保證新節(jié)點(diǎn)上已經(jīng)有一部分?jǐn)?shù)據(jù)基礎(chǔ)，否則和全量同步?jīng)]什么區(qū)別，且這樣會(huì)對(duì)Donor節(jié)點(diǎn)加上全局read only鎖。
2）舊節(jié)點(diǎn)加入Galera集群
如果舊節(jié)點(diǎn)加入Galera集群，說(shuō)明這個(gè)節(jié)點(diǎn)在之前已經(jīng)在Galera集群中呆過(guò)，有一部分?jǐn)?shù)據(jù)基礎(chǔ)，缺少的只是它離開(kāi)集群時(shí)的數(shù)據(jù)。這時(shí)加入集群時(shí)，會(huì)采用IST(incremental snapshot transfer)傳輸機(jī)制，即使用增量傳輸。
但注意，這部分增量傳輸?shù)臄?shù)據(jù)源是Donor上緩存在GCache文件中的，這個(gè)文件有大小限制，如果缺失的數(shù)據(jù)范圍超過(guò)已緩存的內(nèi)容，則自動(dòng)轉(zhuǎn)為SST傳輸。如果舊節(jié)點(diǎn)上的數(shù)據(jù)和Donor上的數(shù)據(jù)不匹配(例如這個(gè)節(jié)點(diǎn)離組后人為修改了一點(diǎn)數(shù)據(jù))，則自動(dòng)轉(zhuǎn)為SST傳輸。

11.在PXC集群中再加一臺(tái)新的主機(jī)PXC4：192.168.7.74
11.1安裝

# 先在ansible主控機(jī)的hosts文件中添加192.168.7.74，然后執(zhí)行以下操作
[root@pxc1 ~]#ansible \\\'192.168.7.74\\\' -m copy -a \\\'src=/etc/yum.repos.d/pxc.repo dest=/etc/yum.repos.d\\\'

[root@pxc1 ~]#ansible \\\'192.168.7.74\\\' -a \\\'yum -y install Percona-XtraDB-Cluster-57\\\'

[root@pxc1 ~]#ansible \\\'192.168.7.74\\\' -m copy -a \\\'src=/etc/percona-xtradb-cluster.conf.d/wsrep.cnf dest=/etc/percona-xtradb-cluster.conf.d\\\'

[root@pxc1 ~]#ansible \\\'192.168.7.74\\\' -a \\\'sed -i -e s/wsrep_node_address=192.168.7.71/wsrep_node_address=192.168.7.74/ -e s/wsrep_node_name=pxc-cluster-node-1/wsrep_node_name=pxc-cluster-node-4/ /etc/percona-xtradb-cluster.conf.d/wsrep.cnf\\\'

[root@pxc1 ~]#ansible 192.168.7.74 -a sed -i \\\'s/^wsrep_cluster_address.*/&,192.168.7.74/\\\' /etc/percona-xtradb-cluster.conf.d/wsrep.cnf

[root@pxc1 ~]#ansible 192.168.7.74 -a \\\'egrep -v ^#|^$ /etc/percona-xtradb-cluster.conf.d/wsrep.cnf\\\'
192.168.7.74 | CHANGED | rc=0 >>
[mysqld]
wsrep_provider=/usr/lib64/galera3/libgalera_smm.so
wsrep_cluster_address=gcomm://192.168.7.71,192.168.7.72,192.168.7.73,192.168.7.74
binlog_format=ROW
default_storage_engine=InnoDB
wsrep_slave_threads= 8
wsrep_log_conflicts
innodb_autoinc_lock_mode=2
wsrep_node_address=192.168.7.74
wsrep_cluster_name=pxc-cluster
wsrep_node_name=pxc-cluster-node-4
pxc_strict_mode=ENFORCING
wsrep_sst_method=xtrabackup-v2
wsrep_sst_auth=sstuser:123.com

11.2啟動(dòng)

[root@pxc1 ~]#ansible 192.168.7.74 -a \\\'systemctl enable --now mysql\\\'

11.3在新加入的節(jié)點(diǎn)中查看集群狀態(tài)

[root@pxc4 ~]#mysql -p123.com
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \\\\g.
Your MySQL connection id is 11
Server version: 5.7.27-30-57-log Percona XtraDB Cluster (GPL), Release rel30, Revision 64987d4, WSREP version 31.39, wsrep_31.39

Copyright (c) 2009-2019 Percona LLC and/or its affiliates
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type \\\'help;\\\' or \\\'\\\\h\\\' for help. Type \\\'\\\\c\\\' to clear the current input statement.

mysql> show status like \\\'wsrep_cluster_size\\\';
 -------------------- ------- 
| Variable_name      | Value |
 -------------------- ------- 
| wsrep_cluster_size | 4     |
 -------------------- ------- 
1 row in set (0.01 sec)

mysql> show databases;
 -------------------- 
| Database           |
 -------------------- 
| information_schema |
| db1                |
| db2                |
| mysql              |
| performance_schema |
| sys                |
 -------------------- 
6 rows in set (0.00 sec)

修改集群中其它節(jié)點(diǎn)的配置文件，將新加入的節(jié)點(diǎn)添加到配置文件中

[root@pxc1 ~]#ansible \\\'pxcservers:!192.168.7.74\\\' -a sed -i \\\'s/^wsrep_cluster_address.*/&,192.168.7.74/\\\' /etc/percona-xtradb-cluster.conf.d/wsrep.cnf

在PXC集群中修復(fù)故障節(jié)點(diǎn)
12.停止集群中任意節(jié)點(diǎn)的mysql服務(wù)，這里停止pxc2

[root@pxc1 ~]#ansible 192.168.7.72 -a \\\'systemctl stop mysql\\\'

13.在集群中的其它任意節(jié)點(diǎn)（這里在pxc3）查看wsrep_cluster_size變量少了一個(gè)節(jié)點(diǎn)

[root@pxc3 ~]#mysql -p123.com
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \\\\g.
Your MySQL connection id is 13
Server version: 5.7.27-30-57-log Percona XtraDB Cluster (GPL), Release rel30, Revision 64987d4, WSREP version 31.39, wsrep_31.39

Copyright (c) 2009-2019 Percona LLC and/or its affiliates
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type \\\'help;\\\' or \\\'\\\\h\\\' for help. Type \\\'\\\\c\\\' to clear the current input statement.

mysql> show status like \\\'wrep_cluster_size\\\';
Empty set (0.00 sec)

mysql> show status like \\\'wrep_cluster_size\\\';
Empty set (0.00 sec)

mysql> show status like \\\'wsrep_cluster_size\\\';
 -------------------- ------- 
| Variable_name      | Value |
 -------------------- ------- 
| wsrep_cluster_size | 3     |
 -------------------- ------- 
1 row in set (0.00 sec)

14.在集群中的其它任意節(jié)點(diǎn)創(chuàng)建db3數(shù)據(jù)庫(kù)（這里在pxc4），然后查看其它節(jié)點(diǎn)是否同步數(shù)據(jù)

[root@pxc4 ~]#mysql -p123.com
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \\\\g.
Your MySQL connection id is 12
Server version: 5.7.27-30-57-log Percona XtraDB Cluster (GPL), Release rel30, Revision 64987d4, WSREP version 31.39, wsrep_31.39

Copyright (c) 2009-2019 Percona LLC and/or its affiliates
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type \\\'help;\\\' or \\\'\\\\h\\\' for help. Type \\\'\\\\c\\\' to clear the current input statement.

mysql> create database db3;
Query OK, 1 row affected (0.01 sec)

[root@pxc1 ~]#ansible pxcservers -a \\\'mysql -p123.com -e show databases;\\\\n\\\'
192.168.7.73 | CHANGED | rc=0 >>
Database
information_schema
db1
db2
db3
mysql
performance_schema
sys
PAGER set to stdoutmysql: [Warning] Using a password on the command line interface can be insecure.

192.168.7.72 | FAILED | rc=1 >>
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2002 (HY000): Can\\\'t connect to local MySQL server through socket \\\'/var/lib/mysql/mysql.sock\\\' (2)non-zero return code

192.168.7.74 | CHANGED | rc=0 >>
Database
information_schema
db1
db2
db3
mysql
performance_schema
sys
PAGER set to stdoutmysql: [Warning] Using a password on the command line interface can be insecure.

192.168.7.71 | CHANGED | rc=0 >>
Database
information_schema
db1
db2
db3
mysql
performance_schema
sys
PAGER set to stdoutmysql: [Warning] Using a password on the command line interface can be insecure.

15.恢復(fù)pxc2的mysql服務(wù)，數(shù)據(jù)同步

[root@pxc1 ~]#ansible 192.168.7.72 -a \\\'systemctl start mysql\\\'
192.168.7.72 | CHANGED | rc=0 >>

[root@pxc1 ~]#ansible 192.168.7.72 -a \\\'mysql -p123.com -e show databases;\\\\n\\\'
192.168.7.72 | CHANGED | rc=0 >>
Database
information_schema
db1
db2
db3
mysql
performance_schema
sys
PAGER set to stdoutmysql: [Warning] Using a password on the command line interface can be insecure.

更多關(guān)于云服務(wù)器，域名注冊(cè)，虛擬主機(jī)的問(wèn)題，請(qǐng)?jiān)L問(wèn)西部數(shù)碼官網(wǎng)：www.ps-sw.cn





猜你還會(huì)喜歡下面的內(nèi)容

• 一般企業(yè)郵箱容量是多少
• 雙十一虛擬主機(jī)購(gòu)買(mǎi)優(yōu)惠券去哪領(lǐng)
• 獨(dú)立IP云虛擬主機(jī)多少錢(qián)
• 多個(gè)網(wǎng)站買(mǎi)虛擬主機(jī)還是云服務(wù)器
• 云虛擬主機(jī)可以安裝寶塔嗎
• 常見(jiàn)的云虛擬主機(jī)有哪些
• 博客系統(tǒng)怎么在云虛擬主機(jī)安裝
• 辦網(wǎng)站沒(méi)有虛擬主機(jī)行嗎
• 便宜的云虛擬主機(jī)一定是好的嗎
• web怎么添加虛擬主機(jī)
• dv ssl怎么放入虛擬主機(jī)
• linux云虛擬主機(jī)如何ssl
• Java程序放在云虛擬主機(jī)嗎
• html云虛擬主機(jī)選什么系統(tǒng)好
• APP為什么不能用云虛擬主機(jī)
• wdcp怎么選云虛擬主機(jī)

熱門(mén)標(biāo)簽

其他問(wèn)題云服務(wù)器問(wèn)題域名及賬戶問(wèn)題企業(yè)郵局市場(chǎng)咨詢云服務(wù)器云建站/云站群/小程序虛擬主機(jī)網(wǎng)絡(luò)知識(shí)企業(yè)郵箱域名注冊(cè)域名備案域名商標(biāo)注冊(cè)云主機(jī)更多標(biāo)簽...

大家感興趣的內(nèi)容