March 19, 2009 at 12:19 pm
We need to configure a MSSQL Server 2005 cluster but the members of the cluster must be in two physically separated sites and therefore they must use IP addresses from different networks.
Is it possible?
If not, what should be the best way to configured database redundancy in this environment?
Thanks in advance.
Franklin.
March 19, 2009 at 1:02 pm
I think it's possible, but do you really want to have cluster in different physical locations?
They should be close-by, with a short heartbeat (private VLAN, or simply a cross-over cable)
You can do your Disaster Recovery via other methods like Log shipping, Replication, etc...
For different domains you can do it via Certificates
March 19, 2009 at 1:05 pm
cluster cannot be geographical different location. Nodes should be next to each other. Yes after that you can implement Logshipping or mirroriing for geographical failover.
:crazy: :alien:
Umar Iqbal
March 19, 2009 at 1:09 pm
Even though Windows 2008 lends itself to stretch clustering, it isn't as straightforward for SQL Server 2005 and even SQL 2008. Like Jerry mentioned, you will need to setup a vLAN to connect the SQL Servers when they are in different subnets.
March 20, 2009 at 11:11 am
Thanks you all for your replies.
So basically it is possible to do this but it is not recommend do to possible network latency and bandwidth issues between sites?
March 20, 2009 at 11:27 am
As was alluded to earlier with windows 2008 you can set up multi-site clustering using a vLAN. setting up the cluster may be different but its transparent to SQL and the users.
allied with replication at the disk level this turns clustering into a viable DR as well as HA solution.
---------------------------------------------------------------------
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply