Birmingham mumbai

[
 332 
]
You'll also see the following directories:
conf.d 
mariadb.conf.d 
The configuration file that MariaDB reads on startup is the 
/etc/mysql/mariadb.cnf
 
file. This is where you'll begin perusing when you want to configure the daemon, 
but we'll get to that soon. The 
/etc/mysql/debian-start
 file is actually a script that 
sets default values for MariaDB when it starts, such as setting some environment 
variables. It also defines a task that is executed if the 
mariadb
 process dies or exits, 
and allows it to check for crashed tables.
The 
debian-start
 script also loads the 
/etc/mysql/debian.cnf
 file, which sets some 
client settings for the 
mariadb
 daemon. Here's a list of values from that file:
[client] 
host     = localhost 
user     = root 
password =  
socket   = /var/run/mysqld/mysqld.sock 
[mysql_upgrade] 
host     = localhost 
user     = root 
password =  
socket   = /var/run/mysqld/mysqld.sock 
basedir  = /usr 
The defaults for these values
 are fine and there's rarely a reason to change them. 
Essentially, the file sets the default user, host, and socket location. If you've used 
MySQL before on other platforms, you may have seen many of those settings in 
the 
/etc/my.cnf
 file, which is typically the standard file for the 
mariadb
 daemon. 
With MariaDB on Ubuntu Server, you can see that the default layout of the files was 
changed considerably.
The 
/etc/mysql/mariadb.cnf
 file sets the global defaults for MariaDB. However, 
in Ubuntu's implementation, this default file just includes configuration files from 
the 
/etc/mysql/conf.d
 and 
/etc/mysql/mariadb.conf.d
 directories. Within those 
directories, there are additional files ending with the 
.cnf
 extension. Many of 
these files contain default configuration values that would normally be found in a 
single file, but Ubuntu's implementation modularizes these settings into separate 
files instead. For our purposes in this book, we'll be editing the 
/etc/mysql/
conf.d/mysql.cnf
 file when it is time to set up a relationship between primary and 
secondary servers.

---

Chapter 13