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
Thursday, February 16, 2012
Clustering - Active / Active nodes
Labels:
active,
clustering,
connectivity,
database,
engineer,
experience,
focusmainly,
hardware,
microsoft,
mysql,
nodes,
oracle,
server,
servers,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment