6.Percona-XtraDB-Cluster与Percona-XtraBackUp安装

#确保以下端口未被防火墙阻止或其他软件使用。Percona XtraDB集群需要它们进行通信。

iptables -A INPUT -p tcp --dport 3306 -j ACCEPT

iptables -A INPUT -p tcp --dport 4567 -j ACCEPT

iptables -A INPUT -p tcp --dport 4568 -j ACCEPT

iptables -A INPUT -p tcp --dport 4444 -j ACCEPT

iptables -A INPUT -p tcp --dport 4567 -j ACCEPT

iptables -A INPUT -p udp --dport 4567 -j ACCEPT

iptables -A OUTPUT -p tcp --dport 3306 -j ACCEPT

iptables -A OUTPUT -p tcp --dport 4567 -j ACCEPT

iptables -A OUTPUT -p tcp --dport 4568 -j ACCEPT

iptables -A OUTPUT -p tcp --dport 4444 -j ACCEPT

iptables -A OUTPUT -p tcp --dport 4567 -j ACCEPT

iptables -A OUTPUT -p udp --dport 4567 -j ACCEPT

#在SELinux的安全模块可以限制访问，最好解决方案是从改变模式disabled通过运行下面的命令：

setenforce 0

vim /etc/selinux/config

SELINUX=disabled

#安装percona源

sudo yum install http://www.percona.com/downloads/percona-release/redhat/0.1-4/percona-release-0.1-4.noarch.rpm

sudo yum list | grep percona

#安装Percona XtraDB群集包

sudo yum install Percona-XtraDB-Cluster-57

#修改相关配置

vim /etc/percona-xtradb-cluster.conf.d/mysqld.cnf

datadir=/var/lib/mysql/data

#启动服务并初始化数据

/etc/init.d/mysql start --user=mysql

#查询临时生成的密码并以此登陆

sudo grep 'temporary password' /var/log/mysqld.log

mysql -u root -p

#修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '223238';

#创建同步复制帐号

CREATE USER 'sstuser'@'localhost' IDENTIFIED BY '123123';

GRANT RELOAD, LOCK TABLES, PROCESS, REPLICATION CLIENT ON *.* TO 'sstuser'@'localhost';

FLUSH PRIVILEGES;

#查询连接状态

show global status like 'wsrep_cluster_size';

service mysql stop

GRANT ALL PRIVILEGES ON *.* TO clustercheckuser@'localhost' IDENTIFIED BY '223238' WITH GRANT OPTION;

GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'clustercheckuser'@'localhost' IDENTIFIED BY '223238';

GRANT PROCESS ON *.* TO 'clustercheckuser'@'localhost' IDENTIFIED BY '223238';

GRANT ALL PRIVILEGES ON *.* TO codersay@'localhost' IDENTIFIED BY '223238' WITH GRANT OPTION;

GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'codersay'@'localhost' IDENTIFIED BY '223238';

GRANT PROCESS ON *.* TO 'codersay'@'localhost' IDENTIFIED BY '223238';

GRANT ALL PRIVILEGES ON *.* TO root@'localhost' IDENTIFIED BY '223238' WITH GRANT OPTION;

GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'root'@'localhost' IDENTIFIED BY '223238';

GRANT PROCESS ON *.* TO 'root'@'localhost' IDENTIFIED BY '223238';

UPDATE user SET Password = password ( '223238' ) WHERE User = 'root' ;