http://www.dbhelp.net/2017/01/06/pxc-5-7-14-%E5%AE%89%E8%A3%85%E9%83%A8%E7%BD%B2-pxc-install.html
PXC是Percona XtraDB Cluster的缩写,是一种具有高可用性和高扩展性的MySQL开源集群。它集成了Percona Server和Percona XtraBackup,同时采用了Codership Galera库。
常见的PXC架构如下,
PXC架构
下面,开始安装PXC 5.7.14
一、环境说明
主机
1
2
3
4
# PXC #
10.9.15.111pxc1
10.9.15.112pxc2
10.9.15.113pxc3
OS : CentOS release 6.5 (Final)
二、安装 Percona-XtraDB-Cluster
1、卸载CentOS 自带的mysql-libs包
1
rpm-qa|grep-imysql|xargs sudo rpm-e--nodeps
2、所有节点安装依赖包
1
2
3
4
5
6
7
libev-4.03-3.el6.x86_64.rpm
socat-1.7.2.3-1.el6.x86_64.rpm
Percona-XtraDB-Cluster-shared-57-5.7.14-26.17.1.el6.x86_64.rpm
Percona-XtraDB-Cluster-server-57-5.7.14-26.17.1.el6.x86_64.rpm
Percona-XtraDB-Cluster-client-57-5.7.14-26.17.1.el6.x86_64.rpm
Percona-XtraDB-Cluster-57-5.7.14-26.17.1.el6.x86_64.rpm
percona-xtrabackup-24-2.4.4-1.el6.x86_64.rpm
所有节点安装软件包的步骤
1
2
3
4
5
6
7
8
9
yum-yinstall perl-Time-HiRes
yum install–yperl-DBD-MySQL.x86_64 perl-IO-Socket-SSL.noarch nc
yum localinstall libev-4.03-3.el6.x86_64.rpm
yum localinstall socat-1.7.2.3-1.el6.x86_64.rpm
yum localinstall Percona-XtraDB-Cluster-client-57-5.7.14-26.17.1.el6.x86_64.rpm
yum localinstall Percona-XtraDB-Cluster-shared-57-5.7.14-26.17.1.el6.x86_64.rpm
yum localinstall percona-xtrabackup-24-2.4.4-1.el6.x86_64.rpm
yum localinstall Percona-XtraDB-Cluster-server-57-5.7.14-26.17.1.el6.x86_64.rpm
yum localinstall Percona-XtraDB-Cluster-57-5.7.14-26.17.1.el6.x86_64.rpm
3、所有节点创建mysql组和用户
1
2
# groupadd mysql
# useradd -r -g mysql -s /bin/false mysql
4、创建相关目录
1
2
# mkdir /data/mysql/{data,logs,tmp} -p
# chown mysql.mysql /data/ -R
5、配置my.cnf文件
1
2
3
find/-name'my-default.cnf'
/usr/share/doc/Percona-XtraDB-Cluster-server-57-5.7.14/my-default.cnf
/usr/share/percona-xtradb-cluster/my-default.cnf
拷贝到/etc/my.cnf
1
cp/usr/share/percona-xtradb-cluster/my-default.cnf/etc/my.cnf
编辑my.cnf
@第一节点 pxc1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
[mysqld]
user=mysql
innodb_buffer_pool_size=1024M
datadir=/data/mysql/data
port=3306
server_id=3306111
socket=/data/mysql/mysql.sock
pid-file=/data/mysql/logs/mysql.pid
log-error=/data/mysql/logs/error.log
log_warnings=2
slow_query_log_file=/data/mysql/logs/slow.log
long_query_time=0.1
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
## pxc variables ##
# Path to Galera library
wsrep_provider=/usr/lib64/libgalera_smm.so
# Cluster connection URL contains the IPs of node#1, node#2 and node#3
wsrep_cluster_address=gcomm://10.9.15.111,10.9.15.112,10.9.15.113
# In order for Galera to work correctly binlog format should be ROW
binlog_format=ROW
# MyISAM storage engine has only experimental support
default_storage_engine=InnoDB
# This InnoDB autoincrement locking mode is a requirement for Galera
innodb_autoinc_lock_mode=2
# Node name
wsrep_node_name=pxc1
# Node 1 address
wsrep_node_address=10.9.15.111
# SST method
wsrep_sst_method=xtrabackup-v2
# Cluster name
wsrep_cluster_name=my-pxc-test
# Authentication for SST method
wsrep_sst_auth="sstuser:sstuser"
@第二节点 pxc2
注意修改 server_id 、wsrep_node_name 、 wsrep_node_address
1
2
3
4
5
6
7
8
9
10
11</