因为MySQL 8.0.x版本即将于2026年4月结束服务支持，计划将手头MySQL 8.0.35升级到MySQL 8.4.8这个LTS版本. 下面是之前在测试环境的一些测试总结.仅供参考!
注意：之前官方只提供了MySQL 8.4.5,所以下面测试案例为MySQL 8.4.5,生产环境建议升级到8.4.8 LTS这个版本. 两者升级方式其实是一样的.
升级到MySQL 8.4.5有下面三种方式.我们打算以In-Place方式直接升级到MySQL8.4.5。- There are three main ways to upgrade MySQL; read the associated documentation to determine which type of upgrade is best suited for your situation.- An in-place upgrade: replacing the MySQL Server packages.- A logical upgrade: exporting SQL from the old MySQL instance to the new.- A replication topology upgrade: account for each server's topology role.
MySQL 8.4.*支持的平台可查看官方文档，官方文档位置：
https://www.mysql.com/support/supportedplatforms/database.html
当前的操作系统平台为RHEL 8.10, MySQL 8.4是支持的.- $ more /etc/redhat-release Red Hat Enterprise Linux release 8.10 (Ootpa)
- mysql-8.4.5-linux-glibc2.28-x86_64-minimal.tar.xzmysql-shell-8.4.5-linux-glibc2.28-x86-64bit.tar.gzmysql-router-8.4.5-linux-glibc2.28-x86_64.tar.xzmysql-shell-8.4.5-1.el8.x86_64.rpm
环境检查
检查数据库版本
- mysql> select @@version;+-----------+| @@version |+-----------+| 8.0.35 |+-----------+1 row in set (0.01 sec)mysql>
- $ mysqlsh --versionmysqlsh Ver 8.0.35 for Linux on x86_64 - for MySQL 8.0.35 (MySQL Community Server (GPL))
MySQL Shell升级
首先,你应该判断MySQL Shell的安装方式, 然后根据安装方式(二进制包/源码/RPM包)选择下载对应的MySQL Shell安装介质. 如果没有安装MySQL Shell,则直接跳过这一步.- $ rpm -qa | grep mysql-shellmysql-shell-8.0.35-1.el8.x86_64
备份Shell配置文件（如~/.mysqlsh/目录）
~/.mysqlsh
RMP包升级
不同的Linux发行版本,可能使用不同的安装方式- sudo rpm -Uvh mysql-shell-.rpm (RHEL)sudo dpkg -i mysql-shell_.deb (Debian)
- rpm -Uvh mysql-shell-8.4.5-1.el8.x86_64.rpm或sudo rpm -Uvh mysql-shell-8.4.5-1.el8.x86_64.rpm
- $ mysqlsh --versionmysqlsh Ver 8.4.5 for Linux on x86_64 - for MySQL 8.4.5 (MySQL Community Server (GPL))
解压MySQL Shell的二进制包到指定目录(/opt/mysql/)- tar -xvf mysql-shell-8.4.5-linux-glibc2.28-x86-64bit.tar.gz -C /opt/mysql/cd /opt/mysql/mv mysql-shell-8.4.5-linux-glibc2.28-x86-64bit mysqlsh
- export PATH=$PATH:/opt/mysql/mysqlsh/bin
- $ cd /opt/mysql/$ mv mysqlsh mysqlsh.20260120$ cd /data/soft/$ tar -xvf mysql-shell-8.4.5-linux-glibc2.28-x86-64bit.tar.gz -C /opt/mysql$ cd /opt/mysql/$ mv mysql-shell-8.4.5-linux-glibc2.28-x86-64bit mysqlsh
使用MySQL Shell检查升级具体事项,如下例子所示:- MySQL dbtest04:3306 ssl SQL > util.checkForServerUpgrade();ERROR: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'util.checkForServerUpgrade()' at line 1 MySQL dbtest04:3306 ssl SQL > MySQL dbtest04:3306 ssl SQL > MySQL dbtest04:3306 ssl SQL > MySQL dbtest04:3306 ssl SQL > MySQL dbtest04:3306 ssl SQL > \jsSwitching to JavaScript mode... MySQL dbtest04:3306 ssl JS > util.checkForServerUpgrade()The MySQL server at dbtest04:3306, version 8.0.33 - MySQL Community Server -GPL, will now be checked for compatibility issues for upgrade to MySQL 8.4.4.To check for a different target server version, use the targetVersion option.1) Removed system variables (removedSysVars) No issues found2) System variables with new default values (sysVarsNewDefaults) Warning: Following system variables that are not defined in your configuration file will have new default values. Please review if you rely on their current values and if so define them before performing upgrade. binlog_transaction_dependency_tracking - default value will change from COMMIT_ORDER to WRITESET. group_replication_consistency - default value will change from EVENTUAL to BEFORE_ON_PRIMARY_FAILOVER. group_replication_exit_state_action - default value will change from READ_ONLY to OFFLINE_MODE. innodb_adaptive_hash_index - default value will change from ON to OFF. innodb_buffer_pool_in_core_file - default value will change from ON to OFF. innodb_buffer_pool_instances - default value will change from 8 (or 1 if innodb_buffer_pool_size < 1GB) to MAX(1, #vcpu/4). innodb_change_buffering - default value will change from all to none. innodb_doublewrite_files - default value will change from innodb_buffer_pool_instances * 2 to 2. innodb_doublewrite_pages - default value will change from innodb_write_io_threads to 128. innodb_flush_method - default value will change from fsynch (unix) or unbuffered (windows) to O_DIRECT. innodb_io_capacity - default value will change from 200 to 10000. innodb_io_capacity_max - default value will change from 200 to 2 x innodb_io_capacity. innodb_log_buffer_size - default value will change from 16777216 (16MB) to 67108864 (64MB). innodb_log_writer_threads - default value will change from ON to OFF ( if #vcpu xa recover;Empty set (0.00 sec)
If results are returned, either commit or rollback the XA transactions by issuing an XA COMMIT or XA ROLLBACK statement.
这一步感觉没有必要处理, 一般来说,我都会跳过.官方文档建议将此参数innodb_fast_shutdown调整为2- SET GLOBAL innodb_fast_shutdown = 1; -- fast shutdownSET GLOBAL innodb_fast_shutdown = 0; -- slow shutdownSET GLOBAL innodb_fast_shutdown = 2; -- cold shutdown
- sudo systemctl stop mysqld.service或mysqladmin -u root -p shutdownsudo systemctl status mysqld.service
- $ tar -xvf mysql-8.4.5-linux-glibc2.28-x86_64.tar.xz -C /opt/mysql/$ cd /opt/mysql/$ unlink mysql8.0$ ln -s /opt/mysql/mysql-8.4.5-linux-glibc2.28-x86_64 mysql8
下面是安装之前的文件信息.- $ ls -lrt /opt/mysql/total 0drwxrwxr-x 9 mysql mysql 129 Mar 1 2024 mysql-8.0.35-linux-glibc2.28-x86_64lrwxrwxrwx 1 mysql mysql 46 Mar 1 2024 mysql8.0 -> /opt/mysql/mysql-8.0.35-linux-glibc2.28-x86_64
- $ vi ~/.bash_profile# .bash_profile# Get the aliases and functionsif [ -f ~/.bashrc ]; then . ~/.bashrcfi# User specific environment and startup programs#export PATH=$PATH:/opt/mysql/mysql8.0/binexport PATH=$PATH:/opt/mysql/mysql8/binexport MYSQL_HISTFILE=/dev/null
- vi /usr/lib/systemd/system/mysqld.service调整前:# Start main serviceExecStart=/opt/mysql/mysql8.0/bin/mysqld --defaults-file=/data/mysql/conf/my.cnf $MYSQLD_OPTS调整后# Start main serviceExecStart=/opt/mysql/mysql8/bin/mysqld --defaults-file=/data/mysql/conf/my.cnf $MYSQLD_OPTS
- $ grep 8.0 my.cnf basedir=/opt/mysql/mysql8.0plugin_dir=/opt/mysql/mysql8.0/lib/plugin lc-messages-dir=/opt/mysql/mysql8.0/share#MySQL8.0就是这么做的，在设置了--skip-grant-tables参数的同时会自动开启--skip-networking。
- $ grep 'mysql8' my.cnf basedir=/opt/mysql/mysql8plugin_dir=/opt/mysql/mysql8/lib/plugin lc-messages-dir=/opt/mysql/mysql8/share
- sudo systemctl start mysqld.service
- # rpm -Uvh percona-xtrabackup-84-8.4.0-3.1.el8.x86_64.rpmwarning: percona-xtrabackup-84-8.4.0-3.1.el8.x86_64.rpm: Header V4 RSA/SHA512 Signature, key ID 8507efa5: NOKEYerror: Failed dependencies: percona-xtrabackup-80 conflicts with percona-xtrabackup-84-8.4.0-3.1.el8.x86_64# rpm -evh percona-xtrabackup-80.x86_64Preparing... ################################# [100%]Cleaning up / removing... 1:percona-xtrabackup-80-8.0.35-30.1################################# [100%]#yum localinstall percona-xtrabackup-84-8.4.0-3.1.el8.x86_64.rpm
在/etc/zabbix/zabbix_agentd.d中更新模板template_db_mysql.conf 中的配置信息.
扫描上面二维码关注我如果你真心觉得文章写得不错，而且对你有所帮助，那就不妨帮忙“推荐"一下，您的“推荐”和”打赏“将是我最大的写作动力！本文版权归作者所有，欢迎转载，但未经作者同意必须保留此段声明，且在文章页面明显位置给出原文连接.
来源：程序园用户自行投稿发布，如果侵权，请联系站长删除
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！ |
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
千斤顶
照妖镜
