Hi, first post and im hoping a relatively straight forward fix. Im currently trying to use the audit log plugin across 3 servers and have this information feed to a kibana dashboard which has been successful on 2/3 servers. All these servers as are setup the same as they are used for replication so…

Hi, set audit_Log_flush=1 needs to be run from MySQL shell which is missing from your script. This causes the audit log file to be reopened. You have to run this inside the logrotate script, don’t add it to my.cnf file.

Hi, flush logs won’t help here. You need to set audit_log_flush in your rotation script

Hi Ivar Im sorry but I dont know if my post is clear. Audit logging is running fine all day until it hits 6am when logrotate runs and then it no longer logs to the new audit.log that Percona creates in place of the now rotated one. That is until i restart MySQL and it works again just fine. Do you…

Hi, I dont think that seems to have fixed my issue either. I have tried to incorporate what you said into my logrotate script (I have also tried it out of the if statement) Is this what you meant by incorporating?: /var/log/mysql/*log { daily rotate 7 missingok creat…

Hi, Sorry for late confirmation but it looks as though that has fixed it! A side note to anyone who is experiencing this issue is that if you set the audit_log_rotate_on_size and it rotates itself before logrotate has a chance to, this will also break it! Logrotate and audit_log_rotate_on_size ca…

Peronca Audit Log fails after Logrotate.d

MySQL & MariaDB

Ivan_Groenewold November 30, 2022, 5:15pm 5

Hi, please read the link I posted. You need to call SET audit_Log_flush=1 as part of your log rotate script, to reopen the log file after rotation. Flush logs doesn’t apply to the audit log. See also How to rotate audit log manually with audit_log plugin in Percona MySQL 8.0.20?

Topic		Replies	Views
Audit log rotation failing setting is enabled audit_log_flush=1, rotations not occurring preventing file closure Other MySQL® Questions mysql , kubernetes	7	473	March 26, 2025
How to rotate audit log manually with audit_log plugin in Percona MySQL 8.0.20? MySQL & MariaDB mysql	3	2014	March 10, 2021
Percona mysql 8.4 audit log filter component log rotation using logrotate Other MySQL® Questions	2	223	August 1, 2025
Audit log stopped working all of a sudden Percona Server for MySQL 8.0	5	1305	August 21, 2023
Audit.log file rotation Percona XtraDB Cluster 8.x mysql	1	1023	August 4, 2023

Peronca Audit Log fails after Logrotate.d

Related topics