| Author |
Topic |
|
jordanam
Yak Posting Veteran
62 Posts |
 Posted - 2007-12-17 : 11:57:31
|
| Could I configure a cluster with both 64-bit and 32-bit SQL servers? Are there specific problems/anticipated poor behavior with this setup? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-12-17 : 12:22:55
|
| do you mean clustering a system running 64bit windows 2003 with a system running 32bit windows 2003?or do you mean running 64bit SQL 2005 and 32bit SQL 2005 together on the same 64bit Cluster?-ec |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-17 : 13:19:35
|
| Nodes must have same type of hardwares and same version of OS in the cluster. |
|
|
|
jordanam
Yak Posting Veteran
62 Posts |
Posted - 2007-12-17 : 13:45:15
|
| I think rmiao answers it, but to be more explicit, is the below configuration possible, if the hardware in each server was identical:Node 1 - Win2k3 x32, SQL 2k5 x32Node 2 - Win2k3 x32, SQL 2k5 x32Node 3 - Win2k3 x64, SQL 2k5 x64At some point, upgrading to an x64 OS and SQL distro will need to happen on a 3-node cluster. I am trying to figure out possible options. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-17 : 16:57:26
|
| No, you can't. Why don't just put 64-bit os on all nodes? |
|
|
|
jordanam
Yak Posting Veteran
62 Posts |
Posted - 2007-12-17 : 17:12:50
|
quote:
Why don't just put 64-bit os on all nodes?
I intend to, eventually. I am struggling with deciding how best to approach the cluster upgrade. Every box right now is running 32bit OS and SQL. We don't really have a spare box, and taking down the environment completely is out of the question. We also don't have anyone with expertise in clustering, and while everything I've read so far indicates it should be done by people with experience, it isn't going to be (woo!).I guess we could failover to one node on a slow day, and create a new cluster on the 64-bit servers... is it practical to create a separate cluster, and then join the third machine later? Is there a better idea? Perhaps a series of better ideas? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-17 : 17:17:02
|
| You can't mix 32-bit os and 64-bit os in same cluster, and there is no way to upgrade 32-bit os to 64-bit. Need rebuild servers and whole cluster. |
|
|
|
jordanam
Yak Posting Veteran
62 Posts |
Posted - 2007-12-18 : 10:53:20
|
quote:
is it practical to create a separate cluster, and then join the third machine later? Is there a better idea? Perhaps a series of better ideas?
Does the following plan make sense, and is it a good way to go about changing over the cluster to incur zero downtime? -Fail over my current 3 node, 3 instance cluster to 1 node-Wipe the 2 "failed" nodes, install x64 software-Create a 2-node 64-bit cluster with 3 instances-Initiate merge-replication on the x32 "failed" cluster to the 64 cluster, separating databases by instance on the new cluster, as I please-Point my applications to the 64-bit cluster-Kill the last node of my 32 bit cluster, throw on 64 bit software, and join that node to my 2-node 64 bit clusterAlthough merge replication is risky, I am trying to avoid problems incurred by slow adoption by the applications, of the new server settings. Maybe that's not the best way either? It also leaves a single point of failure if that 32bit node fails for some reason before the 2-node cluster can receive all of the replicated data.Is it possible to begin replication on a non-clustered 64-bit server, and then upgrade that to a cluster, after I free up the second computer? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-12-18 : 11:50:43
|
| You can create a 1 node cluster, just as long as you install SQL for clustering, then you can add the other nodes later. |
|
|
|
jordanam
Yak Posting Veteran
62 Posts |
Posted - 2007-12-18 : 11:56:37
|
| Cool. Thank you. |
|
|
|
|
Cluster 32-bit and 64-bit servers?