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
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
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/217234.html原文链接:https://javaforall.net
