Shulou(Shulou.com)06/01 Report--

Article reference: https://www.cnblogs.com/zejin2008/p/5475285.htmlyum Installation: wget https://www. percona. com/downloads/Percona-XtraDB-Cluster-LATEST/Percona-XtraDB-Cluster-5.7.24 - 31.33/bin ary/redhat/6/x86_64/Percona-XtraDB-Cluster-5.7.24 - 31.33-r443-el6-x86_64-bundle. tar Binary installation:·ssl100: for Debian prior to 9 and Ubuntu prior to 14.04 versions·ssl101: for CentOS 6 and CentOS 7·ssl102: for Debian 9 and Ubuntu versions starting from 14.04wget https://www.percona.com/downloads/Percona-XtraDB-Cluster-LATEST/Percona-XtraDB-Cluster-5.7.24-31.33/binary/tarball/Percona-XtraDB-Cluster-5.7.24-rel26-31.33.1.Linux.x86_64.ssl100.tar.gz·3306 is used for MySQL client connections and SST (State Snapshot Transfer) via mysqldump.·4444 is used for SST via rsync and Percona XtraBackup.·4567 is used for write-set replication traffic (over TCP) and multicast replication (over TCP and UDP).· 4568 is used for IST (Incremental State Transfer). Test environment deployment: 192.168.1.221, 192.168.1.222, 192.168.1.223 Environment Preparation All nodes are configured as follows: mkdir-p/data/mysql/3307/{binlog,conf,data,log,pid,socket, tmp}chown-R mysql.mysql/data/mysqlmv Percona-XtraDB-Cluster-5.7.24-rel26-31.33.1.Linux.x86_64.ssl101/usr/local/Percona-XtraDB-Cluster-5.7.24 Each node needs to follow the xtrabackup tool, otherwise the next two nodes cannot start wget www.example.com-ivh percona-release-1.0 - 7.noarch.rpmyum-y install percona-xtrabackup-24.x86_64 If an error is reported: Requires: libev.so.4 ()(64 bit): wget www.example.com rpm-ivh libev-4.04 - 2.el6.x86_64.rpm At the same time, the version should match, percona-xtrabackup-80 - 8.0.5 only use percona 8.0 to install socat on each node, socat version should be above 1.7.3 yum install socat or wget www.example.com configure && make && make install192.168.1.221 Modify the configuration file and add the following: wsrep_provider =/usr/local/Percona-XtraDB-Cluster-5.7.24/lib/libgalera_smm. sowsrep_cluster_name = pxc-clusterwsrep_cluster_address = gcomm://192.168.1.221,192.168.1.222, 192.168.1.223wrep_node_name = pxc1wrep_node_address = 192.168.1.221wrep_sstd_method = xtrabackup-v2 wsrep_sst_auth = sstuser: passw0rdpxc_strict_mode = ENFORCINGbinlog_format = ROWdefault_storage_engine = InnoDBinnodb_autoinc_lock_mode = 2192.168.1.222 The modified profile added per 192.168.1.221 is as follows:....... wsrep_node_name=pxc2wsrep_node_address=192.168.1.222........ 192.168.1.222 The modified profile added by 192.168.1.221 is as follows: ................................................................................................... wsrep_node_name=pxc3wsrep_node_address=192.168.1.223........ First node of cluster: Initializing:/usr/local/Percona-XtraDB-Cluster-5.7.24/bin/mysqld--defaults-file =/data/mysql/3307/conf/my. cnf--user = mysql--initialize Start, Start the first node in the cluster with options--wrep-new-cluster/usr/local/Percona-XtraDB-Cluster-5.7.24/bin/mysqld_safe--defaults-file =/data/mysql/3307/conf/my. cnf--user = mysql--wrep-new-cluster & authorize CREATE USER 'sstuser '@'localhost'IDENTIFIED BY 'passw0rd';GRANT RELOAD, LOCK TABLES, PROCESS, REPLICATION CLIENT ON *.* TO 'sstuser'@'localhost'; nodes 222, 223:/usr/local/Percona-XtraDB-Cluster-5.7.24/bin/mysqld--defaults-file =/data/mysql/3307/conf/my. cnf--user = mysql--initialize/usr/local/Percona-XtraDB-Cluster-5.7.24/bin/mysqld_safe--defaults-file =/data/mysql/3307/conf/my. cnf--user = mysql &

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.