Taking a look at MariaDB configuration

Now that we have MariaDB installed, let's take a quick look at how its configuration is stored. While we won't be changing much of the configuration in this chapter (aside from adding parameters related to setting up a slave), it's a good idea to know where to find the configuration, since you'll likely be asked by a developer to tune the database configuration at some point in your career. This may involve changing the storage engine, buffer sizes, or countless other settings. A full walkthrough on performance tuning is outside the scope of this book, but it will be helpful to know how the settings for MariaDB are read, since Ubuntu's implementation is fairly unique.

The configuration files for MariaDB are stored in the /etc/mysql directory. Within that directory, you'll see the following files by default:

debian.cnf
debian-start
mariadb.cnf
my.cnf
my.cnf.fallback

You'll also see the following directories:

conf.d
mariadb.conf.d

The configuration file that...