Mariadb guides
Hands-on guides that cover Mariadb. Every command is run and verified on a live server before it is published.
GuideInstall and Secure MariaDB
Install and secure MariaDB on a live Ubuntu 24.04 server, then prove the defaults hold: socket-only root, no anonymous users, and no test database.
GuideUsers, Privileges and Least Privilege
Give each MariaDB login only the privileges its job needs, then watch the app account get refused a schema change and a read-only user refused a write.
GuideBackups That Actually Restore
Take a MariaDB backup with mysqldump, then restore it into a fresh database and check the row counts match. Physical copies with mariabackup too.
GuideReplication: Primary to Replica
Set up MariaDB replication from a primary to a replica on one server, then confirm both threads run and watch a new row cross from primary to replica.
GuideSecurity Hardening
MariaDB security hardening on a live server: bind to localhost, require TLS for a user, firewall the port, disable symbolic links, and recap least privilege.