Geographical redundency for database: What are the options?

Posted on 2011-10-24
Last Modified: 2012-05-12
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: 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
Question by:theKashyap
    LVL 73

    Accepted Solution

    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...
    LVL 76

    Assisted Solution

    by:slightwv (䄆 Netminder)
    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:
    LVL 73

    Expert Comment

    >>>  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
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    >>not entirely true.  

    Agreed.  Not that familiar with them.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
    Read about achieving the basic levels of HRIS security in the workplace.
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
    This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now