|
What is simple replication and advance replication?Replication is the process of creating and maintaining replicas of database objects in a distributed database system.
In simple replication, you create a snapshot, a table corresponding to the query's column list. When the snapshot is refreshed, that underlying table is populated with the results of the query. As data changes in a table in the master database, the snapshot is refreshed as scheduled and moved to the replicated database.
Advanced replication allows the simultaneous transfer of data between two or more Master Sites. There are considerations to keep in mind when using multi-master replication. The important ones are sequences (which cannot be replicated), triggers (which can turn recursive if you're not careful) and conflict resolution.
|
