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.
(This is an article from my old blog that has been inactive for a long time, I don’t want to throw it away so I will keep it and hope it helps someone).