For the past month I've been working on a project that will help replace some of the legacy codebase. The goal is to use Aurora MySQL triggers to invoke a Lambda function whenever there's any data change in a table.
The concept goes like this: Aurora triggers my lambda, which fails to execute because of the order of events.
Since the Payload is now on an AWS Queue, we can leverage Lambda Event Sourcing to retry these messages a few more times while still leveraging another Queue as the give-up moment.
The Aurora event payload is different than the SQS payload.