TrashNotes

- hosts: all
  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"