Late in 2017, our team started the journey to replicate some of our data stored in on-premise MySQL machines to AWS. This included over a billion records stored in multiple tables. The new system had to be responsive enough to transfer any new incoming data from the MySQL database to AWS with minimal latency.

The combination of AWS Kinesis with AWS Lambdas was a commonly used pattern. Here is what we learned, read more on the trivago tech blog