TrashNotes

---
- hosts: your_mariadb_servers
  become: true
  tasks:
    - name: Установка необходимых пакетов
      yum:
        name:
          - logrotate
          - zstd
        state: present

    - name: Создание конфигурации logrotate для MariaDB
      copy:
        content: |
          /var/log/mysql/* {
            daily
            rotate 7
            compress
            compresscmd /usr/bin/zstd
            uncompresscmd /usr/bin/unzstd
            dateext
            dateformat -%Y%m%d
            missingok
            notifempty
            sharedscripts
            postrotate
              /usr/bin/systemctl reload mariadb.service > /dev/null 2>/dev/null || true
            endscript
            create 640 mysql mysql
            olddir /tmp
          }
        dest: /etc/logrotate.d/mariadb

    - name: Настройка времени запуска logrotate
      cron:
        name: "logrotate mariadb"
        minute: "45"
        hour: "1"
        job: "/usr/sbin/logrotate -s /var/lib/logrotate.status /etc/logrotate.d/mariadb"