## Enable rds audit log SET GLOBAL rds_audit_log_enabled = ON; ## Test readonly variables --error ER_INCORRECT_GLOBAL_LOCAL_VAR SET GLOBAL rds_audit_log_dir = '/tmp'; ## Test other variables SET GLOBAL rds_audit_log_buffer_size = 16*1024*1024; SET GLOBAL rds_audit_log_policy = 'LOGINS'; SET GLOBAL rds_audit_log_connection_policy = 'ERRORS'; SET GLOBAL rds_audit_log_statement_policy = 'UPDATES_OR_ERRORS'; SET GLOBAL rds_audit_log_event_buffer_size = 1024*1024; SET GLOBAL rds_audit_log_flush = on; SET GLOBAL rds_audit_log_format = 'PLAIN'; SET GLOBAL rds_audit_log_row_limit = 100000; SET rds_audit_log_skip = off; SET GLOBAL rds_audit_log_strategy = 'PERFORMANCE'; --echo ## ASYNCHRONOUS strategy SET GLOBAL rds_audit_log_strategy = 'ASYNCHRONOUS'; --source suite/rds/include/rds_audit_log_plugin.inc --echo ## PERFORMANCE strategy SET GLOBAL rds_audit_log_strategy = 'PERFORMANCE'; --source suite/rds/include/rds_audit_log_plugin.inc --echo ## SEMISYNCHRONOUS strategy SET GLOBAL rds_audit_log_strategy = 'SEMISYNCHRONOUS'; --source suite/rds/include/rds_audit_log_plugin.inc --echo ## SYNCHRONOUS strategy SET GLOBAL rds_audit_log_strategy = 'SYNCHRONOUS'; --source suite/rds/include/rds_audit_log_plugin.inc ## cleanup SET GLOBAL rds_audit_log_buffer_size = default; SET GLOBAL rds_audit_log_policy = default; SET GLOBAL rds_audit_log_connection_policy = default; SET GLOBAL rds_audit_log_statement_policy = default; SET GLOBAL rds_audit_log_event_buffer_size = default; SET GLOBAL rds_audit_log_format = default; SET GLOBAL rds_audit_log_row_limit = default; SET rds_audit_log_skip = default; SET GLOBAL rds_audit_log_strategy = default; SET GLOBAL rds_audit_log_enabled = OFF;