general log vs audit log
0
A customer was asked by an auditor to enable general logs (general_log) in RDS Aurora MySQL. Recently we had an issue with this cluster and we enabled audit logs (server_audit_logs). After checking some sources it looks like if the audit log has QUERY, QUERY_DCL, QUERY_DDL, QUERY_DML enabled it should have the same info as the general log.
Is it recommended to use Audit log instead of general log in Aurora MySQL?
Language
English
asked 4 years ago1751 views
1 Answer
- Newest
- Most votes
- Most comments
0
It is. General log can be very heavy, and will profile everything, which is pretty hard on write performance. Audit log is specifically designed for auditing purpose, and is lightweight.
More info on audit log can be found here.
answered 4 years ago
Relevant content
- asked a year ago
- asked 2 years ago
AWS OFFICIALUpdated 2 years ago- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 9 months ago
What is the performance impact on the database when Audit Logging is turned on? I read that to turn off the audit (when I finish with auditing) I need to remove the audit plugin and that will restart the DB instance. https://repost.aws/knowledge-center/advanced-audit-rds-mysql-cloudwatch So I am considering to keep audit turn on.