Replication |
|
Selecting the Replication tab opens the Replication page, which displays the available table replication and database replication options. The settings on this page are only applied to the server. Table replication allows data to be shared across databases. Changes are made by clients to the source database and then transferred to destination databases by one of two methods. The first method is synchronous replication, whereby changes to the source table are simultaneously made to the destination table. Distributed database mode must be on for synchronous table replication to work. The second method is asynchronous replication; a schedule is first defined for the distributor daemon, then SQL statements extracted from the transaction log periodically update the destination table.

Figure: The Replication Page
Related topic:
The
Main Console
Asynchronous Table Replication Settings
Database Replication Settings