一。关闭防火墙和selinux
systemctl stop firewalld
systemctl disable firewalld
setenforce 0
二。本地地址解析
三。下载PXC包,并且进行安装
wget https://repo.percona.com/yum/release/7/RPMS/x86_64/qpress-11-1.el7.x86_64.rpm
yum localinstall *.rpm -y
四。配置mysql文件
systemctl start mysqld
五。在mysql上面创建用户并且授权
CREATE USER 'admin'@'%' IDENTIFIED WITH mysql_native_password BY 'Abc_123456'; GRANT all privileges ON *.* TO 'admin'@'%';
六。在所有节点上编辑 vi /etc/my.cnf.d/mysql-server.cnf 文件,添加以下内容:
七。在pxc1进行节点拷贝
scp /var/lib/mysql/*.pem pxc2:/var/lib/mysql/
scp /var/lib/mysql/*.pem pxc3:/var/lib/mysql/
八。修改权限
chown -R mysql.mysql /var/lib/mysql/
systemctl start mysqld
九。下载haproxy
yum install haproxy -y
十。配置haproxy:vi /etc/haproxy/haproxy.cfg
systemctl start haproxy
systemctl enable haproxy
十一。下载keepalived
yum install keepalived -y
systemctl start keepalived
systemctl enable keepalived