Clone

[Kutty]

Hi Julian,

I need a clarification.

I have two master site and one sanpshot site. As per my knowledge Master to master replication means transaction by transaction. And Snapshot means point in time.

But while configuring replication if I say that in every 5 minutes refresh will happen , then how it will be for master to master and master to snapshot.

1 ) Master to Master
Like suppose I have entered 2 new records in one master site. Immediately those 2 records will be refreshed in other site one by one or it will wait for next refreshment and at a time it will refresh at a time.

2) Master to snapshot

same doubt like master to master

3) Can u please give me few more idea how master to snapshot refreshment happens.
Kutty

[julian]

For multimaster replication check Metalink Note:120686.1 and the related ones.

Snapshot site: You can decide when to fast refresh the MVs, ones a day, every 5' minute, it's a up to you. And you may have half of the MV refreshed at 4AM every morning and some important tables replicated every 2nd minute.