Why Database Management
Understand why MySQL/MariaDB management is critical for WordPress performance, security, and recoverability on a VPS.
Accessing CLI
Connect to MySQL/MariaDB from the shell so you can inspect and manage a WordPress database safely.
Backup & migration
Back up and migrate a WordPress database safely using logical dumps, compression, transfer, and restore verification.
Performance basics
A practical baseline for measuring and tuning MySQL/MariaDB performance on a WordPress VPS.
User privileges
Create and audit MySQL/MariaDB users and grants so WordPress has the access it needs without over-privileging.
Use cases
Practical database management scenarios for WordPress VPS servers: connection checks, backups, slowdowns, and migrations.
Replication
Replicate a MySQL/MariaDB database to a secondary server using binlog-based replication for read scaling and failover patterns.
WordPress setup
Create a WordPress database and user with least privilege, then verify connectivity before installing WordPress.