We would like to go for clustering. Does anybody have recomendations on
Veritas clustering versus SQL server clustiring (i.e. SQL server clustering
on top of Windows clustering)
Thanks
RKShort version:
MS Clustering Yes. Veritas Clustering NO.
Veritas doesn't quite have the transparent failover thing working. MS uses
a virtual server concept so the SQL instance is completely host independent.
Veritas thinks they have that but there some areas, especially related to
SQL Server Agent and the server name, that just don't quite work as you
would expect. Veritas is a lot closer to the SQL 7.0 clustering model than
to SQL 2000. I.E. a primary node has a "partner" node that takes over in
the event of failure. SQL 2000 runs pretty much host node independent
except for install and upgrade tasks and then you only need to identify the
current host, not the original host.
To be fair, it has been a while since I did anything with Veritas clustering
so it may have gotten better. I am certain that Windows Clustering has
improved with Windows Server 2003.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"RK73" <RK73@.discussions.microsoft.com> wrote in message
news:F09F43AC-7998-4B13-B977-B215980DE228@.microsoft.com...
> We would like to go for clustering. Does anybody have recomendations on
> Veritas clustering versus SQL server clustiring (i.e. SQL server
> clustering
> on top of Windows clustering)
> Thanks
> --
> RK
Sunday, February 19, 2012
clustering - SQL Server clustering Vs Veritas Clustering
Labels:
clustering,
clusteringon,
clustiring,
database,
microsoft,
mysql,
onveritas,
oracle,
recomendations,
server,
sql,
veritas,
versus
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment