How to install MariaDB Server in cPanel/WHM servers?
And
What are the advantages of using MariaDB Server ?
Ans:
* Install MariaDB Server in cPanel/WHM servers
1. Backup existing MySQL data
# mysqldump --all-databases --routines --triggers > /home/db_dump/alldb.sql # service mysql stop # cp -r /var/lib/mysql/mysql /home/db_dump/ # service mysql start
2. Select MySQL version as MariaDB
# /usr/share/lve/dbgovernor/db-select-mysql --mysql-version=mariadb100
MariaDB versions:
mariadb55 for MariaDB v5.5 mariadb100 for MariaDB v10.0 mariadb101 for MariaDB v10.1
3. Install MariaDB
# /usr/share/lve/dbgovernor/db-select-mysql --install-now
Final step is to recompile PHP and Apache in the server.
# /scripts/easyapache
* Advantages of using MariaDB Server
1) Faster and safer replication.
2) Indexes for the MEMORY(HEAP) engine are faster.
3) CHECKSUM TABLE is faster.
4) MariaDB improved the performance of character set conversions.
5) Pool of Threads in MariaDB 5.1 and even better in MariaDB 5.5.
6) There are some improvements to the DBUG code to make its execution faster when debug is compiled in but not used.
7) Our use of the Aria storage engine enables faster complex queries.
8) The test suite has been extended and now runs much faster than before, even though it tests more things.
With 2026 just days away, it’s time to reimagine your website’s future. Hostripples encourages businesses, creators, and entrepreneurs to begin…
Cron Jobs – The Unsung Heroes Think of cron jobs as the unsung heroes of your server — capes optional,…
With vibrant colors, cheerful graphics, and a sprinkle of festive magic, your website can instantly create an emotional connection and…
The world of artificial intelligence is evolving faster than ever — and one of the biggest breakthroughs is here. Sora,…
Black Friday 2025 is here — the biggest shopping moment of the year, where customers expect unbeatable prices, fast performance,…