--- mariadb_version: 10.11.6 mariadb_data_dir: /var/lib/mysql mariadb_root_home: /root mariadb_user: mysql mariadb_root_username: root mariadb_server_log: /var/log/mysqld.log mariadb_backup_dir: /srv/Backups/mysql mariadb_server_settings: - { option: "datadir", value: "{{mariadb_data_dir }}" } - { option: "max_allowed_packet", value: "64M" } - { option: "query_cache_size", value: "0" } - { option: "join_buffer_size", value: "1M" } - { option: "tmp_table_size", value: "32M" } - { option: "max_heap_table_size", value: "32M" } - { option: "performance_schema", value: "ON" } - { option: "innodb_buffer_pool_size", value: "4G" } - { option: "innodb_log_file_size",value: "1G" } - { option: "log-error", value: "{{ mariadb_server_log }}" } - { option: "log-bin", value: "{{ mariadb_data_dir }}/log-bin" } - { option: "expire_logs_days", value: "7" } - { option: "max_binlog_size", value: "1G" } - { option: "skip-innodb-read-only-compressed", value: "yes" } mariadb_use_percona: false