MariaDB Upgrade to the new version | CWP

• • Check installed MariaDB version on your server

    rpm -qa|grep -i maria

  • MariaDB Repository Changes
    Modify repo file to the version you want to upgrade

    vi /etc/yum.repos.d/mariadb.repo

  • Output

    [mariadb]
    name = MariaDB
    baseurl = http://yum.mariadb.org/10.2/centos7-amd64
    gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
    gpgcheck=1
    enabled=1

  • Modify 10.2 with the version you want to upgrade
    Example for upgrade to MariaDB 10.5

    [mariadb]
    name = MariaDB
    baseurl = http://yum.mariadb.org/10.5/centos7-amd64
    gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
    gpgcheck=1
    enabled=1

  • Stop and remove the old version of MariaDB (Databases will not be removed)

    service mysql stop
    service mariadb stop
    systemctl disable mariadb
    rpm --nodeps -ev MariaDB-server

• Install the new version of MariaDB

  yum clean all
  yum -y update "MariaDB-*"
  yum -y install MariaDB-server
  systemctl enable mariadb
  service mariadb start
  mysql_upgrade

• Check for the custom configuration

  diff -Bw /etc/my.cnf.d/server.cnf.rpmsave /etc/my.cnf.d/server.cnf

• Verify upgraded packages

  rpm -qa|grep -i maria

• That’s All

Yum repository list of the available versions
http://yum.mariadb.org/