📥Change Data Capture (CDC)
Also known as CDC, Log-Based CDC
It copies each change in a database right as it is made.
Think of it like
It is like a nosy friend who writes down every change you make to your room. You never have to say what changed.
Example
A bank uses CDC on its accounts table. Each balance change reaches the fraud system in about two seconds.
Why it matters
It catches every update and every delete. A nightly copy misses those. It also puts little load on the app's database.
Definition
Common mistake
Key takeaways
- 1Read the log. Use the database's own change log.
- 2Every change. Inserts, updates and deletes.
- 3Low load. The app's database barely notices.