GalaxyData Community

HOW TO UPGRADE MARIADB 5.5 TO MARIADB 10.4 ON CENTOS 7.5 (1804)

Chapter 1. 1. MAKE SURE YOU’RE RUNNING MARIADB 5.5

Run the following command:

mysql -v

 

Should output the following:

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 5
Server version: 5.5.60-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Reading history-file /root/.mysql_history
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

 

Perfect, let’s keep going!

 

Chapter 2. 2. ADD THE MARIADB 10.3 REPOSITORY

Run the following command to add the MariaDB 10.3 repository to yum:

nano /etc/yum.repos.d/maria10-4.repo

 

Paste the following into the editor

# MariaDB 10.4 CentOS repository list - created 2019-08-31 18:03 UTC
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.4/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

 

Save and close the editor, then move to the next step

 

Chapter 3. 3. UPGRADE TO MARIADB 10.3 AND VERIFY SUCCESS

Run the following command to upgrade to MariaDB 10.3:

yum install MariaDB-server MariaDB-client

 

Output should look something like this:

==========================================================================================================================================================================================================================
 Package                                                   Архитектура                                Версия                                                            Репозиторий                                 Размер
==========================================================================================================================================================================================================================
Установка:
 MariaDB-client                                            x86_64                                     10.3.15-1.el7.centos                                              mariadb                                      11 M
     замена  mariadb.x86_64 1:5.5.60-1.el7_5
 MariaDB-compat                                            x86_64                                     10.3.15-1.el7.centos                                              mariadb                                     2.8 M
     замена  mariadb-libs.x86_64 1:5.5.60-1.el7_5
 MariaDB-server                                            x86_64                                     10.3.15-1.el7.centos                                              mariadb                                      24 M
     замена  mariadb-server.x86_64 1:5.5.60-1.el7_5
Установка зависимостей:
 MariaDB-common                                            x86_64                                     10.3.15-1.el7.centos                                              mariadb                                      78 k
 boost-program-options                                     x86_64                                     1.53.0-27.el7                                                     base                                        156 k
 galera                                                    x86_64                                     25.3.26-1.rhel7.el7.centos                                        mariadb                                     8.1 M

 

Once yum does it’s thing, restart the MariaDB daemon:

systemctl restart mariadb

Then verify that the service has started and the installation is complete:

Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.

The fix for the startup problem is in the article

MariaDB 10.3 [ERROR] mysqld: Can’t create/write to file ‘/var/run/mysqld/mysqld.pid’ (Errcode: 2 «No such file or directory»)

You should see output similar to the following:

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 11
Server version: 10.3.15-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Reading history-file /root/.mysql_history
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

 

Sweet, you’re now running MariaDB 10.4!

Exit mobile version