MariaDB ======= This role installs MariaDB, including: - Monitoring with Monit and Munin - Backups with automysqlbackup ## Configuration Create a dictionary called `mysqld` and define your settings. You can use all upstream configuration items: ```YAML mysqld: bind_address: 0.0.0.0 slow_query_log: 1 ... ``` ## Changes to the Systemd service Use the following options to configure your MariaDB service: ```YAML mariadb_service limitnofile: 64184 restart: on-failure ``` ## Backup For daily backups we use automysqlbackup. You can configure it via the dict `automysqlbackup_config`. You can use every upstream configuration item in this dict. Just lowercase it. Note: You have to use _true_ and _yes_ as boolean values and you need to quote them. Have a look at `defaults/main.yml` for our defaults.