当前位置 博文首页 > m0_37389157的博客:Percona MySQL 8.0版本安装配置教程

    m0_37389157的博客:Percona MySQL 8.0版本安装配置教程

    作者:[db:作者] 时间:2021-08-06 21:57

    #参考下载安装地址
    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 1213 2020 percona-mysql-router-8.0.22-13.1.el7.x86_64.rpm
    -rw-r--r--. 1 root root 1124710400 1214 2020 Percona-Server-8.0.22-13-r6f7822f-el7-x86_64-bundle.tar
    -rw-rw-r--. 1 root root   12543400 1213 2020 percona-server-client-8.0.22-13.1.el7.x86_64.rpm
    -rw-rw-r--. 1 root root  578037968 1213 2020 percona-server-debuginfo-8.0.22-13.1.el7.x86_64.rpm
    -rw-rw-r--. 1 root root    1840352 1213 2020 percona-server-devel-8.0.22-13.1.el7.x86_64.rpm
    -rw-rw-r--. 1 root root   12172080 1213 2020 percona-server-rocksdb-8.0.22-13.1.el7.x86_64.rpm
    -rw-rw-r--. 1 root root   60616400 1213 2020 percona-server-server-8.0.22-13.1.el7.x86_64.rpm
    -rw-rw-r--. 1 root root    1477836 1213 2020 percona-server-shared-8.0.22-13.1.el7.x86_64.rpm
    -rw-rw-r--. 1 root root    1295496 1213 2020 percona-server-shared-compat-8.0.22-13.1.el7.x86_64.rpm
    -rw-rw-r--. 1 root root  450052076 1213 2020 percona-server-test-8.0.22-13.1.el7.x86_64.rpm
    -rw-rw-r--. 1 root root    2039408 1213 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
    安装对应的依赖。
    
    还有其他问题的话可以评论留言
    
    cs