We are currently installing/configuring a new (2) two node server cluster with a SQL Server 2005 failover cluster. We have not used FactorySQL long, but we would like to take advantage of our cluster and install FactorySQL to use the cluster. I’m wondering if anyone has a step-by-step (detailed) to do this?
*FactorySQL is running on a desktop PC.
*FactorySQL project connects to our current SQL server cluster that we are upgrading (no stand-alone DB install on the PC – MySQL, etc.)
*Install FactorySQL on both nodes of new Microsoft Cluster
*Have the FactorySQL project run on the node that has control of the cluster.
*Have the second node of the cluster running the FactorySQL project in a “warm” state and then take over in the event of a failure on node 1.
I would like to know the following:
- We have already purchased a license. Do we need to purchase a second one for the second node, or are we OK with the one since node2 is only running if node 1 fails?
- I would like a detailed step-by-step procedure for installing and configuring FactorySQL to run in the desired configuration
Any help would be greatly appreciated. New SQL cluster is set to go live early next week.