Go to file
phil 0ba45bd99b Fix paths 2024-01-21 01:23:58 +01:00
.vscode Fix typos 2023-08-14 12:31:32 +02:00
defaults Add some recommended performance settings 2023-11-19 13:55:33 +01:00
files Enable configuration of Systemd service 2024-01-21 01:13:24 +01:00
handlers automysqlbackup configuration via dict 2023-11-04 12:22:33 +01:00
meta Update role information 2023-02-07 20:46:43 +01:00
tasks Fix paths 2024-01-21 01:23:58 +01:00
templates Enable configuration of Systemd service 2024-01-21 01:13:24 +01:00
README.md Enable configuration of Systemd service 2024-01-21 01:13:24 +01:00

README.md

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:

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:

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.