Percona-xtradb-cluster Compilation Installation Error

Error One:

2018-06-28t07:32:12.527956z 0 [ERROR] wsrep:failed to open Gcomm backend connection:110:failed to reach p
Rimary view:110 (Connection timed out)
At Gcomm/src/pc.cpp:connect (): 158
2018-06-28t07:32:12.527974z 0 [ERROR] Wsrep:gcs/src/gcs_core.cpp:gcs_core_open (): 208:failed to open Backen
D Connection: -110 (Connection timed out)
2018-06-28t07:32:12.528057z 0 [ERROR] Wsrep:gcs/src/gcs.cpp:gcs_open (): 1513:failed to open channel ' SJBPXC
' At ' gcomm://192.168.1.210:6600,192.168.1.210:6602 ': -110 (Connection timed out)
2018-06-28t07:32:12.528072z 0 [ERROR] Wsrep:gcs connect failed:connection timed out
2018-06-28t07:32:12.528081z 0 [ERROR] Wsrep:provider/node (gcomm://192.168.1.210:6600,192.168.1.210:6602) F
Ailed to establish connection with cluster (REASON:7)
2018-06-28t07:32:12.528086z 0 [ERROR] aborting

Solve:

PXC node joins the cluster, the address of the cluster is not correct or the port of the PXC node is wrong
Failed to open channel ' PXC ' @ ' gcomm://192.168.1.210:6600,192.168.1.210:6602 ': -110 (Connection timed out)
Tip I can't join PXC this cluster, view my.cnf configuration file Changes wsrep_cluster_address= ' gcomm://192.168.1.210:6630,192.168.1.210:6632 '
The address of this cluster to fill the address of the PXC node to communicate with each other, can not fill in the MySQL service address, the default address is the listening address is 4567

Error Two:

How to resolve can ' t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock '
First uninstall the Linux comes with MySQL, delete the related files

Rpm-qa | grep MySQL (note case, if MySQL does not change MySQL)
Yum-y Remove MySQL Package name
Data and/ETC/MY.CNF in/var/lib/mysql will not be removed after uninstallation, and will be removed manually if determined to be useless.

Rm-f/etc/my.cnf
Rm-rf/var/lib/mysql
Installing Xtrabackup

RPM-IVH percona-xtrabackup-24-2.4.3-1.el7.x86_64.rpm
You may receive the following error message:

Failed dependencies:
Libev.so.4 () (64bit) is needed by percona-xtrabackup-24-2.4.3-1.el7.x86_64
Perl (Dbd::mysql) is needed by percona-xtrabackup-24-2.4.3-1.el7.x86_64

(1) Solving Perl (Dbd::mysql):

Yum Install-y Perl-dbd-mysql
(2) Solve libev.so.4 (64bit)
You can go to the rpmfind.net search system to download and install the RPM package

wget ftp://rpmfind.net/linux/dag/redhat/el6/en/x86_64/dag/RPMS/libev-4.15-1.el6.rf.x86_64.rpm
OK, Installation complete
Using Xtrabackup Backup

Innobackupex--user=root--password=pengyuanzhi--socket=/var/lib/mysql/mysql.sock/root
(1) Can ' t locate digest/md5.pm in @INC (@INC contains:/usr/local/lib64/perl5/usr/local/share/perl5/usr/lib64/perl5/ Vendor_perl/usr/share/perl5/vendor_perl/usr/lib64/perl5/usr/share/perl5.) At-line 693.
. PM is actually a Perl package, just install the following package:

Yum-y Install PERL-DIGEST-MD5

Error Three:

[ERROR] Can ' t start server:bind on TCP/IP port:address already in use
[ERROR] Do you already has another MYSQLD server running on port:3306?

Solve:

To see if Port 3306 is occupied, view the MY.CNF configuration file
wsrep_sst_receive_address=192.168.1.210:6622
Wsrep_provider_options = "gmcast.listen_addr=tcp://192.168.1.210:6632;ist.recv_addr=192.168.1.210:6633;"
Cannot conflict with MySQL service port

Percona-xtradb-cluster Compilation Installation Error