munin_sql_config_file: /etc/munin/plugin-conf.d/zzz-mariadb
munin_sql_user: munin
munin_sql_password: "{{ lookup('ansible.builtin.password', '/tmp/{{ inventory_hostname }}_munin_sql_password chars=ascii_lowercase,digits length=23') }}"

mysql_socket: /run/mysqld/mysqld.sock

mysqld:
  innodb_log_buffer_size: 4M
  innodb_log_file_size: 256M
  slow_query_log: 1
  slowlog_query_log_file: /var/log/mysql/mariadb-slow.logA
  slowlog_query_time: 10
  slowlog_log_slow_rate_limit: 1000
  log_slow_verbosity: query_plan

automysqlbackup_config:
  dbhost: localhost
  dbnames: "$(mysql --defaults-file=/etc/mysql/debian.cnf -s -N --execute='SHOW DATABASES' | grep -v ^mysql$ | grep -v ^performance_schema$ | grep -v ^information_schema$ | xargs)"
  backupdir: /var/lib/automysqlbackup
  mailcontent: quiet
  maxattsize: 4000
  mailaddr: root
  mdbnames: "mysql $DBNAMES"
  create_database: "yes"
  sepdir: "yes"
  doweekly: 6
  domonthly: 1
  comp: gzip
  compdirect: "yes"
  commcomp: "yes"
  latest: "no"
  postbackup: /usr/local/bin/automysqlbackup_post_script
  routines: "yes"