Failsafe - Active/Active configuration
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Failsafe - Active/Active configuration

  1. #1
    Join Date
    Oct 2001
    Location
    Hornchurch, Essex UK
    Posts
    132
    Has anyone implemented an active/active configuration. We currently have one database on one node with the other node being the failover node. We're due to add another database to another failsafe group on the same server. This needs to be an active/active configuration i.e both nodes should perform some useful work. What should I do in terms of splitting resources between these databases or how do I achieve around 50% capacity on each node?

    Thanks for your help.

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    This is not possible with Oracle Fail Safe. The oracle fail safe group or groups owns ONLY to the active server. You cantīt have the oracle fail safe service started in both nodes.

    Cheers

    Angel

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Sure it is possible to do this with FailSafe. We have implemented it couple of times, it works great.

    Two servers in cluster, two instances. In normal operation each server handles its own database. When one node goes down (or if you perform manual failower), the other node takes over the faild instance and handles both databases.

    Of course FailSafe service is started only on one node (the one that owns Cluster Group). But if that node goes down FailSafe service is automaticaly started on the surviving node. But this of course does not mean that Failsafe managed databases can run only on the server on which FailSafe service is started. You can for example have FailSafe service running on node1 and both databases running on node2.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Oct 2001
    Location
    Hornchurch, Essex UK
    Posts
    132
    This is a quick summary of the configuration:

    currently svrA has a cluster group containing our database resources. svrB is the failover node. Both nodes have a share drive containing datafiles, init.oras etc.
    svrA is the preferred node.

    Plan:

    Add another cluster group to svrA and add new database. svrB will be the preferred node so it can fail over to svrA.

    I believe this is achievable because this new database will be in its own group so failing over will not affect other databases belonging to another group.

    Hope this is an active/active configuration.

    Thanks

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Yes, it is. Your plan is correct.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  6. #6
    Join Date
    Oct 2001
    Location
    Hornchurch, Essex UK
    Posts
    132
    Thanks.

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