September 16, 2008 at 9:17 am
I am trying to build a system (Farm) where we can load balance RDP users that in turn use an application that accesses SQL 2008. The RDP part is set up well and is good. But now I am trying to figure out a way to have SQL Server on each machine, but have a common database on the SAN iSCSI box. I don't think there is a way to do this, is there?
The only option I can see at this time is to have SQL Server installed on both servers, but have one of them the active and the 2nd SQL stopped.
This keeps more load on the 1st server obviously. Then it will have to be a manual process to start the 2nd SQL if the 1st server fails.
Does clustering do load balancing or only fail over? I am wondering if I should make these servers into a cluster and SQL into a cluster too? I looked at clustering a long time ago, and I seem to remember that one machine did the work, and the 2nd one took over if the 1st one failed.
Any ideas?
September 16, 2008 at 2:02 pm
Is this read only data? If so, shared scalable databases can work.
If not, I'd look at database mirroring instead of clustering, less complex.
No real scale out solutions for SQL Server in the box.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply