AWS Resilient Pattern: Implementing Change Data Capture with Reduced Data Loss

This paper examines a proposed architecture pattern that has been evaluated to minimize data loss rates in AWS. Change Data Capture (CDC) is a methodology that detects and monitors alterations in a database, facilitating real-time or near-real-time data replication and synchronization among systems. When a CDC process is implemented within a database system, an effective failover mechanism is crucial to ensure the ongoing capture and transmission of changes. It is anticipated that some data loss may occur during the failover process. This article aims to explore the pattern designed to mitigate such data loss