Audit.log file rotation

MySQL & MariaDB Percona XtraDB Cluster 8.x
1

Hi all,
I would like to force a rotation of the audit.log on an instance, it wasn’t set up

Is there a way to rotate the log withour restarting the intance?
I’ve set
audit_log_rotate_on_size = 10485760
AND
mysql> set global audit_log_flush=ON;
Query OK, 0 rows affected (0.00 sec)
mysql> set global audit_log_flush=OFF;
Query OK, 0 rows affected (0.00 sec)

But nothing happens and the size remains the same.

Server version: 8.0.23-14.1 Percona XtraDB Cluster (GPL), Release rel14

Thank you for any suggestion!!

2

Hello @Frak,
I found several issues related to audit log rotation in our public JIRA There seems to be a consensus that upgrading to 8.0.30 fixed most audit rotation issues. I recommend you upgrade a replica or spin up a demo server and test in a more recent version.

1 Like