contact

Update MariaDB 5.5 to MariaDB 10.3 in Centos 7.6

August 11, 2019
App Design -

The remarkable performance improvement for the management of 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.

update database

Which we got with the latest version:

  • Much more robust security checks in our databases.
  • New features in our database engine.
  • Larger storage systems.
  • Optimization in the grouping of databases.
  • High-speed performance for our websites.
  • Improved compatibility
  • MariaDB is the most assembled system for hosting currently.
  • Versatility and efficiency in data processing

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

Steps to update our database to MariaDB 10.3

  1. nano /etc/yum.repos.d/MariaDB10.repoAccessing our Centos server via SSH.
  2. The first thing we have to do, back up our database.

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

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

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

    Once inside we created 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 feature installed on your Centos server, you can install it with the following command:

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

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

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

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

    systemctl start mariadb
  8. Set to start automatically:

    systemctl enable mariadb
  9. Finally, import the data from the old database into 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 expertsIf you have any questions, please contact us.

App Design Company
Web design agency, application and software development
Copyright © 2020 App Design | All rights reserved - Privacy Policy, Legal Notice and Cookies - General conditions
Sitemap: Sitemap