Chapter 2. Configuring MariaDB
MariaDB is installed with a generic configuration that is suitable for general use. This is perfect for giving MariaDB a try but might not be suitable for a production database application under a heavy load. There are thousands of ways to tweak the settings to get MariaDB to perform just the way we need it to. Many books have been written on this subject. In this chapter, we'll cover enough of the basics so that we can comfortably edit the MariaDB configuration files and know our way around. Think of this chapter as a MariaDB configuration highlights tour.
The topics that we will cover in this chapter include the following:
- The MariaDB filesystem layout
- Modular configuration on Linux
- The anatomy of the MariaDB configuration file
- Activating configuration changes