Update MariaDB 5.5 to MariaDB 10.3 in Centos 7.6

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.

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.