In order to upgrade mariadb to the latest on a Centos server, you need to configure a new repo for the mariadb"
/etc/yum.repos.d/mariadb.repo
# MariaDB 10.5 CentOS repository list - created 2021-02-23 06:13 UTC
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.5/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
Once the repo is configured, you need to run the yum upgrade mariadb command in the ssh console:
In below case the old mariadb 5.5 was replaced with 10.5.9
yum upgrade mariadb
Loaded plugins: fastestmirror, ovl, product-id, search-disabled-repos, subscription-manager
This system is not registered with an entitlement server. You can use subscription-manager to register.
Loading mirror speeds from cached hostfile
* base: reflector.westga.edu
* eApps: repo001.vm.eapps.com
* epel: de.download.ispsystem.com
* extras: mirror.jaleco.com
* ispsystem-5.286: de.download.ispsystem.com
* ispsystem-base: de.download.ispsystem.com
* remi: mirror.team-cymru.com
* remi-php72: mirror.team-cymru.com
* remi-safe: mirror.team-cymru.com
* updates: mirror.linux.duke.edu
mariadb | 2.9 kB 00:00:00
mariadb/primary_db | 71 kB 00:00:00
Resolving Dependencies
There are unfinished transactions remaining. You might consider running yum-complete-transaction, or "yum-complete-transaction --cleanup-only" and "yum history redo last", first to finish them. If those don't work you'll have to try removing/installing packages by hand (maybe package-cleanup can help).
--> Running transaction check
---> Package MariaDB-client.x86_64 0:10.5.9-1.el7.centos will be obsoleting
--> Processing Dependency: MariaDB-common for package: MariaDB-client-10.5.9-1.el7.centos.x86_64
--> Processing Dependency: libpcre2-8.so.0()(64bit) for package: MariaDB-client-10.5.9-1.el7.centos.x86_64
---> Package mariadb.x86_64 1:5.5.68-1.el7 will be obsoleted
--> Processing Dependency: mariadb(x86-64) = 1:5.5.68-1.el7 for package: 1:mariadb-server-5.5.68-1.el7.x86_64
--> Running transaction check
---> Package MariaDB-common.x86_64 0:10.5.9-1.el7.centos will be installed
--> Processing Dependency: MariaDB-compat for package: MariaDB-common-10.5.9-1.el7.centos.x86_64
---> Package MariaDB-server.x86_64 0:10.5.9-1.el7.centos will be obsoleting
--> Processing Dependency: galera-4 for package: MariaDB-server-10.5.9-1.el7.centos.x86_64
---> Package mariadb-server.x86_64 1:5.5.68-1.el7 will be obsoleted
---> Package pcre2.x86_64 0:10.23-2.el7 will be installed
--> Running transaction check
---> Package MariaDB-compat.x86_64 0:10.5.9-1.el7.centos will be obsoleting
---> Package galera-4.x86_64 0:26.4.7-1.el7.centos will be installed
--> Processing Dependency: socat for package: galera-4-26.4.7-1.el7.centos.x86_64
--> Processing Dependency: libboost_program_options-mt.so.1.53.0()(64bit) for package: galera-4-26.4.7-1.el7.centos.x86_64
---> Package mariadb-libs.x86_64 1:5.5.68-1.el7 will be obsoleted
--> Running transaction check
---> Package boost-program-options.x86_64 0:1.53.0-28.el7 will be installed
---> Package socat.x86_64 0:1.7.3.2-2.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=============================================================================================================================================================================================================================================
Package Arch Version Repository Size
=============================================================================================================================================================================================================================================
Installing:
MariaDB-client x86_64 10.5.9-1.el7.centos mariadb 13 M
replacing mariadb.x86_64 1:5.5.68-1.el7
MariaDB-compat x86_64 10.5.9-1.el7.centos mariadb 2.2 M
replacing mariadb-libs.x86_64 1:5.5.68-1.el7
MariaDB-server x86_64 10.5.9-1.el7.centos mariadb 26 M
replacing mariadb-server.x86_64 1:5.5.68-1.el7
Installing for dependencies:
MariaDB-common x86_64 10.5.9-1.el7.centos mariadb 81 k
boost-program-options x86_64 1.53.0-28.el7 base 156 k
galera-4 x86_64 26.4.7-1.el7.centos mariadb 9.1 M
pcre2 x86_64 10.23-2.el7 base 201 k
socat x86_64 1.7.3.2-2.el7 base 290 k
Transaction Summary
=============================================================================================================================================================================================================================================
Install 3 Packages (+5 Dependent packages)
Total download size: 51 M
Is this ok [y/d/N]: y
Downloading packages:
warning: /var/cache/yum/x86_64/7/mariadb/packages/MariaDB-common-10.5.9-1.el7.centos.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 1bb943db: NOKEY
Public key for MariaDB-common-10.5.9-1.el7.centos.x86_64.rpm is not installed
(1/8): MariaDB-common-10.5.9-1.el7.centos.x86_64.rpm | 81 kB 00:00:00
(2/8): MariaDB-compat-10.5.9-1.el7.centos.x86_64.rpm | 2.2 MB 00:00:00
(3/8): MariaDB-client-10.5.9-1.el7.centos.x86_64.rpm | 13 MB 00:00:01
(4/8): boost-program-options-1.53.0-28.el7.x86_64.rpm | 156 kB 00:00:00
(5/8): socat-1.7.3.2-2.el7.x86_64.rpm | 290 kB 00:00:00
(6/8): pcre2-10.23-2.el7.x86_64.rpm | 201 kB 00:00:00
(7/8): galera-4-26.4.7-1.el7.centos.x86_64.rpm | 9.1 MB 00:00:00
(8/8): MariaDB-server-10.5.9-1.el7.centos.x86_64.rpm | 26 MB 00:00:01
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 24 MB/s | 51 MB 00:00:02
Retrieving key from https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
Importing GPG key 0x1BB943DB:
Userid : "MariaDB Package Signing Key <package-signing-key@mariadb.org>"
Fingerprint: 1993 69e5 404b d5fc 7d2f e43b cbcb 082a 1bb9 43db
From : https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
Is this ok [y/N]: y
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : pcre2-10.23-2.el7.x86_64 1/11
Installing : MariaDB-common-10.5.9-1.el7.centos.x86_64 2/11
warning: /etc/my.cnf created as /etc/my.cnf.rpmnew
Installing : MariaDB-compat-10.5.9-1.el7.centos.x86_64 3/11
Installing : MariaDB-client-10.5.9-1.el7.centos.x86_64 4/11
Installing : socat-1.7.3.2-2.el7.x86_64 5/11
Installing : boost-program-options-1.53.0-28.el7.x86_64 6/11
Installing : galera-4-26.4.7-1.el7.centos.x86_64 7/11
Installing : MariaDB-server-10.5.9-1.el7.centos.x86_64 8/11
Erasing : 1:mariadb-server-5.5.68-1.el7.x86_64 9/11
warning: /var/log/mariadb/mariadb.log saved as /var/log/mariadb/mariadb.log.rpmsave
Erasing : 1:mariadb-5.5.68-1.el7.x86_64 10/11
Erasing : 1:mariadb-libs-5.5.68-1.el7.x86_64 11/11
Verifying : pcre2-10.23-2.el7.x86_64 1/11
Verifying : MariaDB-compat-10.5.9-1.el7.centos.x86_64 2/11
Verifying : MariaDB-client-10.5.9-1.el7.centos.x86_64 3/11
Verifying : boost-program-options-1.53.0-28.el7.x86_64 4/11
Verifying : socat-1.7.3.2-2.el7.x86_64 5/11
Verifying : galera-4-26.4.7-1.el7.centos.x86_64 6/11
Verifying : MariaDB-common-10.5.9-1.el7.centos.x86_64 7/11
Verifying : MariaDB-server-10.5.9-1.el7.centos.x86_64 8/11
Verifying : 1:mariadb-libs-5.5.68-1.el7.x86_64 9/11
Verifying : 1:mariadb-server-5.5.68-1.el7.x86_64 10/11
Verifying : 1:mariadb-5.5.68-1.el7.x86_64 11/11
Installed:
MariaDB-client.x86_64 0:10.5.9-1.el7.centos MariaDB-compat.x86_64 0:10.5.9-1.el7.centos MariaDB-server.x86_64 0:10.5.9-1.el7.centos
Dependency Installed:
MariaDB-common.x86_64 0:10.5.9-1.el7.centos boost-program-options.x86_64 0:1.53.0-28.el7 galera-4.x86_64 0:26.4.7-1.el7.centos pcre2.x86_64 0:10.23-2.el7 socat.x86_64 0:1.7.3.2-2.el7
Replaced:
mariadb.x86_64 1:5.5.68-1.el7 mariadb-libs.x86_64 1:5.5.68-1.el7 mariadb-server.x86_64 1:5.5.68-1.el7
next run the mysql_upgrade :
mysql_upgrade
Phase 1/7: Checking and upgrading mysql database
Processing databases
mysql
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.servers OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
Upgrading from a version before MariaDB-10.1
Phase 2/7: Installing used storage engines
Checking for tables with unknown storage engine
Phase 3/7: Fixing views
Phase 4/7: Running 'mysql_fix_privilege_tables'
Phase 5/7: Fixing table and database names
Phase 6/7: Checking and upgrading tables
Processing databases
information_schema
performance_schema
test
Phase 7/7: Running 'FLUSH PRIVILEGES'
OK
Also check our other tutorial links on mysql.
