Hello,
Can anyone give me a site that shows Clustering on SQL Server 2000 step by step. I am trying to have two or more servers acting as one and to get high-availability without having any impact on the application side.
The book in the link below covers all you need to know on the system configuration including the extra Cisco hardware you need and SAN(storage area network) LUNs(logical unit number) configs. Hope this helps.
http://www.amazon.com/gp/product/0072226226/102-5832747-3204160?v=glance&n=283155
|||Jim, if you don't already have one, I might suggest that you (or your company) purchase a MSDN professional subscription (or better) for you. With that, you get everything you need to install and test a fully functional Clustering Environment on your PC. Microsoft's Virtual Server will allow you to set up not only 2 virtual machines, but also a virtual shared SCSI bus that is required for clustering.
Just install Virtual Server, configure it with a shared SCSI bus, install windows 2003 server on each virtual machine (I would recommend backing up the virtual machines at this point, so you can restore to here at anytime), set up the clustering (The admin tool is pretty simple, and if you mess something up...restore from your backup), and install SQL Server 2000/5 on each machine. Then play with it. You can then test connecting a client to this and play with the failover until you fully understand what it provides, etc.
That is an excellent way of learning how clustering really works. I've used this configuration a lot when I was developing native clustering add-ins to monitor some custom stuff with failover. It works quite nice actually.
No comments:
Post a Comment