SQL Clustering with two nodes
Posted on 2009-07-08
I am in the very early stages of attempting to deploy SQL clustering (SQL Server 2008 standard) with Windows 2008 Enterprise over two nodes. I made the mistake of purchasing the equipment based on my assumption of how it would work and now I'm afraid I am missing what I need. I bought two identical HP Proliant servers with SAS harddrives and a 0/1/5 RAID controller. They each also have two NICs.
What I was not taking into account what the "shared storage" aspect of the configuration and I was working under the possibly incorrect assumption that I could use the storage on the actual servers and did not need to purchase additional hardware for the share. Is this correct?
Maybe what I want to accomplish doesn't necessarily point to clustering as the solution? Here is what I was thinking:
Two servers that would share resources (processors, memory) to run SQL Server 2008, but if one server fails (or is rebooted), the other would continue processing and no data or uptime would be lost. Is there even a technology that exists to accomplish this? My original thought was clustering with load balancing, but I don't know if that will even work.
Any feedback would be greatly appreciated.