How to update VestaCP to MariaDB 10.3

SystemMen - How to update VestaCP to MariaDB 10.3? In this article, I will guide you step by step to do that.

Update VestaCP to MariaDB 10.3

By default, VestaCP will install version MariaDB 5.5.60. A lot of people want to use the latest version of MariaDB.

The current stable version is currently 10.3. And I will guide you to update it.

First, you need to stop the VestaCP server’s current mariadb service.

service mariadb stop

Next, you need to remove the old MariaDB installation packages.

yum remove mariadb mariadb-server -y

After that, you will need to add MariaDB repository to the VestaCP server. You should choose the correct version according to the OS you are using. For example, I am using CentOS 7 server.

Recommended Reading: How to install MariaDB 10.2 in CentOS 7

Type the following command to create a repo file for MariaDB.

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

Next, copy the content below into the file you just created and save.

# MariaDB 10.3 CentOS repository list - created 2019-04-09 04:55 UTC
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.3/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

Then you install MariaDB version 10.3 for new version.

yum install MariaDB-server MariaDB-client -y

After the installation of the packages is complete, restart the mysql service.

service mysql start

And finally, the important step. You run the update command for MariaDB’s current configuration.

mysql_upgrade

The result look like this.

[root@vestacp ~]# mysql_upgrade
Phase 1/7: Checking and upgrading mysql database
Processing databases
mysql
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
Upgrading from a version before MariaDB-10.1
Phase 2/7: Installing used storage engines
Checking for tables with unknown storage engine
Phase 3/7: Fixing views
Phase 4/7: Running 'mysql_fix_privilege_tables'
Phase 5/7: Fixing table and database names
Phase 6/7: Checking and upgrading tables
Processing databases
admin_default
information_schema
performance_schema
roundcube
roundcube.cache                                    OK
roundcube.cache_index                              OK
roundcube.cache_messages                           OK
roundcube.cache_shared                             OK
roundcube.cache_thread                             OK
roundcube.contactgroupmembers                      OK
roundcube.contactgroups                            OK
roundcube.contacts                                 OK
roundcube.dictionary                               OK
roundcube.filestore                                OK
roundcube.identities                               OK
roundcube.searches                                 OK
roundcube.session                                  OK
roundcube.system                                   OK
roundcube.users                                    OK
Phase 7/7: Running 'FLUSH PRIVILEGES'
OK

Now, you can check the update version of MariaDB.

[root@vestacp ~]# mysql -V
mysql  Ver 15.1 Distrib 10.3.14-MariaDB, for Linux (x86_64) using readline 5.1

Conclusion

I’ve guided you step by step to successfully update to MariaDB 10.3. It will make your VestaCP hosting more efficient.

«« How to update VestaCP to PHP 7.3Fix error disk read-only in VestaCP after reboot »»