January 16, 2005 at 9:53 pm
Hi,
I have two servers (HP Proliant DL 560) connected in a cluster environment with a storage box (MSA 500 G2). I m running a website and a virtual SQL server in the setup in active/passive mode. The cluster box is divided into 3 logical drives, one for quorum, one for storing the website and the third for sql. I have given the primary ownership of one logical drive containing the website to node 1 and the other logical drive contain sql to node 2. How do I convert the above setup into work in active/active mode. As far as I know, for active/active setup, you need to have two virtual sql servers running on both nodes. I do not want to use 2 sql servers. Also, i have got just one database which is connected to the website. I need to configure load balancing for the setup as far as server resources and network is concerned. If a WLBS needs to be installed, i want it to function for automatic failover in case any one of the node fails.
January 17, 2005 at 12:42 am
Active\Active means two SQL Server instances running. If you want to stick with only one SQL Server instance, it is Active\Passive with respect to SQL Server only (I'm not including the web server) because the literature uses Active\Passive and Active\Active when talking about SQL Server instances only.
With your current setup you can run the web server on one instance and the SQL Server on the other. You will not be able to load balance the SQL Server across both nodes. SQL Server runs on one node or the other. As far as WLBS is concerned, I'd have to go back and look at the documentation. We don't use it, preferring a 3rd party load balancer/SSL accelerator with low-end servers for web instead.
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply