34 guides, scripts and tools for MariaDB / MySQL. Search them or pick a type. Press / to search.
Nothing matches. Try a shorter word or another section.
MariaDB 10.6 End of Life: Safe Upgrade Paths to 11.8 or 12.3
MariaDB 10.6 stopped receiving fixes in July 2026; this guide lays out the realistic upgrade targets for cPanel, DirectAdmin and standalone servers, the hop sequence each panel allows, what to test first and how to confirm the new version is healthy.
September 29, 2026
MariaDB 12.3 LTS: what changed and what breaks (reserved words, removed variables, Galera packages)
A hosting-focused review of MariaDB 12.3, the LTS released in May 2026, covering the new authentication and Oracle-compatibility features, the reserved words and removed variables that break existing configurations and queries, and the Galera packaging change.
September 29, 2026
mariadb-dump vs mysqldump: modern backup commands and wildcard database dumps
How the mariadb-dump command differs from the mysqldump symlink it replaces, the options every hosting backup script should use, the wildcard database selection added in MariaDB 12.1, and how to check a dump is complete and restorable.
September 29, 2026
MariaDB point-in-time recovery with binary logs (and 13.0’s innodb_log_archive)
How to enable and retain binary logs on a MariaDB hosting server so a customer's accidental DELETE can be undone to the second, the exact mariadb-binlog replay procedure, and what the innodb_log_archive feature in MariaDB 13.0 changes for recovery.
September 29, 2026
InnoDB Tuning MariaDB 11/12: Shared Hosting Settings
Practical InnoDB settings for a cPanel shared server on MariaDB 11.4, 11.8 or 12.3, with sizing rules for the buffer pool and redo log, the I/O settings that matter on NVMe, what the modern defaults already get right, and how to measure the result.
September 29, 2026
MariaDB Slow Queries on 11/12: Diagnosis Steps
A working method for finding and fixing the queries that make a shared MariaDB server slow, using the slow query log with sensible thresholds, EXPLAIN and ANALYZE, the optimizer trace for the hard cases, and the optimizer hints introduced in 12.x to force a plan.
September 29, 2026
caching_sha2_password MariaDB 12: Fix MySQL 8 Client Problems
MariaDB 12.1 and later support the caching_sha2_password authentication plugin that MySQL 8 clients expect; this guide explains the resulting errors in both directions, how to check which plugin each account uses, and how to make PHP, CLI tools and replication clients connect.
September 29, 2026
Convert MySQL to MariaDB Safely: No In-Place Switch in 2026
DirectAdmin's CustomBuild and cPanel both refuse to switch a server from MySQL to MariaDB in place; this guide explains why the data formats diverged, then walks through the supported dump-and-restore conversion on a DirectAdmin server with verification at each stage.
September 29, 2026
MySQL ERROR 1040 Too Many Connections: Fixes for cPanel
Sites throw "Error establishing a database connection" and the MySQL error log says "Too many connections". Here is how to get the server back in two minutes, find what actually caused it, and set limits so it does not come back.
September 29, 2026
MySQL Health Snapshot Script: Free 10-Second MariaDB Check
One page of the numbers that matter on a MariaDB or MySQL server: connections vs limit, buffer pool hit ratio, tmp tables on disk, slow queries, largest tables, leftover MyISAM and anything running longer than five seconds. Read-only.
September 29, 2026
