| Database Fault Tolerance solution [message #489258] |
Fri, 14 January 2011 01:48  |
 |
prashantgoel1984
Messages: 3
Registered: January 2011
|
Junior Member |
|
|
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 - Too expensive
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
