Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems

by Martin Kleppmann

Essentially, change data capture makes one database the leader (the one from which the changes are captured), and turns the others into followers.