Hi ,
Can we convert the Active passive cluster to Active Active mode .
Please advise .
Thanks
ARR
Its not really a conversion per se. You can install up to 16 instances per
SQL cluster.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"Aju" <ajuonline@.yahoo.com> wrote in message
news:%23Q2Leyd4EHA.2404@.TK2MSFTNGP14.phx.gbl...
> Hi ,
> Can we convert the Active passive cluster to Active Active mode .
> Please advise .
> Thanks
> ARR
>
>
|||Hi
With SQL Server 2000, Active/Active or Active/Passive is just a term used to
describe the server, and not a setup limitation.. By adding the necessary
recourses, such as file disk groups, you can turn an A/P into an A/A.
If you currently have a instance with 3 drives (E, F, and G), to create
another instance, you can not use those drives, so you need to get more
volumes on your SAN for H, I, J etc.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:#tingLe4EHA.4004@.tk2msftngp13.phx.gbl...
> Its not really a conversion per se. You can install up to 16 instances per
> SQL cluster.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://www.msmvps.com/clustering - Blog
> "Aju" <ajuonline@.yahoo.com> wrote in message
> news:%23Q2Leyd4EHA.2404@.TK2MSFTNGP14.phx.gbl...
>
|||Hi ,
Thanks for the reply .
Any other steps tobe done while installing instance on other volumes or if
we install other instance whether it will run on other node by default .
My assumption is on both node two different instances will run after adding
one more instance .
Thanks
Ajay
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:e0ODKEh4EHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi
> With SQL Server 2000, Active/Active or Active/Passive is just a term used
to[vbcol=seagreen]
> describe the server, and not a setup limitation.. By adding the necessary
> recourses, such as file disk groups, you can turn an A/P into an A/A.
> If you currently have a instance with 3 drives (E, F, and G), to create
> another instance, you can not use those drives, so you need to get more
> volumes on your SAN for H, I, J etc.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:#tingLe4EHA.4004@.tk2msftngp13.phx.gbl...
per
>
|||Except for the actual installation process, all cluster nodes in SQL 2000
are equivalent. During the installation, you run the install app from the
node that currently hosts the disk resource you intend to base the SQL
instance on. You can set the allowed and preferred hosts for each SQL
resource group independently after installation. Be sure to test running
with both instances on one node because that is what will happen during a
failure.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Aju" <ajuonline@.yahoo.com> wrote in message
news:uSwNvnq4EHA.2196@.TK2MSFTNGP14.phx.gbl...
> Hi ,
> Thanks for the reply .
> Any other steps tobe done while installing instance on other volumes or if
> we install other instance whether it will run on other node by default .
> My assumption is on both node two different instances will run after
adding[vbcol=seagreen]
> one more instance .
> Thanks
> Ajay
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:e0ODKEh4EHA.2624@.TK2MSFTNGP11.phx.gbl...
used[vbcol=seagreen]
> to
necessary
> per
>
sql
Showing posts with label convert. Show all posts
Showing posts with label convert. Show all posts
Tuesday, March 20, 2012
Sunday, March 11, 2012
Active /Pasive vs Active/Active
Hi,
we have 2 node Active/pasive cluster system, and thinking to convert it to
active/active. In order to determine all pros/Cons I'm trying to find out all
comparison issues.
Any article,comment on this, will be appreciated.
Thanks
Banu
With instances in SQL Server 2000, come two new concepts for failover clustering:
* Single instance cluster: replaces an active/passive cluster. A single instance cluster means there is one SQL Server 2000 virtual server installed.
* Multiple instance cluster: replaces an active/active cluster. A multiple instance cluster is one in which there is more than one SQL Server 2000 virtual server installed. Because of the way the implementation of
clustering is different with SQL Server 2000, using the active/active terminology does not really apply.
Here is some info that you may find helpful
Single-Instance Cluster
A single-instance cluster has only one active instance of SQL Server owned by a single server node, and all other nodes of the cluster are in a wait state. Another node is enabled in the event of a failure on the active
node, or during a manual failover for maintenance.
Multiple-Instance Cluster
A multiple-instance cluster has up to four server nodes and supports up to 16 instances (1 default, 15 named or 16 named). Each SQL Server 2000 virtual server requires its own disk resources that cannot be used by
other instances. These disk resources are the logical drive names (for example, drive F:\) used by SQL Server on which to store data and log files. Separate physical disk sets are needed to make up the logical
drive, unless your disk subsystem supports multiple logical drives on one physical drive set. SQL Server in a clustered environment also behaves differently from a stand-alone named instance in relation to IP ports.
During the installation process, a dynamic port that may be something other than 1433 is configured, and that port number is reserved for the instance.
For additional information, refer to
Microsoft Whitepaper - SQL Server 2000 Failover Clustering
http://www.microsoft.com/technet/pro.../failclus.mspx
Specifically read the following sections in the whitepaper
* Memory Configuration
-This section presents considerations for memory usage in a SQL Server 2000 failover cluster.
* Processor Capacity
* Using More Than Two Nodes
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
we have 2 node Active/pasive cluster system, and thinking to convert it to
active/active. In order to determine all pros/Cons I'm trying to find out all
comparison issues.
Any article,comment on this, will be appreciated.
Thanks
Banu
With instances in SQL Server 2000, come two new concepts for failover clustering:
* Single instance cluster: replaces an active/passive cluster. A single instance cluster means there is one SQL Server 2000 virtual server installed.
* Multiple instance cluster: replaces an active/active cluster. A multiple instance cluster is one in which there is more than one SQL Server 2000 virtual server installed. Because of the way the implementation of
clustering is different with SQL Server 2000, using the active/active terminology does not really apply.
Here is some info that you may find helpful
Single-Instance Cluster
A single-instance cluster has only one active instance of SQL Server owned by a single server node, and all other nodes of the cluster are in a wait state. Another node is enabled in the event of a failure on the active
node, or during a manual failover for maintenance.
Multiple-Instance Cluster
A multiple-instance cluster has up to four server nodes and supports up to 16 instances (1 default, 15 named or 16 named). Each SQL Server 2000 virtual server requires its own disk resources that cannot be used by
other instances. These disk resources are the logical drive names (for example, drive F:\) used by SQL Server on which to store data and log files. Separate physical disk sets are needed to make up the logical
drive, unless your disk subsystem supports multiple logical drives on one physical drive set. SQL Server in a clustered environment also behaves differently from a stand-alone named instance in relation to IP ports.
During the installation process, a dynamic port that may be something other than 1433 is configured, and that port number is reserved for the instance.
For additional information, refer to
Microsoft Whitepaper - SQL Server 2000 Failover Clustering
http://www.microsoft.com/technet/pro.../failclus.mspx
Specifically read the following sections in the whitepaper
* Memory Configuration
-This section presents considerations for memory usage in a SQL Server 2000 failover cluster.
* Processor Capacity
* Using More Than Two Nodes
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
Subscribe to:
Comments (Atom)