Percona XtraDB Cluster安装

Percona XtractDB Cluster安装

安装环境:

• CentOS 7.6

软件准备:

• Percona XtractDB Cluster5.7下载地址

• percona xtrabackup 2.4下载

• qpress 下载

开始正式的安装

yum install perl openssl-devel perl-DBI libaio net-tools 

开始安装qpress

rpm -ivh rpm -ivh qpress-11-1.el7.x86_64.rpm

开始安装 percona xtrabackup

原则：能用yum就用yum安装，比较方便。自动解决依赖问题。

tar xvf Percona-XtraDB-Cluster-5.7.25-31.35-r463-el7-x86_64-bundle.tar
解压上述的文件之后

rpm -ivh Percona-XtraDB-Cluster-57-debuginfo-5.7.25-31.35.1.el7.x86_64.rpm
rpm -ivh Percona-XtraDB-Cluster-devel-57-5.7.25-31.35.1.el7.x86_64.rpm
rpm -ivh Percona-XtraDB-Cluster-client-57-5.7.25-31.35.1.el7.x86_64.rpm
rpm -ivh Percona-XtraDB-Cluster-garbd-57-5.7.25-31.35.1.el7.x86_64.rpm
rpm -ivh Percona-XtraDB-Cluster-shared-compat-57-5.7.25-31.35.1.el7.x86_64.rpm
rpm -ivh Percona-XtraDB-Cluster-shared-57-5.7.25-31.35.1.el7.x86_64.rpm
rpm -ivh Percona-XtraDB-Cluster-client-57-5.7.25-31.35.1.el7.x86_64.rpm

yum install Percona-XtraDB-Cluster-test-57-5.7.25-31.35.1.el7.x86_64.rpm
yum install Percona-XtraDB-Cluster-server-57-5.7.25-31.35.1.el7.x86_64.rpm
yum install Percona-XtraDB-Cluster-full-57-5.7.25-31.35.1.el7.x86_64.rpm
yum install Percona-XtraDB-Cluster-57-5.7.25-31.35.1.el7.x86_64.rpm

tar xvf Percona-XtraBackup-2.4.14-ref675d4-el7-x86_64-bundle.tar

yum install percona-xtrabackup-24-debuginfo-2.4.14-1.el7.x86_64.rpm
yum install percona-xtrabackup-24-2.4.14-1.el7.x86_64.rpm
yum install percona-xtrabackup-test-24-2.4.14-1.el7.x86_64

报错处理:

解决: 删除这个mariadb 重新安装就好

启动 percona

systemctl start mysql

第一次mysql密码查询

cat /var/log/mysqld.log |grep password

第一次登陆mysql

mysql -uroot -p密码

修改密码

set password for root@localhost = password("123")

开启远程访问

grant all privileges on *.* to 'root'@'%' identified by 'youpassword' with grant option;

修改配置的话，默认是下述的命令

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