Install WHM/cPanel with MariaDB
MySQL vs MariaDB
MySQL is an open-source relational database management system created by MySQL AB for web application development. It provides support for web developers to manage data with ease using tables. Developed in the mid-90s, it is a relational database management system that was one of the first open-source database available in the market. Today there are many variants of MySQL. However, the differences between the variants are not significant as they use the same syntax with the same basic functionality.
MariaDB is a fork of MySQL, but it is also an improved version of it. The developers built the RDBMS to preserve MySQL’s structure and features. The development of MariaDB was in response of Oracle’s acquisition of MySQL. As MySQL’s biggest competitor, it was feared that the acquisition by Oracle would jeopardize MySQL.
MariaDB is developed as MySQL’s full binary drop-in replacement
Improvements over MySQL
- MariaDB comes with an advanced thread pool capable of running faster and supporting up to 200,000+ connections.
- MariaDB has 12 new storage engines not found in MySQL.
- Improved speed when compared to MySQL.
- Faster cache/indexes
- MariaDB comes with new features and extensions including the JSON, WITH and KILL statements.
Install WHM/cPanel with MariaDB instead of MySQL
To install WHM/cPanel, you will need a VPS or Dedicated Server. We strongly advise you to use Cloudlinux as it is the more secure option when building a web server.
Once you have finished your Linux installation, create the following folder and file:
$ mkdir /root/cpanel_profile
$ touch /root/cpanel_profile/cpanel.configNow add the following to the cpanel.config file and save:
mysql-version=10.8This will ensure that MariaDB 10.8 is installed instead of MySQL 8.0
Once you have created the file and saved it, you can proceed with the WHM/cPanel installation as per usual:
cd /home && curl -o latest -L https://securedownloads.cpanel.net/latest && sh latest