become: true
tasks:

  • name: Create maria-log-truncate script

copy:
content: |
#!/bin/bash

rm -f /var/log/mysql/*.zst

find /var/log/mysql/ -type f -size +1M -exec zstd {} \; -exec truncate -s 0 {} \;
dest: /usr/local/bin/maria-log-truncate
mode: 0755

  • name: Ensure cron is installed

package:
name: cron
state: present

  • name: Add cron job for maria-log-truncate

cron:
name: "Weekly MySQL log truncation"
minute: "40"
hour: "03"
day: "*"
weekday: "3" # 3 соответствует среде
user: root
job: "/usr/local/bin/maria-log-truncate"

[file-name 000052_2025-03-11_22-59-33.txt]