Product Documentation

Once StrongKey has provided the permanent solution to address the replication corner-case issue, customers may want to disable Audit logging to eliminate the unneeded log files and resource consumption. Please follow the below steps to disable audit logging in MariaDB.

  1. Login into the appliance as Linux root user.
  2. Login into mysql as the root user.
  3. Turn off Audit logging.
    shell> mysql -u root -p
    MariaDB> set global server_audit_logging=OFF;
  4. Make sure the property is updated by displaying the current values of the running database as follows:
    MariaDB> show global variables like 'server_audit%';




  5. Exit out of MySQL.
  6. Edit /etc/my.cnf file using text editor and modify the server_audit_logging property to OFF – this will ensure that when MariaDB restarts, Audit logging will be disabled. You can always turn it back ON dynamically from within the mysql tool or upon a restart of MariaDB after modifying this property back to ON:
    server_audit_logging               = OFF
    server_audit_events = QUERY_DML_NO_SELECT
    server_audit_file_rotate_size = 100000000
    server_audit_file_rotations = 1000