MARIADB LOG ROTATION

- general configuration file is located under /etc/logrotate.conf

- specific changes are under /etc/logrotate.d

 

By default the logrotate job is started once a day by OS cron.daily job

(/etc/cron.daily/logrotate)

 

 

database user for log rotation

CREATE USER 'logrotate'@'localhost' IDENTIFIED BY 'secret';
GRANT RELOAD ON *.* to 'logrotate'@'localhost';

 

database user information (mysql or mariadb)

#
# ~/.logrotate.cnf (chmod 600)
#

[mysql]
user     = logrotate
password = secret

 

log rotation configuration file

#
# /etc/logrotate.d/mysql
#

/var/log/mysql/error.log {
  compress
  notifempty
  size 100M
  rotate 5
  maxage 365
  postrotate
    /usr/bin/mysql --defaults-extra-file=~/.logrotate.cnf --user=logrotate --execute='FLUSH ERROR LOGS'
  endscript
}

/var/log/mysql/slow.log {
  compress
  notifempty
  weekly
  rotate 4
  maxage 30
  postrotate
    /usr/bin/mysql --defaults-extra-file=~/.logrotate.cnf --user=logrotate --execute='FLUSH SLOW LOGS'
  endscript
}

/var/log/mysql/general.log {
  compress
  notifempty
  size 1G
  rotate 3
  maxage 14
  postrotate
    /usr/bin/mysql --defaults-extra-file=~/.logrotate.cnf --user=logrotate --execute='FLUSH GENERAL LOGS'
  endscript
}

 

Testing Logrotate

/usr/sbin/logrotate /etc/logrotate.conf