What is simple replication and advance replication?

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.
How are the indexes updated?
How are the indexes updated? - Whenever a table partition is modified using a DDL command, the associated index partitions are placed in the default tablespace...
Latches vs Enqueues
Latches vs Enqueues - Enqueues permit several concurrent processes to have varying degree of sharing of resources...
Difference between a hot backup and a cold backup
Difference between a hot backup and a cold backup - A cold backup is done when there is no user activity going on with the system...
Post your comment