MariaDB升级 10.1.41 → 10.5.24

原始环境MariaDB版本

1
mysql  Ver 15.1 Distrib 10.1.41-MariaDB, for Linux (x86_64) using readline 5.1

原始环境MariaDB相关包

1
2
3
4
5
MariaDB-devel-10.1.41-1.el7.centos.x86_64
MariaDB-common-10.1.41-1.el7.centos.x86_64
MariaDB-client-10.1.41-1.el7.centos.x86_64
MariaDB-server-10.1.41-1.el7.centos.x86_64
MariaDB-shared-10.1.41-1.el7.centos.x86_64

升级包准备

1
2
3
4
5
6
7
8
9
MariaDB-common-10.5.24-1.el7.centos.x86_64
MariaDB-compat-10.5.24-1.el7.centos.x86_64
MariaDB-shared-10.5.24-1.el7.centos.x86_64
MariaDB-server-10.5.24-1.el7.centos.x86_64
MariaDB-client-10.5.24-1.el7.centos.x86_64
MariaDB-devel-10.5.24-1.el7.centos.x86_64
galera-4-26.4.16-1.el7.centos.x86_64.rpm
socat-1.7.3.2-2.el7.x86_64.rpm
pcre2-10.23-2.el7.x86_64.rpm

升级过程：

1.停用当前MariaDB服务

1
systemctl stop mariadb

2.安装新的升级包

1
2
cd MariaDB10.5.24/
rpm -Uvh *.rpm

3.MariaDB-server没有被成功安装，需要手动卸载后安装

1
rpm --nodeps -ev MariaDB-server-10.1.41-1.el7.centos

4.安装并启动新服务

1
2
rpm -Uvh MariaDB-server-10.5.24-1.el7.centos.x86_64.rpm 
systemctl start mariadb

5.升级数据库系统表

1
mysql_upgrade -h 127.0.0.1 -uroot -pPASSWORD

6.验证升级结果

1
2
[root@localhost ~]# mysql -V
mysql  Ver 15.1 Distrib 10.5.24-MariaDB, for Linux (x86_64) using readline 5.1
mariadb > MySQL
#mariadb #MySQL
MariaDB升级 10.1.41 → 10.5.24
http://maitianxin.github.io/2024/05/07/mysql/mariadb_upgrade/
作者
Matianxin
发布于
2024年5月7日
许可协议