Data missing from Aurora db table

Check on these main reasons and look at the article included as well.

Bear in mind that binary logs are your first way to recovery and without a correct DR policy it may be really difficult to go on with the process. Anyways here are the other culprits you could hack.

1. Check if you've enabled binary logging—it helps track changes to your data.
2. Look into your CloudTrail logs for any DELETE statements around the time of the disappearance.
3. Keep an eye on CloudWatch metrics for signs of high usage, which could signal trouble
4. Consider enabling enhanced monitoring for more detailed insights.
5. Check for any long-running transactions using the InnoDB status
6. Review your IAM policies to ensure only authorized users are making changes.
7. For future prevention, think about enabling binary logging and taking frequent snapshots.

https://repost.aws/questions/QUzuUbiPyMSgyv_84FGIojkA/how-to-find-who-deleted-rows-from-the-table-of-mysql-rds-aurora-writer-instance