AR vs MV
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: AR vs MV

  1. #1
    Join Date
    Dec 2002
    Posts
    62

    AR vs MV

    Hi All,

    Env.
    OS HPUX 11i
    database 9.2.0.1.0
    We have a database of 400GB. We want to replicate it to our three sites. The database on all three sites is used for Reporting only.

    1. Should we go for Master to Master for all three sites?
    2. We should go for Master to Mviews for 1:2.

    Is the option no. 2 less complicated? Will it consume less resource?

    Thanks in advance.


  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Your question is very confusing. You are asking whether you should go for advanced replication or for simple snapshot replication. What's here to ask about? If your requirements can be satisfied with snapshots, why even considering AR? If your requirements dictate the use of advanced replication, why even asking about simple snapshots?

    Is simple snapshot (MV) replication less complicated? But of course, isn't that self evident?

    Will it consume less resources? It depends on which resources you have in mind, but it is quite safe to say: YES, it will consume less resources than AR.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Dec 2002
    Posts
    62
    sorry for the confusion.
    Let me explain
    1.We donít need any DMLs on destination sites.
    2.We need to synchronize the destination site every 5 minutes
    Keeping this in mind which option is best for us "Master to master" or "Master to Mview"

  4. #4
    Join Date
    May 2001
    Posts
    736
    From your question it is clear that u are not going to have any DML at replicated site.So u can go for snapshot replication which is less complicated than the Master to Master.

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    and advanced replication is "not" transparent to any application, you have to adapt your application to it

  6. #6
    Join Date
    Dec 2002
    Posts
    62
    Thanks for your advice.
    One more query

    In comparison of multimaster, do fast refresh read only mview site
    1. need less Disk space
    2. and less memory
    3. Do they at all need master replication site.

  7. #7
    Join Date
    May 2001
    Posts
    736
    What do u mean by Master Replication site?.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width