Skip to main content

MariaDB

Install MariaDB sized to your machine and enable the slow query log. Create a dedicated DB user and review essential InnoDB settings for WordPress.

Note: This module is being worked on. Below is the lesson plan you can expect.

  • Installing MariaDB from OS packages
  • Understanding the MariaDB configuration and data files
  • Understanding InnoDB configuration dials
  • Enabling the slow query log for performance troubleshooting
  • Working with the MariaDB shell, creating a user account for your WordPress application
  • Optional: Installing and securing phpMyAdmin
  • Updating logrotate to cover MariaDB

Next module: WordPress