Failsafe - Active/Active configuration

[joyce_ank]

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.

[aarroyob]

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

[jmodic]

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.

[joyce_ank]

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

[jmodic]

Yes, it is. Your plan is correct.

[joyce_ank]

Thanks.