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

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?

主題

遷移與現代化分析資料庫

標籤

Amazon Relational Database Service 資料庫 Amazon Aurora Aurora MySQL

語言

English

rePost-User-1862618

已提問 1 年前檢視次數 750 次

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/

管理員

philaws

已回答 1 年前

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

相關內容