installing-perconaXTRADB Cluster 5.6

For Redhat 6.4

一、服务器版本查看

Root# cat /etc/redhat-release

Red HatEnterprise Linux Server release 6.4 (Santiago)

二、新建目录：

Root#mkdir -p /softwares

三、下载RPM包

1、下载XTRADBCluster包

wgethttp://www.percona.com/redir/downloads/Percona-XtraDB-Cluster-56/LATEST/RPM/rhel6/x86_/Percona-XtraDB-Cluster-56-5.6.15-25.5.759.rhel6.x86_.rpm

wget http://www.percona.com/redir/downloads/Percona-XtraDB-Cluster-56/LATEST/RPM/rhel6/x86_/Percona-XtraDB-Cluster-56-debuginfo-5.6.15-25.5.759.rhel6.x86_.rpm

wgethttp://www.percona.com/redir/downloads/Percona-XtraDB-Cluster-56/LATEST/RPM/rhel6/x86_/Percona-XtraDB-Cluster-client-56-5.6.15-25.5.759.rhel6.x86_.rpm

wgethttp://www.percona.com/redir/downloads/Percona-XtraDB-Cluster-56/LATEST/RPM/rhel6/x86_/Percona-XtraDB-Cluster-devel-56-5.6.15-25.5.759.rhel6.x86_.rpm

wget http://www.percona.com/redir/downloads/Percona-XtraDB-Cluster-56/LATEST/RPM/rhel6/x86_/Percona-XtraDB-Cluster-full-56-5.6.15-25.5.759.rhel6.x86_.rpm

wgethttp://www.percona.com/redir/downloads/Percona-XtraDB-Cluster-56/LATEST/RPM/rhel6/x86_/Percona-XtraDB-Cluster-galera-3-3.4-1.213.rhel6.x86_.rpm

wgethttp://www.percona.com/redir/downloads/Percona-XtraDB-Cluster-56/LATEST/RPM/rhel6/x86_/Percona-XtraDB-Cluster-galera-3-debuginfo-3.4-1.213.rhel6.x86_.rpm

wgethttp://www.percona.com/redir/downloads/Percona-XtraDB-Cluster-56/LATEST/RPM/rhel6/x86_/Percona-XtraDB-Cluster-server-56-5.6.15-25.5.759.rhel6.x86_.rpm

wgethttp://www.percona.com/redir/downloads/Percona-XtraDB-Cluster-56/LATEST/RPM/rhel6/x86_/Percona-XtraDB-Cluster-shared-56-5.6.15-25.5.759.rhel6.x86_.rpm

wget http://www.percona.com/redir/downloads/Percona-XtraDB-Cluster-56/LATEST/RPM/rhel6/x86_/Percona-XtraDB-Cluster-test-56-5.6.15-25.5.759.rhel6.x86_.rpm

2、下载XTRABACKUP包

wget http://www.percona.com/redir/downloads/XtraBackup/LATEST/RPM/rhel6/x86_/percona-xtrabackup-2.1.9-744.rhel6.x86_.rpm

wget http://www.percona.com/redir/downloads/XtraBackup/LATEST/RPM/rhel6/x86_/ percona-xtrabackup-debuginfo-2.1.9-744.rhel6.x86_.rpm

wget

http://www.percona.com/redir/downloads/XtraBackup/LATEST/RPM/rhel6/x86_/ percona-xtrabackup-test-2.1.9-744.rhel6.x86_.rpm

四、安装依赖包

1、安装包准备

安装光盘package目录下：perl-DBD-MySQL-4.013-3.el6.x86_.rpm

wget http://apt.sw.be/redhat/el6/en/x86_/rpmforge/RPMS/socat-1.7.2.4-1.el6.rf.x86_.rpm

wget

http://mirror.centos.org/centos/6/os/x86_/Packages/nc-1.84-22.el6.x86_.rpm

2、安装

rpm -ivh perl-DBD-MySQL-4.013-3.el6.x86_.rpm socat-1.7.2.4-1.el6.rf.x86_.rpmnc-1.84-22.el6.x86_.rpm

五、删除原有软件包

rpm -qa | grepmysql | xargs sudo rpm -e --nodeps

六、安装

1、安装percona-xtrabackup

rpm -ivhpercona-xtrabackup-2.1.9-744.rhel6.x86_.rpm

2、安装Percona-XtraDB-Cluster-galera

rpm -ivhPercona-XtraDB-Cluster-galera-3-3.5-1.216.rhel6.x86_.rpmPercona-XtraDB-Cluster-galera-3-debuginfo-3.5-1.216.rhel6.x86_.rpm

3、安装Percona-XtraDB-Cluster-client

rpm -ivhPercona-XtraDB-Cluster-client-56-5.6.15-25.5.759.rhel6.x86_.rpm

4、安装Percona-XtraDB-Cluster-server

rpm -ivhPercona-XtraDB-Cluster-server-56-5.6.15-25.5.759.rhel6.x86_.rpm

七、修改配置文件

find / -name 'my-default.cnf'

cp my-default.cnf /etc/my.cnf

八、Cluster配置

在配置文件中增加如下部分：(/etc/my.cnf)

Percona XtraDB Cluster Documentation, Release 5.6.15-25.5

[mysqld]

datadir=/var/lib/mysql

user=mysql

# Path to Galera library

wsrep_provider=/usr/lib/libgalera_smm.so

# Cluster connection URL contains the IPs of node#1,node#2 and node#3

wsrep_cluster_address=gcomm://192.168.70.71,192.168.70.72,192.168.70.73

# In order for Galera to work correctly binlog formatshould be ROW

binlog_format=ROW

# MyISAM storage engine has only experimental support

default_storage_engine=InnoDB

# This changes how InnoDB autoincrement locks are managedand is a requirement for Galera

innodb_autoinc_lock_mode=2

# Node #1 address

wsrep_node_address=192.168.70.71 # 本机IP地址

# SST method

wsrep_sst_method=xtrabackup-v2

# Cluster name

wsrep_cluster_name=my_centos_cluster

# Authentication for SST method

wsrep_sst_auth="sstuser:s3cret"

注：其他节点配置文件同上，注意wsrep_node_address=192.168.70.71 # 本机IP地址。

在第一个节点上执行：

mysql@percona1> CREATE USER 'sstuser@'localhost'IDENTIFIED BY 's3cret';

mysql@percona1> GRANT RELOAD, LOCK TABLES, REPLICATIONCLIENT ON

*.* TO 'sstuser'@'localhost';

mysql@percona1> FLUSH PRIVILEGES;

九、启动

第一个节点：/etc/init.d/mysql bootstrap-pxc

其他节点： /etc/init.d/mysqlstart

十、更改root口令并授权从任何主机访问

登录mysql:

Mysql -u root –p

Mysql>

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY'mysql' WITH GRANT OPTION;