By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

How to find who deleted rows from the table of MySQL RDS AUrora writer instance?

0

Someone deleted rows from the critical table of RDS Aurora MySQL Instance. We don't have anything in slow query log either. Is there any other way to find out or trace all the query that ran against RDS aurora Instances?

Topics
Migration & ModernizationAnalyticsDatabase
Tags
Amazon Relational Database ServiceDatabaseAmazon AuroraAurora MySQL
Language
English
rePost-User-1862618
asked 2 years ago994 views
1 Answer
1

You need to enable the audit plugin to get this sort of detail. I don't think you can retroactively find this information without it.

https://aws.amazon.com/blogs/database/configuring-an-audit-log-to-capture-database-activities-for-amazon-rds-for-mysql-and-amazon-aurora-with-mysql-compatibility/

AWS
MODERATOR
philaws
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

Relevant content