SQL Server Performance Forum – Threads Archive
Active/Active SQL CluserHello, I have a question regardign setting up active/active SQL 2K cluster. I was able to successfully set up two active/passive clusters from the documents on this site. However, I couldn’t find any good documents on setting up an active/active one. I’m pretty sure there are some differences in setting up an active/passive vs. active/active cluster. Would you be able to tell me where the difference will be? If not could you please point me to a book or web site that will have that info. I’m assuming the difference will be the screen where you have to enter the virtual IP address. I did some research and couldn’t find anything on setting up an active/active sql cluster. Thanks in advance for your assistance. Rinu
http://www.sql-server-performance.com/sqlserver2000_clustering_install_part1.asp – states Although most of this document is applicable to installing an Active/Active configuration, the focus is on how to install an Active/Passive configuration, not an Active/Active configuration.
In typical Active/Active you need to install SQL Server on the second node by repeating the steps for Installation of SQL Server on a Cluster, which you completed on your first instance of SQL Servers Primary Node. Start the Setup program to begin your installation. After all necessary information has been entered, the Setup program installs a new instance of SQL Server binaries on the local disk of each computer in the cluster and installs the system databases on the specified cluster disk. The binaries are installed in exactly the same path on each cluster node, so you must ensure that each node has a local drive letter in common with all the other nodes in the cluster. HTH Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.