[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 319
  • Last Modified:

Geographical redundency for database: What are the options?

We need to provide Geographical Redundancy in our project, it has massive DB (2-20 TB depending on specific customer's requirement). We have continuous in-flow of data from network (e.g. 1-20 GB per hour).

Currently we have Oracle (no RAC) with J2EE AppServer on a RHEL (Linux) cluster and SAN disks for storage, in short one DB, multiple AppServs.

What we need is Geographical Redundancy. Requirement can be summarized as, as long as things are fine 2 separate installations of our product serve 2 distinct networks (each serving one). When one of them goes down other one should serve both.

Additional notes:
We need a relational DB with SQL support, as Warehousing is one of the basic needs.
Prefer not to use hosted/cloud services like: http://aws.amazon.com/vpc/ as our customers can be extremely finicky abt security/privacy (even if the hosted/cloud services provide those).

Discounting the application logic what are the options for just replicating my data? STFW came up with only following results (as I'm no DBA expert, my interpretations might be wrong):
Surprisingly I could not find a product from Oracle for Geographical Redundancy. Oracle RAC is for a local cluster (more for horizontal scalability than redundancy).
MySQL seems to support only active-standby, when distributed. I need active-active.
Guident seems to be providing a service based on some Oracle products, but no product.

Thanks -- Kashyap
0
theKashyap
Asked:
theKashyap
  • 2
  • 2
2 Solutions
 
sdstuberCommented:
The concept in Oracle jargon (like mysql) is a "standby database"


The product you're looking for is Dataguard which is an Oracle product

You can find more information on standby database, high availability and dataguard here...

http://www.oracle.com/pls/db112/portal.portal_db?selected=14&frame=
0
 
slightwv (䄆 Netminder) Commented:
Also on the link provided above:  I would look into Streams.

The main issue with DataGuard unless you can go with Active Data Guard is the 'backup' database is idle.

With Streams Replication you can have both databases up and running.  I believe Active Data Guard is actually build on top of Streams Replication.


You can also check out GoldenGate:
http://www.oracle.com/us/products/middleware/data-integration/059240.html
0
 
sdstuberCommented:
>>>  The main issue with DataGuard unless you can go with Active Data Guard is the 'backup' database is idle.

not entirely true.  

Yes, you can use active dataguard to maintain am active standby,  but dataguard also supports logical and snapshot standbys
0
 
slightwv (䄆 Netminder) Commented:
>>not entirely true.  

Agreed.  Not that familiar with them.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now