MariaDB

In this module you will install and configure MariaDB, the best database service for WordPress websites. You'll learn about MariaDB and InnoDB configuration, where the data lives, how the InnoDB buffer pool and redo logs improve database performance.

You'll enable the Slow Query Log, one of the best diagnostic tools for application and database performance. You'll learn about tagging queries too.

Finally, you will create a new database and grant access to a new non-privileged user for your WordPress site. You'll learn how to use the MariaDB shell, and optionally install and secure phpMyAdmin.

Lessons in this module

• Installing MariaDB
• Understanding the MariaDB configuration and data files
• InnoDB configuration options
• Enabling MariaDB's slow query log
• Creating a MariaDB user account for your WordPress application
• Installing and securing phpMyAdmin

Next module: WordPress