Hi Lisa,
We have been running a SQL cluster for about three years now. We use
Windows 2000 Advanced Server running SQL 2000 and have set it up in a
two machine clustered environment. The biggest reason for failover is
applying patches. We run a 24x7 operation for some of our production
databases and it's important to be able to patch the machines and reboot
them with minimal or no noticable downtime. Microsoft/SQL Clustering
works great for this.
I have had minimal problems with the failover cluster and only one or
two complaints that things were down after I reboot one or the other
server.
Downside, in SQL one machine must be primary, this means that a SQL
cluster is by definition a heartbeat cluster and not a load balancing
cluster. This doesn't seem logical to me as I could set up a SAN,
attached to both machines in the cluster, for the data and then run the
machines to load balance the network connections to the single SQL
instance. I'm sure MS has a reason for their way but it's hard to
justify having a machine sitting there doing nothing but waiting for
something to fail.
Michele
=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=
Michele Niccore
Programmer/Analyst
City of Fremont
[Email address protected]
http://www.fremont.gov
=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=
"Any sufficiently advanced technology is
indistinguishable from magic."
-Arthur C. Clarke
The scientists of today think deeply instead
of clearly. One must be sane to think clearly,
but one can think deeply and be quite insane.
-Nikola Tesla
>>> "LHale" <mssqldba-ezmlmshield-x18338504.[Email address protected]
01/30/2006 8:05:03 AM >>>
I would like to pick the brains of anyone that is successfully running
SQL
in a Clustered environment. What were the hitches? Would you recommend
doing this? Is the SQL2005 Mirroring option or logshipping a better
option?
As I stated, I just want opinions at this point. Some discussion has
come
up regarding this possibility and I wanted to have some dba input. My
personal input is biased and I wanted to see how the rest of the DBA's
out
there felt.
Thanks
Lisa Hale
SQL DBA
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page