Aurora RDS Audit log

0

How can I exclude "select" queries from auditing in an Aurora Mysql cluster? I want Cloudwatch to not save these queries to the log pool.

asked 2 years ago1105 views
1 Answer
1

Dear Customer,

Thanks for reaching out to AWS re:Post. Adding to the answer that was previously posted I wanted to add that excluding select in Aurora MySQL auditing with QUERY_DML is not possible out of the box natively. Excerpt from the link below->

"QUERY_DML – Similar to the QUERY event, but returns only data manipulation language (DML) queries (INSERT, UPDATE, and so on, and also SELECT)."

[] Using Advanced Auditing with an Amazon Aurora MySQL DB cluster - server_audit_events - https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Auditing.html#AuroraMySQL.Auditing.Enable.server_audit_events

Also the link below shows the demo

https://aws.amazon.com/premiumsupport/knowledge-center/rds-mysql-high-replica-lag/#:~:text=Amazon%20RDS%20for%20MySQL%20uses,you%20can%20monitor%20replication%20lag.

I sincerely hope we were able to answer your queries. We are innovating every day and your requests are duly noted by the AWS team to better and improve the services. Thank You!

AWS
EXPERT
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions