MySQL & MariaDB
Explore Dev Corner articles and subtopics in MySQL & MariaDB. This hub page collects practical builds, tools, and engineering guides for sovereign local AI.
Topic breadth
2
Active builds, guides, and subtopic coverage.
Subtopics
MySQL — Installation & Setup
View topicInstall MySQL 9.0 and MariaDB 11 on Ubuntu 24.04. Covers mysql_secure_installation, root password configuration, remote access, and initial database creation.
MySQL — User Management
View topicSovereign MySQL user management: CREATE USER, GRANT/REVOKE privileges, authentication plugins, SSL-required connections, and least-privilege role design.
MySQL — Backup & Recovery
View topicMySQL backup strategies for sovereign deployments: mysqldump, Percona XtraBackup, binary log backup, point-in-time recovery, and automated backup verification.
MySQL — Performance Tuning
View topicOptimise MySQL for self-hosted workloads: EXPLAIN query analysis, indexing strategy, InnoDB buffer pool tuning, slow query log, and query cache configuration.
MySQL — Replication
View topicSet up MySQL primary-replica replication for sovereign high availability. Covers GTID replication, binary log format, replica promotion, and ProxySQL for read scaling.
MySQL → MariaDB Migration
View topicMigrate from MySQL to MariaDB 11 for sovereign, Oracle-free database operation. Covers compatibility assessment, dump-and-restore migration, Galera Cluster setup, and feature comparison.