Vucense
Dev Corner category

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 topic

Install 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 topic

Sovereign MySQL user management: CREATE USER, GRANT/REVOKE privileges, authentication plugins, SSL-required connections, and least-privilege role design.

MySQL — Backup & Recovery

View topic

MySQL backup strategies for sovereign deployments: mysqldump, Percona XtraBackup, binary log backup, point-in-time recovery, and automated backup verification.

MySQL — Performance Tuning

View topic

Optimise MySQL for self-hosted workloads: EXPLAIN query analysis, indexing strategy, InnoDB buffer pool tuning, slow query log, and query cache configuration.

MySQL — Replication

View topic

Set 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 topic

Migrate from MySQL to MariaDB 11 for sovereign, Oracle-free database operation. Covers compatibility assessment, dump-and-restore migration, Galera Cluster setup, and feature comparison.