Hi,
Can we do this:
Configuration: A 3-node SQL server cluster that uses a
majority node set (MNS) quorum. The quorum would be an MNS
quorum where the quorum is stored locally on each node's
system disk. There is no shared storage. Each node has an
internal RAID-1 mirrored disk. So it looks like just one
disk local to the node.
We want to install Windows 2003 Enterprise, SQL Server
Enterprise, the database, and the MNS quorum drive on each
local disk. Is this a supported configuration? I was
reading that the database and quorum should be on
different disks but what about and when you have an MNS
quorum?
Thanks,
Todd
Majority Node Set is not supported for SQL Clustering.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
<anonymous@.discussions.microsoft.com> wrote in message
news:2263d01c45dde$33dcd590$a601280a@.phx.gbl...
> Hi,
> Can we do this:
> Configuration: A 3-node SQL server cluster that uses a
> majority node set (MNS) quorum. The quorum would be an MNS
> quorum where the quorum is stored locally on each node's
> system disk. There is no shared storage. Each node has an
> internal RAID-1 mirrored disk. So it looks like just one
> disk local to the node.
> We want to install Windows 2003 Enterprise, SQL Server
> Enterprise, the database, and the MNS quorum drive on each
> local disk. Is this a supported configuration? I was
> reading that the database and quorum should be on
> different disks but what about and when you have an MNS
> quorum?
> Thanks,
> Todd
|||Majority Node Set is not supported for SQL Clustering.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
<anonymous@.discussions.microsoft.com> wrote in message
news:2263d01c45dde$33dcd590$a601280a@.phx.gbl...
> Hi,
> Can we do this:
> Configuration: A 3-node SQL server cluster that uses a
> majority node set (MNS) quorum. The quorum would be an MNS
> quorum where the quorum is stored locally on each node's
> system disk. There is no shared storage. Each node has an
> internal RAID-1 mirrored disk. So it looks like just one
> disk local to the node.
> We want to install Windows 2003 Enterprise, SQL Server
> Enterprise, the database, and the MNS quorum drive on each
> local disk. Is this a supported configuration? I was
> reading that the database and quorum should be on
> different disks but what about and when you have an MNS
> quorum?
> Thanks,
> Todd
Showing posts with label node. Show all posts
Showing posts with label node. Show all posts
Friday, March 23, 2012
MNS cluster / SQL
Is it possible to have a stretched cluster (MNS) across 2 datacenters running
SQL?
For example, a SAN in each datacenter with replication, and 1 node located
in each site.
We are trying to design our new datacenter infrastructure, and our IT
Director believes there is a way to have 1 node in each site, each accessing
a local SAN which replicates it's content and using a MNS cluster.
I have searched around but cannot find any info. He is also suggesting we
use Win2k8, but I can't find any info on this sort of setup. We currently
have a mix of SQL 2k5/2000.
It is possible to have a "stretch" cluster, but not using Majority Node Set.
Since SQL needs a central data repository, using MNS for the cluster qourum
creates no benefit. There are not any native tools to implement a
geocluster (as it is properly called), but third-party vendors offer some
bolt-on solutions. If we are lucky, Linchi will chime in with some answers
here. He is the best resource I know for this information. NSI's
Doubletake has a geocluster offering as does EMC's SRDF (part of their
storage systems suite).
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"daesimps" <daesimps@.discussions.microsoft.com> wrote in message
news:0043808E-D696-4A59-A557-15F648FE5D14@.microsoft.com...
> Is it possible to have a stretched cluster (MNS) across 2 datacenters
> running
> SQL?
> For example, a SAN in each datacenter with replication, and 1 node located
> in each site.
> We are trying to design our new datacenter infrastructure, and our IT
> Director believes there is a way to have 1 node in each site, each
> accessing
> a local SAN which replicates it's content and using a MNS cluster.
> I have searched around but cannot find any info. He is also suggesting we
> use Win2k8, but I can't find any info on this sort of setup. We currently
> have a mix of SQL 2k5/2000.
|||Sorry for the use of the term "stretched". I have been trying to correct the
director every time he uses that term, but it would seem it has rubbed off on
me!! :-)
Your reply seems to be along the same lines as my response to him, but you
know management. They always seem to know better than the Technical staff
they employ!
Thanks
Daesimps
"Geoff N. Hiten" wrote:
> It is possible to have a "stretch" cluster, but not using Majority Node Set.
> Since SQL needs a central data repository, using MNS for the cluster qourum
> creates no benefit. There are not any native tools to implement a
> geocluster (as it is properly called), but third-party vendors offer some
> bolt-on solutions. If we are lucky, Linchi will chime in with some answers
> here. He is the best resource I know for this information. NSI's
> Doubletake has a geocluster offering as does EMC's SRDF (part of their
> storage systems suite).
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
>
> "daesimps" <daesimps@.discussions.microsoft.com> wrote in message
> news:0043808E-D696-4A59-A557-15F648FE5D14@.microsoft.com...
>
|||Well, if you are planning on a cluster that spans two geographically
separate data centers, your director is correct in that it is a stretched
cluster. 'Stretch clusters' or geo clusters are almost always vendor
specific. EMC has a product called SRDF/CE, standing for Cluster Enabler.
Basically, what it does is to have one or more nodes in each of the two data
centers, data is replicated synchronously at disk array level via SRDF, and
SRDF/CE creates an illusion to MSCS in that the storage appears to MSCS as a
single shared drive(s). So as far as MSCS is concerned, it's a regular
Microsoft failover cluster. For many companies, the problem is often the
requirement of having the VLAN spanning two different data centers and the
network folks often don't like that idea. Fortunately, in Win2K8 the same
VLAN requirement will be dropped.
That said, I'm not sure such a stretched cluster is the best solution for
whatever DR requirements you try to meet. It's complex and over too many
layers. If you don't have SRDF already, it requires putting in place an
expensive infrastructure. Even if you already have SRDF, SRDF/CE is separate
license. Often, you can meet your DR requirements with some other
approach(es).
Linchi
"daesimps" <daesimps@.discussions.microsoft.com> wrote in message
news:FC36D7EA-9036-48A5-8086-1782CFC4394E@.microsoft.com...[vbcol=seagreen]
> Sorry for the use of the term "stretched". I have been trying to correct
> the
> director every time he uses that term, but it would seem it has rubbed off
> on
> me!! :-)
> Your reply seems to be along the same lines as my response to him, but you
> know management. They always seem to know better than the Technical staff
> they employ!
> Thanks
> Daesimps
> "Geoff N. Hiten" wrote:
|||See. I told you he was the expert.
Thanks, Linchi.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Linchi Shea" <linchi_shea@.NOSPAMml.om> wrote in message
news:%234nsIQTOIHA.4272@.TK2MSFTNGP06.phx.gbl...
> Well, if you are planning on a cluster that spans two geographically
> separate data centers, your director is correct in that it is a stretched
> cluster. 'Stretch clusters' or geo clusters are almost always vendor
> specific. EMC has a product called SRDF/CE, standing for Cluster Enabler.
> Basically, what it does is to have one or more nodes in each of the two
> data centers, data is replicated synchronously at disk array level via
> SRDF, and SRDF/CE creates an illusion to MSCS in that the storage appears
> to MSCS as a single shared drive(s). So as far as MSCS is concerned, it's
> a regular Microsoft failover cluster. For many companies, the problem is
> often the requirement of having the VLAN spanning two different data
> centers and the network folks often don't like that idea. Fortunately, in
> Win2K8 the same VLAN requirement will be dropped.
> That said, I'm not sure such a stretched cluster is the best solution for
> whatever DR requirements you try to meet. It's complex and over too many
> layers. If you don't have SRDF already, it requires putting in place an
> expensive infrastructure. Even if you already have SRDF, SRDF/CE is
> separate license. Often, you can meet your DR requirements with some other
> approach(es).
> Linchi
> "daesimps" <daesimps@.discussions.microsoft.com> wrote in message
> news:FC36D7EA-9036-48A5-8086-1782CFC4394E@.microsoft.com...
>
|||Thanks for the info. We use HP Eva 6000 Storage equipment, so we'll have to
investigate if there is an equivalent to the EMC cluster enabler.
"Geoff N. Hiten" wrote:
> See. I told you he was the expert.
> Thanks, Linchi.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "Linchi Shea" <linchi_shea@.NOSPAMml.om> wrote in message
> news:%234nsIQTOIHA.4272@.TK2MSFTNGP06.phx.gbl...
>
|||On Dec 8, 7:51 am, daesimps <daesi...@.discussions.microsoft.com>
wrote:
> Thanks for the info. We use HP Eva 6000 Storage equipment, so we'll have to
> investigate if there is an equivalent to the EMC cluster enabler.
>
> "Geoff N. Hiten" wrote:
>
>
>
>
>
>
>
>
> - Show quoted text -
What is your RTO and RPO? There are other options that are SQL
specific, including database mirroring, transactional replication, etc.
sql
SQL?
For example, a SAN in each datacenter with replication, and 1 node located
in each site.
We are trying to design our new datacenter infrastructure, and our IT
Director believes there is a way to have 1 node in each site, each accessing
a local SAN which replicates it's content and using a MNS cluster.
I have searched around but cannot find any info. He is also suggesting we
use Win2k8, but I can't find any info on this sort of setup. We currently
have a mix of SQL 2k5/2000.
It is possible to have a "stretch" cluster, but not using Majority Node Set.
Since SQL needs a central data repository, using MNS for the cluster qourum
creates no benefit. There are not any native tools to implement a
geocluster (as it is properly called), but third-party vendors offer some
bolt-on solutions. If we are lucky, Linchi will chime in with some answers
here. He is the best resource I know for this information. NSI's
Doubletake has a geocluster offering as does EMC's SRDF (part of their
storage systems suite).
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"daesimps" <daesimps@.discussions.microsoft.com> wrote in message
news:0043808E-D696-4A59-A557-15F648FE5D14@.microsoft.com...
> Is it possible to have a stretched cluster (MNS) across 2 datacenters
> running
> SQL?
> For example, a SAN in each datacenter with replication, and 1 node located
> in each site.
> We are trying to design our new datacenter infrastructure, and our IT
> Director believes there is a way to have 1 node in each site, each
> accessing
> a local SAN which replicates it's content and using a MNS cluster.
> I have searched around but cannot find any info. He is also suggesting we
> use Win2k8, but I can't find any info on this sort of setup. We currently
> have a mix of SQL 2k5/2000.
|||Sorry for the use of the term "stretched". I have been trying to correct the
director every time he uses that term, but it would seem it has rubbed off on
me!! :-)
Your reply seems to be along the same lines as my response to him, but you
know management. They always seem to know better than the Technical staff
they employ!
Thanks
Daesimps
"Geoff N. Hiten" wrote:
> It is possible to have a "stretch" cluster, but not using Majority Node Set.
> Since SQL needs a central data repository, using MNS for the cluster qourum
> creates no benefit. There are not any native tools to implement a
> geocluster (as it is properly called), but third-party vendors offer some
> bolt-on solutions. If we are lucky, Linchi will chime in with some answers
> here. He is the best resource I know for this information. NSI's
> Doubletake has a geocluster offering as does EMC's SRDF (part of their
> storage systems suite).
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
>
> "daesimps" <daesimps@.discussions.microsoft.com> wrote in message
> news:0043808E-D696-4A59-A557-15F648FE5D14@.microsoft.com...
>
|||Well, if you are planning on a cluster that spans two geographically
separate data centers, your director is correct in that it is a stretched
cluster. 'Stretch clusters' or geo clusters are almost always vendor
specific. EMC has a product called SRDF/CE, standing for Cluster Enabler.
Basically, what it does is to have one or more nodes in each of the two data
centers, data is replicated synchronously at disk array level via SRDF, and
SRDF/CE creates an illusion to MSCS in that the storage appears to MSCS as a
single shared drive(s). So as far as MSCS is concerned, it's a regular
Microsoft failover cluster. For many companies, the problem is often the
requirement of having the VLAN spanning two different data centers and the
network folks often don't like that idea. Fortunately, in Win2K8 the same
VLAN requirement will be dropped.
That said, I'm not sure such a stretched cluster is the best solution for
whatever DR requirements you try to meet. It's complex and over too many
layers. If you don't have SRDF already, it requires putting in place an
expensive infrastructure. Even if you already have SRDF, SRDF/CE is separate
license. Often, you can meet your DR requirements with some other
approach(es).
Linchi
"daesimps" <daesimps@.discussions.microsoft.com> wrote in message
news:FC36D7EA-9036-48A5-8086-1782CFC4394E@.microsoft.com...[vbcol=seagreen]
> Sorry for the use of the term "stretched". I have been trying to correct
> the
> director every time he uses that term, but it would seem it has rubbed off
> on
> me!! :-)
> Your reply seems to be along the same lines as my response to him, but you
> know management. They always seem to know better than the Technical staff
> they employ!
> Thanks
> Daesimps
> "Geoff N. Hiten" wrote:
|||See. I told you he was the expert.
Thanks, Linchi.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Linchi Shea" <linchi_shea@.NOSPAMml.om> wrote in message
news:%234nsIQTOIHA.4272@.TK2MSFTNGP06.phx.gbl...
> Well, if you are planning on a cluster that spans two geographically
> separate data centers, your director is correct in that it is a stretched
> cluster. 'Stretch clusters' or geo clusters are almost always vendor
> specific. EMC has a product called SRDF/CE, standing for Cluster Enabler.
> Basically, what it does is to have one or more nodes in each of the two
> data centers, data is replicated synchronously at disk array level via
> SRDF, and SRDF/CE creates an illusion to MSCS in that the storage appears
> to MSCS as a single shared drive(s). So as far as MSCS is concerned, it's
> a regular Microsoft failover cluster. For many companies, the problem is
> often the requirement of having the VLAN spanning two different data
> centers and the network folks often don't like that idea. Fortunately, in
> Win2K8 the same VLAN requirement will be dropped.
> That said, I'm not sure such a stretched cluster is the best solution for
> whatever DR requirements you try to meet. It's complex and over too many
> layers. If you don't have SRDF already, it requires putting in place an
> expensive infrastructure. Even if you already have SRDF, SRDF/CE is
> separate license. Often, you can meet your DR requirements with some other
> approach(es).
> Linchi
> "daesimps" <daesimps@.discussions.microsoft.com> wrote in message
> news:FC36D7EA-9036-48A5-8086-1782CFC4394E@.microsoft.com...
>
|||Thanks for the info. We use HP Eva 6000 Storage equipment, so we'll have to
investigate if there is an equivalent to the EMC cluster enabler.
"Geoff N. Hiten" wrote:
> See. I told you he was the expert.
> Thanks, Linchi.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "Linchi Shea" <linchi_shea@.NOSPAMml.om> wrote in message
> news:%234nsIQTOIHA.4272@.TK2MSFTNGP06.phx.gbl...
>
|||On Dec 8, 7:51 am, daesimps <daesi...@.discussions.microsoft.com>
wrote:
> Thanks for the info. We use HP Eva 6000 Storage equipment, so we'll have to
> investigate if there is an equivalent to the EMC cluster enabler.
>
> "Geoff N. Hiten" wrote:
>
>
>
>
>
>
>
>
> - Show quoted text -
What is your RTO and RPO? There are other options that are SQL
specific, including database mirroring, transactional replication, etc.
sql
Wednesday, March 21, 2012
Mixed mode cluster?
Does any one have experiences with Mixed mode cluster?
I am trying to add a windows 2003 node as primary node to an existing
window 2000 active passive cluster.
Here is what i did:
From WINDOWS 2000 Active/Passive SQL 2000 cluster, Evicted the PRimary node.
Loaded WINDOWS 2003 onto the primary node.
It is a new intstall of WINDOWS 2003 not upgrade from 2000 to 2003.
NOw i am trying to join this node to the cluster but it is not able to find
the cluster service on the primary node which has windows 2003.
And i get the error 0x87000b.
Thanks
Anand
Primary and Secondary nodes are a concept from SQL 7.0 and do not apply to
this situation. You need to run the cluster wizard on the Windows 2003 node
and add it to the existing cluster. This is assuming the new node has
proper access to the shared storage system.
I am not sure if it will work. The only time I have run a mixed mode
cluster was while I was upgrading the hosts. Once I upgraded, I went back
and rebuilt each node from scratch, just so I would have a clean install of
Windows 2003.
Good luck.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Anand Musunur" <AnandMusunur@.discussions.microsoft.com> wrote in message
news:33E8488F-86D5-46DD-AF7B-09E6BA5645EA@.microsoft.com...
> Does any one have experiences with Mixed mode cluster?
> I am trying to add a windows 2003 node as primary node to an existing
> window 2000 active passive cluster.
> Here is what i did:
> From WINDOWS 2000 Active/Passive SQL 2000 cluster, Evicted the PRimary
node.
> Loaded WINDOWS 2003 onto the primary node.
> It is a new intstall of WINDOWS 2003 not upgrade from 2000 to 2003.
> NOw i am trying to join this node to the cluster but it is not able to
find
> the cluster service on the primary node which has windows 2003.
> And i get the error 0x87000b.
> Thanks
> Anand
sql
I am trying to add a windows 2003 node as primary node to an existing
window 2000 active passive cluster.
Here is what i did:
From WINDOWS 2000 Active/Passive SQL 2000 cluster, Evicted the PRimary node.
Loaded WINDOWS 2003 onto the primary node.
It is a new intstall of WINDOWS 2003 not upgrade from 2000 to 2003.
NOw i am trying to join this node to the cluster but it is not able to find
the cluster service on the primary node which has windows 2003.
And i get the error 0x87000b.
Thanks
Anand
Primary and Secondary nodes are a concept from SQL 7.0 and do not apply to
this situation. You need to run the cluster wizard on the Windows 2003 node
and add it to the existing cluster. This is assuming the new node has
proper access to the shared storage system.
I am not sure if it will work. The only time I have run a mixed mode
cluster was while I was upgrading the hosts. Once I upgraded, I went back
and rebuilt each node from scratch, just so I would have a clean install of
Windows 2003.
Good luck.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Anand Musunur" <AnandMusunur@.discussions.microsoft.com> wrote in message
news:33E8488F-86D5-46DD-AF7B-09E6BA5645EA@.microsoft.com...
> Does any one have experiences with Mixed mode cluster?
> I am trying to add a windows 2003 node as primary node to an existing
> window 2000 active passive cluster.
> Here is what i did:
> From WINDOWS 2000 Active/Passive SQL 2000 cluster, Evicted the PRimary
node.
> Loaded WINDOWS 2003 onto the primary node.
> It is a new intstall of WINDOWS 2003 not upgrade from 2000 to 2003.
> NOw i am trying to join this node to the cluster but it is not able to
find
> the cluster service on the primary node which has windows 2003.
> And i get the error 0x87000b.
> Thanks
> Anand
sql
Friday, March 9, 2012
Missing Sql Server node
I have just installed Visual Studio 2005 team system beta 2 on an XP machine which had a sql server 2000 previously installed. However I do not see the Sql Servers node in Solution explorer. I do have the data connections node and can make conenctions to the server. Does anyone know what I can do to make the Sql Servers node available?
Hi Asim Shah,
You should register again almost one SQL Server there.
Good Coding!
Javier Luna
http://guydotnetxmlwebservices.blogspot.com/
Missing Sql Server node
I have just installed Visual Studio 2005 team system beta 2 on an XP machine which had a sql server 2000 previously installed. However I do not see the Sql Servers node in Solution explorer. I do have the data connections node and can make conenctions to the server. Does anyone know what I can do to make the Sql Servers node available?
Hi Asim Shah,
You should register again almost one SQL Server there.
Good Coding!
Javier Luna
http://guydotnetxmlwebservices.blogspot.com/
Wednesday, March 7, 2012
Missing perfmon SQL objects
I'm having an issue with a SQL 2000 cluster. On each node, there always
seems to be only one instance of perfmon SQL objects available at a time.
There are 3 instances of SQL installed on the cluster, default, PROD0 and
PROD1. On each physical node, opening perfmon to set up counters, there is
always only one set of SQL objects available. for example, as I write this,
only the default instance counters are available (SQLServer:<objectname>) on
the active node, but on the passive node, only the MSSQL$PROD0 objects are
available.
Any ideas?
Hello dwaine,
I understand that you could not see the performance counter in a SQL 2000
cluster environment.
You may use the following steps:
To get the counters loaded, SQL Server was taken offline and perfmon was
closed on the active node.
Simple Network Management Protocol (SNMP) service and the antivirus
software service were both stopped.
The following files were copied to the C:\Program Files\Microsoft SQL
Server\MSSQL\Binn folder:
From the SQL Server 2000 setup files: sqlctr.h
From the SQL Server 2000 sp4 setup files: sqlctr.ini and sqlctr80.dll
The following commands were run from the command prompt in the Binn folder
of the SQL Server instance:
unlodctr MSSQLServer
lodctr.exe \\VirtualServerName sqlctr.ini
net helpmsg %errorlevel%
Then, you will see the counter.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
seems to be only one instance of perfmon SQL objects available at a time.
There are 3 instances of SQL installed on the cluster, default, PROD0 and
PROD1. On each physical node, opening perfmon to set up counters, there is
always only one set of SQL objects available. for example, as I write this,
only the default instance counters are available (SQLServer:<objectname>) on
the active node, but on the passive node, only the MSSQL$PROD0 objects are
available.
Any ideas?
Hello dwaine,
I understand that you could not see the performance counter in a SQL 2000
cluster environment.
You may use the following steps:
To get the counters loaded, SQL Server was taken offline and perfmon was
closed on the active node.
Simple Network Management Protocol (SNMP) service and the antivirus
software service were both stopped.
The following files were copied to the C:\Program Files\Microsoft SQL
Server\MSSQL\Binn folder:
From the SQL Server 2000 setup files: sqlctr.h
From the SQL Server 2000 sp4 setup files: sqlctr.ini and sqlctr80.dll
The following commands were run from the command prompt in the Binn folder
of the SQL Server instance:
unlodctr MSSQLServer
lodctr.exe \\VirtualServerName sqlctr.ini
net helpmsg %errorlevel%
Then, you will see the counter.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to:
Posts (Atom)