---

• name: Configure MariaDB logging on CentOS 7

hosts: all
become: yes
vars:
mariadb_log_error: /var/log/mariadb/error.log
mariadb_general_log: /var/log/mariadb/general_query.log
mariadb_slow_query_log: /var/log/mariadb/slow_query.log
mariadb_binlog: mysql-bin

tasks:

• name: Ensure MariaDB is installed

yum:
name: mariadb-server
state: present

• name: Create directories for logs if they don't exist

file:
path: "{{ item }}"
state: directory
owner: mysql
group: mysql
mode: '0750'
loop:

• /var/log/mariadb

• name: Ensure log files are present

touch:
path: "{{ item }}"
state: file
owner: mysql
group: mysql
mode: '0640'
loop:

• "{{ mariadb_log_error }}"
• "{{ mariadb_general_log }}"
• "{{ mariadb_slow_query_log }}"

• name: Configure MariaDB to enable logging

lineinfile:
path: /etc/my.cnf
regexp: "^#?"
line: "{{ item }}"
backrefs: yes
loop:

• "log_error={{ mariadb_log_error }}"
• "general_log = 1"
• "general_log_file = {{ mariadb_general_log }}"
• "slow_query_log = 1"
• "slow_query_log_file = {{ mariadb_slow_query_log }}"
• "long_query_time = 2"
• "log_bin = {{ mariadb_binlog }}"
• "binlog_format = ROW"
• "expire_logs_days = 7"

notify:

• restart MariaDB

• name: Restart MariaDB to apply changes

service:
name: mariadb
state: restarted

handlers:

• name: restart MariaDB

service:
name: mariadb
state: restarted

[file-name 000057_2025-03-12_21-24-06.txt]