mysql卸载安装pxc_PXC 5.7.14 安装部署

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</