Thursday, February 16, 2012

Clustering - Active / Active nodes

I do not have any experience with MS SQL. I'm a hardware engineer. I focus
mainly on the servers hardware and connectivity.
I was wondering, is it possible to cluster 2 (or more) nodes running all
nodes on active / active as a single MS SQL database system? The servers are
connecting to a common shared storage system.
Is this possible? This is more of a scale out strategy.
Thanks
I am sorry to tell you that is not. A database will only run on one machine
at a time. Clustering will not help you with this problem.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
"Alistair Wong" <Alistair Wong@.discussions.microsoft.com> wrote in message
news:DA956B40-736A-4A10-A11D-BDAAC07FDACF@.microsoft.com...
>I do not have any experience with MS SQL. I'm a hardware engineer. I focus
> mainly on the servers hardware and connectivity.
> I was wondering, is it possible to cluster 2 (or more) nodes running all
> nodes on active / active as a single MS SQL database system? The servers
> are
> connecting to a common shared storage system.
> Is this possible? This is more of a scale out strategy.
> Thanks

No comments:

Post a Comment