Upgrading MariaDB 5.5 to MariaDB 10.3 on Centos 7.6

Update database

The remarkable performance improvement for managing dedicated servers in Linux with the new MariaDB update 10.3 has made us update our database systems MySQL on our Centos 7.6 server.

What we get with the latest version:

  • Much more robust security reviews in our databases.
  • New functions in our database engine.
  • Larger storage systems.
  • Optimization in the grouping of databases.
  • High speed performance for our web pages.
  • Greater compatibility
  • MariaDB is the most widely used hosting system currently.
  • Versatility and efficiency in data processing.

Having said that, mention that it is worth updating our systems for two reasons, an improvement in security and a performance increase. If you have online stores, we advise you to update your databases.

Steps to follow to update our database to MariaDB 10.3

  1. nano /etc/yum.repos.d/MariaDB10.repo We access our Centos server using SSH.
  2. The first thing we must do, make a backup of our database.

    cp -a / var / lib / mysql / /var/lib/mysql.bak

    Remember to have a copy of the databases of your web pages.
  3. We create the MariaDB repo:

    nano /etc/yum.repos.d/MariaDB10.repo

    Once inside we create the repo, in our case:

    # MariaDB 10.1 CentOS repository list - created 2016-01-18 09:58 UTC
    #
    [mariadb]
    name = MariaDB
    baseurl = http://yum.mariadb.org/10.1/centos7-amd64
    gpgkey = https: //yum.mariadb.org/RPM-GPG-KEY-MariaDB
    gpgcheck = 1


    Save and close the editor.

    You can check the latest repos here: https://downloads.mariadb.org/mariadb/repositories/#mirror=nxtHost

    Note: if you do not have the nano function installed on your Centos server, you can install it with the following command:

    yum install nano
  4. We deleted the previous version that we had, in this case MariaDB 5.5.

    yum remove mariadb-server mariadb mariadb-libs
  5. We remove the cache.

    yum clean all
  6. We install the new version MariaDB 10.3.

    yum -y install MariaDB-server MariaDB-client
  7. And we already have a new version installed! We perform the activation:

    systemctl start mariadb
  8. Set it to start automatically:

    systemctl enable mariadb
  9. Finally, import the data from the old database to the new one:

    mysql_upgrade

    Ready!. We already have our new version of MariaDB 10.3, we can verify it with the following parameter:

    mysql -V

If you need help with Linux hosting experts, consult with us.

Update database
Copy link