Emergency server help: get in touch

MariaDB / MySQL

MariaDB and MySQL guides and scripts: upgrades, InnoDB tuning, slow queries, backups, point-in-time recovery and end-of-life planning.

34 guides, scripts and tools for MariaDB / MySQL. Search them or pick a type. Press / to search.

34 pages

MariaDB Slow Query Log Summary

Summarises the MariaDB slow query log without Percona tools: groups queries by fingerprint, ranks them by total time, count and rows examined, and prints the commands to turn logging on.

September 30, 2026

AI Slow Query Advisor for MySQL and MariaDB

Paste a slow MySQL or MariaDB query, optionally with EXPLAIN output and SHOW CREATE TABLE, and get a diagnosis, exact index statements, a rewrite and how to verify the improvement.

September 30, 2026

AI Config Generator for Nginx, Apache, PHP-FPM and MariaDB

Describe your server and requirements and get a commented Nginx, Apache, .htaccess, PHP-FPM, php.ini, my.cnf, Redis, sshd, Postfix, logrotate or systemd config — sized for your hardware.

September 30, 2026

Upgrade MySQL 8 to MariaDB 11.8 in WHM Safely, Without Data Loss

MySQL 8.0 left extended support in April 2026. This guide covers moving a cPanel server from MySQL 8.0 to MariaDB 11.8 LTS through WHM, with the backup, compatibility and verification steps that keep customer databases intact.

September 29, 2026

Upgrade MariaDB DirectAdmin: Safe CustomBuild Path to 12.3

A staged MariaDB upgrade path for DirectAdmin servers using CustomBuild, from the now end-of-life 10.6 through the 10.11 and 11.8 LTS releases to 12.3, with the configuration variables and reserved words that break each hop and how to roll back.

September 29, 2026

Upgrade MariaDB WHM Safely: Backups and mariadb-upgrade

A careful procedure for moving a cPanel server between MariaDB versions through WHM, covering the pre-flight checks, the backup that is your only rollback, the innodb_fast_shutdown setting that prevents redo-log surprises, and post-upgrade verification.

September 29, 2026

MySQL 8.4 vs 9.7 LTS: what hosting admins need to know

Oracle now ships MySQL as an innovation track plus periodic LTS releases; this guide compares the two current LTS versions, 8.4 and 9.7, on support dates, defaults, control-panel availability and upgrade paths, so a hosting provider can set a version policy.

September 29, 2026

MySQL 8.0 End of Life: Safe Move to 8.4 or MariaDB

MySQL 8.0 left extended support in April 2026; this guide sets out the two realistic destinations for a cPanel server, the differences that matter between MySQL 8.4 LTS and MariaDB 11.8, and how to prepare, execute and verify either move through WHM.

September 29, 2026

MariaDB support timeline 2026–2029: which LTS should your servers run?

The current MariaDB long-term-support and rolling-release schedule as of late 2026, what each version's end-of-life date means for hosting servers, how cPanel and DirectAdmin support differs, and a simple policy for deciding when to move.

September 29, 2026

MariaDB Unknown Variable After Upgrade: Fix Failed Startup

When MariaDB refuses to start after an upgrade with an unknown variable or unknown option error, the cause is a removed setting in my.cnf; this guide shows how to find it quickly, lists the variables removed across recent versions, and covers the related redo-log failure.

September 29, 2026

MariaDB Vector Search PHP: VECTOR Type (11.8/12.x)

A hands-on introduction to the native VECTOR column type and distance functions that arrived in MariaDB 11.7 and 11.8, showing how to create a vector index, insert embeddings from PHP with PDO, run nearest-neighbour queries and check that the index is being used.

September 29, 2026

MariaDB Not Starting After Upgrade: 5 Recovery Fixes

A recovery sequence for a cPanel server whose MariaDB refuses to start after a version jump, covering removed configuration variables, InnoDB crash recovery levels, running mariadb-upgrade, and application errors caused by stricter sql_mode defaults in 11.4 and later.

September 29, 2026

Free website test

Is your website set up right?

Check SSL, security headers, redirects, robots.txt, sitemap, llms.txt and security.txt in one test. It takes about 30 seconds.