| Groups | Blog | Home |
sql server clustering : Change from Active\Active to Active\Passive Cluster
I have a SQL Server 2000 Cluster with Windows 2000 Server. The Cluster was set up as a Active\Active and I would like to change it to Active\Passive. What do I need to change go from Active\Active to Active\Passive?
Hi
Active/Active vs Active/Passive in SQL server tems is not correct. Active/Active = 2 SQL Server instances, one running on each node. Active/Passive = 1 SQL Server instance, running on a Node, with the other node doing nothing but waiting for a failover. Uninstall one SQL server instance and you have what you want. Any reason you want to do this? Regards Mike [quoted text, click to view] "Joe K." wrote:
> > I have a SQL Server 2000 Cluster with Windows 2000 Server. > The Cluster was set up as a Active\Active and I would like to change it to > Active\Passive. > > What do I need to change go from Active\Active to Active\Passive? >
Mike - Are you recommending not to run an active/passive cluster config?
[quoted text, click to view] "Mike Epprecht (SQL MVP)" wrote:
> Hi > > Active/Active vs Active/Passive in SQL server tems is not correct. > > Active/Active = 2 SQL Server instances, one running on each node. > Active/Passive = 1 SQL Server instance, running on a Node, with the other > node doing nothing but waiting for a failover. > > Uninstall one SQL server instance and you have what you want. Any reason you > want to do this? > > Regards > Mike > > "Joe K." wrote: > > > > > I have a SQL Server 2000 Cluster with Windows 2000 Server. > > The Cluster was set up as a Active\Active and I would like to change it to > > Active\Passive. > > > > What do I need to change go from Active\Active to Active\Passive? > >
I agree Mike. At work we use all active/passive clusters (4 total clusters
with 2 nodes in each) and run only a single instance on each active node. We are doing a mass db consolidation project now and will likely go the path of a multinode cluster as that will best suit our business needs. Do you run different coalition settings on your 4-6 instances per node? Thanks, Todd [quoted text, click to view] "Mike Epprecht (SQL MVP)" wrote:
> Hi > > No, but the decision must be based on business requirements. > If you need 2 instances of SQL Server, run them. > > At work, we use put 4-6 instances per node on a SQL Cluster (= 8-12 per 2 > node cluster). Our perspective is that having one machine do nothing is a > waste of space and energy. > > Single Instance (Active/Passive), from a licensing perspective is cheaper, > you only need to license the single node as the other node is DR and is not > active. > > 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/ > > "Todd" <Todd@discussions.microsoft.com> wrote in message > news:90355A4B-87CE-4B14-8C2C-AC0D909D1981@microsoft.com... > > Mike - Are you recommending not to run an active/passive cluster config? > > > > "Mike Epprecht (SQL MVP)" wrote: > > > > > Hi > > > > > > Active/Active vs Active/Passive in SQL server tems is not correct. > > > > > > Active/Active = 2 SQL Server instances, one running on each node. > > > Active/Passive = 1 SQL Server instance, running on a Node, with the > other > > > node doing nothing but waiting for a failover. > > > > > > Uninstall one SQL server instance and you have what you want. Any reason > you > > > want to do this? > > > > > > Regards > > > Mike > > > > > > "Joe K." wrote: > > > > > > > > > > > I have a SQL Server 2000 Cluster with Windows 2000 Server. > > > > The Cluster was set up as a Active\Active and I would like to change > it to > > > > Active\Passive. > > > > > > > > What do I need to change go from Active\Active to Active\Passive? > > > > > > > > Thanks, > >
Hi
No, but the decision must be based on business requirements. If you need 2 instances of SQL Server, run them. At work, we use put 4-6 instances per node on a SQL Cluster (= 8-12 per 2 node cluster). Our perspective is that having one machine do nothing is a waste of space and energy. Single Instance (Active/Passive), from a licensing perspective is cheaper, you only need to license the single node as the other node is DR and is not active. 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/ [quoted text, click to view] "Todd" <Todd@discussions.microsoft.com> wrote in message news:90355A4B-87CE-4B14-8C2C-AC0D909D1981@microsoft.com... > Mike - Are you recommending not to run an active/passive cluster config? > > "Mike Epprecht (SQL MVP)" wrote: > > > Hi > > > > Active/Active vs Active/Passive in SQL server tems is not correct. > > > > Active/Active = 2 SQL Server instances, one running on each node. > > Active/Passive = 1 SQL Server instance, running on a Node, with the other > > node doing nothing but waiting for a failover. > > > > Uninstall one SQL server instance and you have what you want. Any reason you > > want to do this? > > > > Regards > > Mike > > > > "Joe K." wrote: > > > > > > > > I have a SQL Server 2000 Cluster with Windows 2000 Server. > > > The Cluster was set up as a Active\Active and I would like to change it to > > > Active\Passive. > > > > > > What do I need to change go from Active\Active to Active\Passive? > > > > > > Thanks,
Hi
No, Same collation. For us, multi-instances are there for security (bank), to keep everyone away from each other. It also makes it easier to add more nodes if we need to, so we then move the instances around. Once you start to have more than 2 busy instances, you better have a decent SAN (EMC, biiiig EMC's) that can sustain the throughput. Multi fiber cards, multi paths 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/ [quoted text, click to view] "Todd" <Todd@discussions.microsoft.com> wrote in message news:23520408-C115-496C-9D33-A5313C3424C2@microsoft.com... > I agree Mike. At work we use all active/passive clusters (4 total clusters > with 2 nodes in each) and run only a single instance on each active node. We > are doing a mass db consolidation project now and will likely go the path of > a multinode cluster as that will best suit our business needs. > Do you run different coalition settings on your 4-6 instances per node? > > Thanks, > Todd > > "Mike Epprecht (SQL MVP)" wrote: > > > Hi > > > > No, but the decision must be based on business requirements. > > If you need 2 instances of SQL Server, run them. > > > > At work, we use put 4-6 instances per node on a SQL Cluster (= 8-12 per 2 > > node cluster). Our perspective is that having one machine do nothing is a > > waste of space and energy. > > > > Single Instance (Active/Passive), from a licensing perspective is cheaper, > > you only need to license the single node as the other node is DR and is not > > active. > > > > 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/ > > > > "Todd" <Todd@discussions.microsoft.com> wrote in message > > news:90355A4B-87CE-4B14-8C2C-AC0D909D1981@microsoft.com... > > > Mike - Are you recommending not to run an active/passive cluster config? > > > > > > "Mike Epprecht (SQL MVP)" wrote: > > > > > > > Hi > > > > > > > > Active/Active vs Active/Passive in SQL server tems is not correct. > > > > > > > > Active/Active = 2 SQL Server instances, one running on each node. > > > > Active/Passive = 1 SQL Server instance, running on a Node, with the > > other > > > > node doing nothing but waiting for a failover. > > > > > > > > Uninstall one SQL server instance and you have what you want. Any reason > > you > > > > want to do this? > > > > > > > > Regards > > > > Mike > > > > > > > > "Joe K." wrote: > > > > > > > > > > > > > > I have a SQL Server 2000 Cluster with Windows 2000 Server. > > > > > The Cluster was set up as a Active\Active and I would like to change > > it to > > > > > Active\Passive. > > > > > > > > > > What do I need to change go from Active\Active to Active\Passive? > > > > > > > > > > Thanks, > > > > > >
I agree 100% with Mike. I run a large N-1 cluster (N Nodes, N-1 Instances)
so I have one stand-by node for three active instances. I have scripts to change the cluster failover order depending on what maintenance is happening. I also can change memory settings and collapse the cluster on a single node during low activity times for host node maintenance. It takes a few extra steps to manage a large, multi-instance cluster, but the same principles apply. -- Geoff N. Hiten Microsoft SQL Server MVP Senior Database Administrator Careerbuilder.com I support the Professional Association for SQL Server www.sqlpass.org [quoted text, click to view] "Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message news:Ok8qLjeGFHA.3472@TK2MSFTNGP09.phx.gbl... > Hi > > No, Same collation. For us, multi-instances are there for security (bank), > to keep everyone away from each other. > It also makes it easier to add more nodes if we need to, so we then move the > instances around. > > Once you start to have more than 2 busy instances, you better have a decent > SAN (EMC, biiiig EMC's) that can sustain the throughput. Multi fiber cards, > multi paths 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/ > > "Todd" <Todd@discussions.microsoft.com> wrote in message > news:23520408-C115-496C-9D33-A5313C3424C2@microsoft.com... > > I agree Mike. At work we use all active/passive clusters (4 total > clusters > > with 2 nodes in each) and run only a single instance on each active node. > We > > are doing a mass db consolidation project now and will likely go the path > of > > a multinode cluster as that will best suit our business needs. > > Do you run different coalition settings on your 4-6 instances per node? > > > > Thanks, > > Todd > > > > "Mike Epprecht (SQL MVP)" wrote: > > > > > Hi > > > > > > No, but the decision must be based on business requirements. > > > If you need 2 instances of SQL Server, run them. > > > > > > At work, we use put 4-6 instances per node on a SQL Cluster (= 8-12 per > 2 > > > node cluster). Our perspective is that having one machine do nothing is > a > > > waste of space and energy. > > > > > > Single Instance (Active/Passive), from a licensing perspective is > cheaper, > > > you only need to license the single node as the other node is DR and is > not > > > active. > > > > > > 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/ > > > > > > "Todd" <Todd@discussions.microsoft.com> wrote in message > > > news:90355A4B-87CE-4B14-8C2C-AC0D909D1981@microsoft.com... > > > > Mike - Are you recommending not to run an active/passive cluster > config? > > > > > > > > "Mike Epprecht (SQL MVP)" wrote: > > > > > > > > > Hi > > > > > > > > > > Active/Active vs Active/Passive in SQL server tems is not correct. > > > > > > > > > > Active/Active = 2 SQL Server instances, one running on each node. > > > > > Active/Passive = 1 SQL Server instance, running on a Node, with the > > > other > > > > > node doing nothing but waiting for a failover. > > > > > > > > > > Uninstall one SQL server instance and you have what you want. Any > reason > > > you > > > > > want to do this? > > > > > > > > > > Regards > > > > > Mike > > > > > > > > > > "Joe K." wrote: > > > > > > > > > > > > > > > > > I have a SQL Server 2000 Cluster with Windows 2000 Server. > > > > > > The Cluster was set up as a Active\Active and I would like to > change > > > it to > > > > > > Active\Passive. > > > > > > > > > > > > What do I need to change go from Active\Active to Active\Passive? > > > > > > > > > > > > Thanks, > > > > > > > > > > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |