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
- nano /etc/yum.repos.d/MariaDB10.repoAccessing our Centos server via SSH.
- 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.
- We created the MariaDB repo:
Once inside we created the repo, in our case:
# MariaDB 10.1 CentOS repository list - created 2016-01-18 09:58 UTC
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
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
- We deleted the previous version we had, in this case MariaDB 5.5.
yum remove mariadb-server mariadb-libs
- We removed the cache.
yum clean all
- We installed the new version MariaDB 10.3.
yum - and install MariaDB-server MariaDB-client
- And we have a new version installed! We performed the activation:
systemctl start mariadb
- Set to start automatically:
systemctl enable mariadb
- Finally, import the data from the old database into the new one:
Ready!. We already have our new version of MariaDB 10.3, we can verify it with the following parameter:
If you need help with linux hosting expertsIf you have any questions, please contact us.