Percona MySQL 8.0版本安装配置教程

#参考下载安装地址
https://www.percona.com/doc/percona-server/8.0/installation/yum_repo.html#installing-percona-server-using-downloaded-rpm-packages
 
 
#1.下载MySQL 8.0 仓库
wget https://downloads.percona.com/downloads/Percona-Server-LATEST/Percona-Server-8.0.22-13/binary/redhat/7/x86_64/Percona-Server-8.0.22-13-r6f7822f-el7-x86_64-bundle.tar
 
 
#2.解压对应的安装包
tar xvf Percona-Server-8.0.22-13-r6f7822f-el7-x86_64-bundle.tar
 
#3.查看当前的rpm包有哪些
ls *.rpm
-rw-rw-r--. 1 root root    4626048 12月 13 2020 percona-mysql-router-8.0.22-13.1.el7.x86_64.rpm
-rw-r--r--. 1 root root 1124710400 12月 14 2020 Percona-Server-8.0.22-13-r6f7822f-el7-x86_64-bundle.tar
-rw-rw-r--. 1 root root   12543400 12月 13 2020 percona-server-client-8.0.22-13.1.el7.x86_64.rpm
-rw-rw-r--. 1 root root  578037968 12月 13 2020 percona-server-debuginfo-8.0.22-13.1.el7.x86_64.rpm
-rw-rw-r--. 1 root root    1840352 12月 13 2020 percona-server-devel-8.0.22-13.1.el7.x86_64.rpm
-rw-rw-r--. 1 root root   12172080 12月 13 2020 percona-server-rocksdb-8.0.22-13.1.el7.x86_64.rpm
-rw-rw-r--. 1 root root   60616400 12月 13 2020 percona-server-server-8.0.22-13.1.el7.x86_64.rpm
-rw-rw-r--. 1 root root    1477836 12月 13 2020 percona-server-shared-8.0.22-13.1.el7.x86_64.rpm
-rw-rw-r--. 1 root root    1295496 12月 13 2020 percona-server-shared-compat-8.0.22-13.1.el7.x86_64.rpm
-rw-rw-r--. 1 root root  450052076 12月 13 2020 percona-server-test-8.0.22-13.1.el7.x86_64.rpm
-rw-rw-r--. 1 root root    2039408 12月 13 2020 percona-server-tokudb-8.0.22-13.1.el7.x86_64.rpm
 
#4.安装MySQL
#对于mysql来说我们一般安装下面四个文件就好
rpm -ivh percona-server-server-8.0.22-13.1.el7.x86_64.rpm percona-server-client-8.0.22-13.1.el7.x86_64.rpm percona-server-shared-8.0.22-13.1.el7.x86_64.rpm percona-server-shared-compat-8.0.22-13.1.el7.x86_64.rpm
 
#5.编写my.cnf文件
 
#6.创建必需的文件夹以及授权 根据配置文件中操作
mkdir -p /data/mysql/
mkdir -p /data/logs/
mkdir -p /data/mysql_tmp
chown -R mysql:mysql /data/mysql_tmp
chown -R mysql:mysql /data/mysql
chown -R mysql:mysql /data/logs
 
#7.修改/etc/systemd/system/mysql.service 以及修改文件中open_file_limits的值
mv /etc/systemd/system/mysql.service /etc/systemd/system/mysqld.service
 
# Sets open_files_limit
LimitNOFILE = 10000
#修改为65535
LimitNOFILE = 65535
 
#修改完之后重新reload
systemctl daemon-reload
 
#8. 启动mysqld服务
systemctl start mysqld
 
#9.加入开机自启
systemctl enable mysqld
 
#查看是否加入成功
systemctl list-unit-files |grep mysqld
 
#10.修改MySQL密码
cat /data/logs/mysql-error.log |grep temporary
#用临时密码登录到mysql修改密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的密码';
 
 
#12.将第五步中的配置文件取消注释，然后重新启动mysqld
 
#整理
如果遇到问题
yum install numactl
安装对应的依赖。

还有其他问题的话可以评论留言