Operating System - HP-UX
1827823 Members
2090 Online
109969 Solutions
New Discussion

load balancing db servers

 
zmyle
Occasional Advisor

load balancing db servers

scenario;
-two application servers on the application clusters with load-balancing implemented together with redudancy (failover)..
-two database servers on the database cluster with only redundancy implemented
-hp storage virtual array used for the above production clusters.

problem;
-during annual peak periods (2 months ) primary database server has its processor utilisation @ 100%!!!!!!!!. Yet the resources on the standby server are idle!!!!!!

i want to know if it is possible to implement load balancing on this dbase cluster as has been done on the application cluster so that the resources are fully utilised during such periods.
Thnx

1 REPLY 1
Jeff_Traigle
Honored Contributor

Re: load balancing db servers

It depends which database product you are using. I know Oracle has Real Application Cluster (RAC), which will allow multiple nodes to access a shared set of datafiles.
--
Jeff Traigle