Database Replication
Database replication is the process of copying a database in a special way so that two or more database copies can exchange updates of data. This exchange between databases is called synchronization. This operation is called an exchange because synchronization normally occurs in both directions, though you can choose to synchronize in one direction if you so desire. Each duplicate of the database is called a replica, which contains a common set of database objects.
The database with which you start is converted to a Design Master. Each replica is part of a replica set, which contains the Design Master and the other replicas. The Design Master is the only replica that enables you to make changes to the structure of the database. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access