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?

주제

마이그레이션 및 현대화 분석 데이터베이스

태그

아마존 Relational Database Service 데이터베이스 아마존 Aurora 오로라 MySQL

언어

English

rePost-User-1862618

질문됨 일 년 전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

답변함 일 년 전

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

관련 콘텐츠