1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Database Fault Tolerance solution

Discussion in 'Server Administration and Options' started by prashant, Jan 14, 2011.

  1. prashant

    prashant Forum Advisor

    Messages:
    85
    Likes Received:
    7
    Trophy Points:
    160
    Location:
    New Delhi, India
    Oracle Release : 11.2.0.2.0

    Hi All,

    We have the following Fault tolerance Architecture for one of our customers:-

    Site 1 (Location A)
    ===================

    1) 2 Application Servers (Weblogic 11, Active-Passive)
    2) 2 Database Servers (Dataguard Physical Standby)


    Site 2 (Location B)
    ===================

    1) 2 Application Servers (Weblogic 11, Active - Passive)
    2) 2 Database Servers (Dataguard Physical Standby)


    Following are the further details:-

    1) Site1 & Site2 are both Active and are in 2 different TimeZones(WAN connectivity).
    2) Primary Databases on both sites have Bi-Directional Stream Replication enabled (Schema Level for Production Schema).
    3) 60% of Workload is handled by Site 1 & 40% by Site 2.
    4) Like Databases, only 1 Application server is active on each site.
    5) The above configuration ensures Disaster Recovery, Load Balancing at both App & DB Layer and also fulfills the requirement of 2 Sites being in Active-Active mode.

    Now, another customer has a slightly different requirement. Site 2 will be passive and there will be no requests processed at Site 2. Thus we will have 100% workload at Site 1.

    I can think of following Architectures in this case:-

    Option 1 : Same as above Architecture
    =====================================

    Positives:

    1) Disaster Recovery
    2) Capabiltity of being converted into a Load balancing solution(Active-Active) incase required in future.

    Negatives:

    1) 3 DB Servers & 3 App Servers not being used for most of time - Server Wastage(if that's the right word)
    2) No Load Balancing

    Option 2 :
    ===========

    Site 1
    =======

    1) 2 Database Servers in RAC (Active - Active)
    2) 2 Application Servers(Active-Passive)

    Site 2
    ======

    1) 2 Database Servers (physical standby for Site 1) in RAC.
    2) 2 Application Servers (Passive)

    Positives:

    1) Disaster Recovery
    2) Load Balancing
    3) Better Server Utilization
    4) More Robust than streams

    Negatives:

    1) More Costly due to License of both RAC & DG


    Kindly let me know if there are any more Positives/negatives in these approaches.

    Also, if anyone can suggest another approach for the same.

    Please let me know if i need to post this query in a different Section.

    Thanks in advance.

    Regards,
    Prashant
     
  2. prashant

    prashant Forum Advisor

    Messages:
    85
    Likes Received:
    7
    Trophy Points:
    160
    Location:
    New Delhi, India
    Any Suggestions on this please?

    -Prashant