I'm not completly sure how to phrase this question.
In the 2 node cluster I'm working with, I noticed that there is a database
named "Utility" on both nodes of the cluster, which confuses me. I thought an
instance was clustered, not a database, so finding the duplicate DB doesn't
make sense.
Now I understand that master, model, msdb & tempdb will be duplicated across
nodes, but these are system DBs and (I would have assumed) special. The
Utility DB is serving the function for local stuff similar to a combination
of msdb & master, but for local admin applications.
I was of the impression that an instance was clustered, not a database. So,
I don't understand how the duplicate could (or should) be there.
OK, it is clear that you "can", but what happens during a failover? It would
seem that the copy on the failed instance would be unavailable and could
cause issues.
Also, does that mean that you can have a db on a clustered instance that is
not available after a failover?
"Edwin vMierlo [MVP]" wrote:
> "JayKon" <JayKon@.discussions.microsoft.com> wrote in message
> news:9467D8C2-0970-485E-9ADF-D3DA2E4E314A@.microsoft.com...
> an
> doesn't
> across
> combination
> So,
> Yes you can,
> so "Instance1" has a database called "data1" in a cluster group called
> "Group1"
> and "Instance2" has a database called "data1" in a cluster group called
> "Group2"
> Maybe I misunderstand your post, but I do not see a problem
> rgds,
> Edwin.
>
>
|||Two different instances on the same cluster act completely independently of
each other, so the database names can all be the same or different.
No different really than if you installed two instances on a stand alone and
created a database called "myDB" on each, other than the fact that in your
cluster, each instance has its own drive resources.
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"JayKon" <JayKon@.discussions.microsoft.com> wrote in message
news:12B664B7-DF3F-4B5D-8B0F-4AA9F1B2B4E3@.microsoft.com...[vbcol=seagreen]
> OK, it is clear that you "can", but what happens during a failover? It
> would
> seem that the copy on the failed instance would be unavailable and could
> cause issues.
> Also, does that mean that you can have a db on a clustered instance that
> is
> not available after a failover?
> "Edwin vMierlo [MVP]" wrote:
|||How many instances do you have installed?
There should only be one set of system databases per instance. And, they
should be located on a "shared" physical disk. Only 1 node should have
ownership of this disk at a time; therefore, you shouldn't have multiple
copies unless you had multiple instances.
Sincerely,
Anthony Thomas
"JayKon" <JayKon@.discussions.microsoft.com> wrote in message
news:9467D8C2-0970-485E-9ADF-D3DA2E4E314A@.microsoft.com...
> I'm not completly sure how to phrase this question.
> In the 2 node cluster I'm working with, I noticed that there is a database
> named "Utility" on both nodes of the cluster, which confuses me. I thought
an
> instance was clustered, not a database, so finding the duplicate DB
doesn't
> make sense.
> Now I understand that master, model, msdb & tempdb will be duplicated
across
> nodes, but these are system DBs and (I would have assumed) special. The
> Utility DB is serving the function for local stuff similar to a
combination
> of msdb & master, but for local admin applications.
> I was of the impression that an instance was clustered, not a database.
So,
> I don't understand how the duplicate could (or should) be there.
|||It's less of a concern, than a comprension issue.
So, if I have one database per instance (what I would have expected) during
a failover, that DB will be seen by the other instance. However, if I have
the same database name on both instances, then during a failover, the local
copy will be the only visable one?
Like I sad, a compresion issue.
"Edwin vMierlo [MVP]" wrote:
> As Kevin already mentioned, after failover, there should be no difference,
> other than the two instances are online on the same physical node.
> An instance "lives" in a cluster group. The cluster group "acts" like an
> completely independent server, with it own Network Name, Ip address, disks,
> databases.
> Hope this helps to take your concerns away,
> Best Regards,
> Edwin.
> MVP - Windows Server - Clustering
>
>
> "JayKon" <JayKon@.discussions.microsoft.com> wrote in message
> news:12B664B7-DF3F-4B5D-8B0F-4AA9F1B2B4E3@.microsoft.com...
> would
> is
> database
> thought
> The
> database.
>
>
|||SQL Server instances failover, not databases. It is no difference than
running multiple instances on a stand-alone server, except instances in a
clustered configuration also differ by virtual server network name, but they
are still independent, ISOLATED binaries and databases. Nothing is "shared"
between the instances except for the cluster nodes that can potentially host
the resources.
The databases failover from one node to the other because the SQL Server
instance, network name, IP address, and disk change ownership between the
nodes. When SQL Server starts on the new host, it recovers the databases
just as if you had just restarted the services.
Sincerely,
Anthony Thomas
"JayKon" <JayKon@.discussions.microsoft.com> wrote in message
news:5EDABA97-5CC3-42BF-9EEA-A051C2A92FC7@.microsoft.com...
> It's less of a concern, than a comprension issue.
> So, if I have one database per instance (what I would have expected)
during
> a failover, that DB will be seen by the other instance. However, if I have
> the same database name on both instances, then during a failover, the
local[vbcol=seagreen]
> copy will be the only visable one?
> Like I sad, a compresion issue.
>
> "Edwin vMierlo [MVP]" wrote:
difference,[vbcol=seagreen]
disks,[vbcol=seagreen]
could[vbcol=seagreen]
that[vbcol=seagreen]
DB[vbcol=seagreen]
duplicated[vbcol=seagreen]
special.[vbcol=seagreen]
called[vbcol=seagreen]
called[vbcol=seagreen]
Showing posts with label nodes. Show all posts
Showing posts with label nodes. Show all posts
Tuesday, March 27, 2012
Saturday, February 11, 2012
4 Queries about DB clustering
Hi, Below are few queries:
1. Say for 2 nodes cluster, Do we need to have 2 copies of Databases( 1 on
each node)
2. Hows does the data Synchronization between different nodes of databases
takes place?
3. In Active/Passive mode, does the passive node database is exactly in the
same state (in terms of data) as that of Active?
4. Is 'Server Cluster' specifically for DB clustering ?
Thanks in advance,
Pankaj A. Chitriv
Answers Inline
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pankaj" <pankajchitriv@.rediffmail.com(donotspam)> wrote in message
news:847A2BE3-74E1-4B9E-9D61-EEE40D117155@.microsoft.com...
> Hi, Below are few queries:
> 1. Say for 2 nodes cluster, Do we need to have 2 copies of Databases( 1 on
> each node)
No. Data is on shared storage and is controlled by one node at a time.
> 2. Hows does the data Synchronization between different nodes of databases
> takes place?
There is no synchronization. There is a single data store. Access to this
store is arbitrated by the cluster software.
> 3. In Active/Passive mode, does the passive node database is exactly in
the
> same state (in terms of data) as that of Active?
>
Clustering is failover not scaleout technology.
> 4. Is 'Server Cluster' specifically for DB clustering ?
I am not sure what you mean by "Server Cluster"?
> Thanks in advance,
> Pankaj A. Chitriv
>
|||Thanks Geoff.
"Server Cluster" is a inbuild clustering service provided by Windows 2003
Server.
Just wondering, whether that Single Data Store is a seperate windows system?
If so what if that system breaks down? Is that the case that we do DB
clustering only to distribute the processing capabilities?
What I understood by Single Data Store means is there will be a system on
which SQL DB will be created and there would be multiple servers accessing
the same database. But this cannot be called as DB clustering as we don't
have to configure any VIP to access the single data store. Can you clarify
this please?
Thanks a lot again for your answers.
Regards
Pankaj A. Chitriv
"Geoff N. Hiten" wrote:
> Answers Inline
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pankaj" <pankajchitriv@.rediffmail.com(donotspam)> wrote in message
> news:847A2BE3-74E1-4B9E-9D61-EEE40D117155@.microsoft.com...
> No. Data is on shared storage and is controlled by one node at a time.
> There is no synchronization. There is a single data store. Access to this
> store is arbitrated by the cluster software.
> the
> Clustering is failover not scaleout technology.
> I am not sure what you mean by "Server Cluster"?
>
>
|||Server clustering is available on Windows Server 2003 Enterprise Edition.
"Single Data Store" is not a service, it is a description. All data resides
on a single logical device physically connected to all host nodes. This can
be a SCSI array, a Fiber array, or a SAN. Ownership of this device is
arbitrated by the cluster service. Microsoft SQL DB clustering exists as a
failover technology only and has no distributed computing capabilities. It
is not a scale-out technology. One server owns the entire database and no
other server can access the data without moving the entire SQL instance to
another host. Active-Passive and Active-Active are not accurate
descriptions of the current SQL clustering technology but are somewhat
misleading holdovers from an earlier version.
Again, clustering is for availability and does not allow multiple
simultaneous connections to the data store from different host nodes.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pankaj" <pankajchitriv@.rediffmail.com(donotspam)> wrote in message
news:4A51BB01-D028-4B3B-9244-12EFA8469987@.microsoft.com...
> Thanks Geoff.
> "Server Cluster" is a inbuild clustering service provided by Windows 2003
> Server.
> Just wondering, whether that Single Data Store is a seperate windows
system?[vbcol=seagreen]
> If so what if that system breaks down? Is that the case that we do DB
> clustering only to distribute the processing capabilities?
> What I understood by Single Data Store means is there will be a system on
> which SQL DB will be created and there would be multiple servers accessing
> the same database. But this cannot be called as DB clustering as we don't
> have to configure any VIP to access the single data store. Can you clarify
> this please?
> Thanks a lot again for your answers.
> Regards
> Pankaj A. Chitriv
> "Geoff N. Hiten" wrote:
Databases( 1 on[vbcol=seagreen]
databases[vbcol=seagreen]
this[vbcol=seagreen]
in[vbcol=seagreen]
|||Hi Geoff.
Thankyou very much for your help. It is just great. I really really
appreciate it.
Further, to summarise our discussion what I understood to implement the SQL
Db Cluster is:
1. I need to have SCSI array, a Fiber array, or a SAN as a shared device
"on which I'll install SQL Server Database".
2. Say in a 2 node cluster, both the nodes would be typically Windows 2k3
Server systems, with the SQL Server Instance reference (SQL Client) to the
shared device on which SQL Server is installed.
3. Say in Active / Passive mode, only 1 Win2k3 system will be utilized and
in case of faliure, the other win2k3 server node will be active.
4. I need to install SQL Client on both the nodes and Sql Server on shared
device.
5. Just wondering whether stored procedures of SQL DB will be executed on
the shared drive or on the Node. Does the shared drive have processing
capabilities?
With this queries clarified , I'm ready to shoot :-).
I really appreciate your help and request your comment on above queries.
Regards,
Pankaj A. Chitriv
"Geoff N. Hiten" wrote:
> Server clustering is available on Windows Server 2003 Enterprise Edition.
> "Single Data Store" is not a service, it is a description. All data resides
> on a single logical device physically connected to all host nodes. This can
> be a SCSI array, a Fiber array, or a SAN. Ownership of this device is
> arbitrated by the cluster service. Microsoft SQL DB clustering exists as a
> failover technology only and has no distributed computing capabilities. It
> is not a scale-out technology. One server owns the entire database and no
> other server can access the data without moving the entire SQL instance to
> another host. Active-Passive and Active-Active are not accurate
> descriptions of the current SQL clustering technology but are somewhat
> misleading holdovers from an earlier version.
> Again, clustering is for availability and does not allow multiple
> simultaneous connections to the data store from different host nodes.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pankaj" <pankajchitriv@.rediffmail.com(donotspam)> wrote in message
> news:4A51BB01-D028-4B3B-9244-12EFA8469987@.microsoft.com...
> system?
> Databases( 1 on
> databases
> this
> in
>
>
|||You are getting closer. More comments inline.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pankaj" <pankajchitriv@.rediffmail.com(donotspam)> wrote in message
news:1D8FA145-7AF2-4EBE-9FA1-FD9822233F81@.microsoft.com...
> Hi Geoff.
> Thankyou very much for your help. It is just great. I really really
> appreciate it.
> Further, to summarise our discussion what I understood to implement the
SQL
> Db Cluster is:
> 1. I need to have SCSI array, a Fiber array, or a SAN as a shared device
> "on which I'll install SQL Server Database".
The database(s) will live on the shared storage. SQL binaries will live on
the local disks of each cluster host.
> 2. Say in a 2 node cluster, both the nodes would be typically Windows 2k3
> Server systems, with the SQL Server Instance reference (SQL Client) to the
> shared device on which SQL Server is installed.
A basic two-node SQL cluster will have four systems visible. There are the
two physical host nodes. There is the cluster vrtual server itself. There
is the SQL Server virtual server. Each virtual system must have a minimum
of one unique IP address, one unique network name, and a physical disk
device located on the shared array. You access the SQL server by connecting
to the virtual server by name or IP address.
>
> 3. Say in Active / Passive mode, only 1 Win2k3 system will be utilized and
> in case of faliure, the other win2k3 server node will be active.
>
Correct. The current terms are single-instance and multi-instance. Each
new instance of SQL will have its own disk(s), IP address(es), and Network
name. Once an instance is installed, you can set the preferred host order
to determine the "normal" home host for that instance. You can have up to
16 instances on a single cluster.
> 4. I need to install SQL Client on both the nodes and Sql Server on shared
> device.
>
First you install MSCS (Clustering). Windows 2003 has an excellent
clustering wizard that makes it very difficult to create a non-working
cluster. Then you install a clustered instance of SQL server, running the
install CD from the node that currently owns the disk resource you wish to
use as the first SQL disk. You can assign additional disks after
installation. The installer writes the executable files to each host node
you choose as part of the installation. This includes server and client
components.
> 5. Just wondering whether stored procedures of SQL DB will be executed on
> the shared drive or on the Node. Does the shared drive have processing
> capabilities?
The binaries are on each host node. The memory and CPU resources come from
the host node. The data is stored on the shared array. SQL uses a "Shared
Nothing" model so after installation you can run any instance from any host
node, regardless of whether any other node or instance is running.
[vbcol=seagreen]
> With this queries clarified , I'm ready to shoot :-).
> I really appreciate your help and request your comment on above queries.
> Regards,
> Pankaj A. Chitriv
>
>
> "Geoff N. Hiten" wrote:
Edition.[vbcol=seagreen]
resides[vbcol=seagreen]
can[vbcol=seagreen]
as a[vbcol=seagreen]
It[vbcol=seagreen]
no[vbcol=seagreen]
to[vbcol=seagreen]
2003[vbcol=seagreen]
on[vbcol=seagreen]
accessing[vbcol=seagreen]
don't[vbcol=seagreen]
clarify[vbcol=seagreen]
time.[vbcol=seagreen]
to[vbcol=seagreen]
exactly[vbcol=seagreen]
|||I have a question for Geoff.
I have a similar situation where I plan to install/configure multi-instance
cluster.
My question is
a) as we plan to use/assign drive letters what care shoud be taken for
multi-instance cluster (3 active 1, passive/standby)?
Thanks.
Kamal.
"Geoff N. Hiten" wrote:
> You are getting closer. More comments inline.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pankaj" <pankajchitriv@.rediffmail.com(donotspam)> wrote in message
> news:1D8FA145-7AF2-4EBE-9FA1-FD9822233F81@.microsoft.com...
> SQL
> The database(s) will live on the shared storage. SQL binaries will live on
> the local disks of each cluster host.
> A basic two-node SQL cluster will have four systems visible. There are the
> two physical host nodes. There is the cluster vrtual server itself. There
> is the SQL Server virtual server. Each virtual system must have a minimum
> of one unique IP address, one unique network name, and a physical disk
> device located on the shared array. You access the SQL server by connecting
> to the virtual server by name or IP address.
> Correct. The current terms are single-instance and multi-instance. Each
> new instance of SQL will have its own disk(s), IP address(es), and Network
> name. Once an instance is installed, you can set the preferred host order
> to determine the "normal" home host for that instance. You can have up to
> 16 instances on a single cluster.
> First you install MSCS (Clustering). Windows 2003 has an excellent
> clustering wizard that makes it very difficult to create a non-working
> cluster. Then you install a clustered instance of SQL server, running the
> install CD from the node that currently owns the disk resource you wish to
> use as the first SQL disk. You can assign additional disks after
> installation. The installer writes the executable files to each host node
> you choose as part of the installation. This includes server and client
> components.
>
> The binaries are on each host node. The memory and CPU resources come from
> the host node. The data is stored on the shared array. SQL uses a "Shared
> Nothing" model so after installation you can run any instance from any host
> node, regardless of whether any other node or instance is running.
> Edition.
> resides
> can
> as a
> It
> no
> to
> 2003
> on
> accessing
> don't
> clarify
> time.
> to
> exactly
>
>
|||All drives will need to be visible to all hosts for failover. Drive letters
are assigned cluster-wide for shared resources. The easiest way is to
pretend you are building a multi-instance stand-alone system where SQL Data
and Logs from multiple instances cannot intersect on the same LUN. Also
remember to add a drive for MSDTC and for the Quorum. Don't forget to leave
room for expansion.
Example
C for local boot, Z for local CD-ROM (Old Novell habit)
Q for Quorum, M for MSDTC
K,L for SQLInstance1 data and logs respectively
R,S for SQLInstance2 data and logs respectively
lather, rinse, repeat.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Kamal Hassan" <KamalHassan@.discussions.microsoft.com> wrote in message
news:5D8375C6-8269-46FC-B619-BD75E0F8A6CD@.microsoft.com...
> I have a question for Geoff.
> I have a similar situation where I plan to install/configure
multi-instance[vbcol=seagreen]
> cluster.
> My question is
> a) as we plan to use/assign drive letters what care shoud be taken for
> multi-instance cluster (3 active 1, passive/standby)?
> Thanks.
> Kamal.
>
>
> "Geoff N. Hiten" wrote:
the[vbcol=seagreen]
device[vbcol=seagreen]
on[vbcol=seagreen]
2k3[vbcol=seagreen]
the[vbcol=seagreen]
the[vbcol=seagreen]
There[vbcol=seagreen]
minimum[vbcol=seagreen]
connecting[vbcol=seagreen]
and[vbcol=seagreen]
Each[vbcol=seagreen]
Network[vbcol=seagreen]
order[vbcol=seagreen]
to[vbcol=seagreen]
shared[vbcol=seagreen]
the[vbcol=seagreen]
to[vbcol=seagreen]
node[vbcol=seagreen]
on[vbcol=seagreen]
processing[vbcol=seagreen]
from[vbcol=seagreen]
"Shared[vbcol=seagreen]
host[vbcol=seagreen]
queries.[vbcol=seagreen]
This[vbcol=seagreen]
is[vbcol=seagreen]
exists[vbcol=seagreen]
capabilities.[vbcol=seagreen]
and[vbcol=seagreen]
instance[vbcol=seagreen]
somewhat[vbcol=seagreen]
nodes.[vbcol=seagreen]
Windows[vbcol=seagreen]
windows[vbcol=seagreen]
DB[vbcol=seagreen]
system[vbcol=seagreen]
we[vbcol=seagreen]
message[vbcol=seagreen]
a[vbcol=seagreen]
of[vbcol=seagreen]
Access[vbcol=seagreen]
|||First, manythanks for quick reply.
In your suggestion is the SQLinstance1 and SQLInstance refer to as ACTIVE
nodes with StandyBy Server or ?
We are not using MSDTC do we still have to setup/configure? and what do you
mean don't forget to leave for expnasion?
Thanks a lot!
Kamal.
"Geoff N. Hiten" wrote:
> All drives will need to be visible to all hosts for failover. Drive letters
> are assigned cluster-wide for shared resources. The easiest way is to
> pretend you are building a multi-instance stand-alone system where SQL Data
> and Logs from multiple instances cannot intersect on the same LUN. Also
> remember to add a drive for MSDTC and for the Quorum. Don't forget to leave
> room for expansion.
> Example
> C for local boot, Z for local CD-ROM (Old Novell habit)
> Q for Quorum, M for MSDTC
> K,L for SQLInstance1 data and logs respectively
> R,S for SQLInstance2 data and logs respectively
> lather, rinse, repeat.
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Kamal Hassan" <KamalHassan@.discussions.microsoft.com> wrote in message
> news:5D8375C6-8269-46FC-B619-BD75E0F8A6CD@.microsoft.com...
> multi-instance
> the
> device
> on
> 2k3
> the
> the
> There
> minimum
> connecting
> and
> Each
> Network
> order
> to
> shared
> the
> to
> node
> on
> processing
> from
> "Shared
> host
> queries.
> This
> is
> exists
> capabilities.
> and
> instance
> somewhat
> nodes.
> Windows
> windows
> DB
> system
> we
> message
> a
> of
> Access
>
>
|||Active\Active and Active\Passive are not accurate terms. Each SQL instance
is its own virtual server.
SQLInstance1 and 2 refer to the SQL virtual servers\instances. The host
nodes are all configured identically.
You will have to add disk storage sometime down the road. Leave empty drive
letters for adding new disk resources.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Kamal Hassan" <KamalHassan@.discussions.microsoft.com> wrote in message
news:DD172480-C6FA-41A6-86CC-65A2C790D3C6@.microsoft.com...
> First, manythanks for quick reply.
> In your suggestion is the SQLinstance1 and SQLInstance refer to as ACTIVE
> nodes with StandyBy Server or ?
> We are not using MSDTC do we still have to setup/configure? and what do
you[vbcol=seagreen]
> mean don't forget to leave for expnasion?
> Thanks a lot!
> Kamal.
>
> "Geoff N. Hiten" wrote:
letters[vbcol=seagreen]
Data[vbcol=seagreen]
leave[vbcol=seagreen]
really[vbcol=seagreen]
implement[vbcol=seagreen]
live[vbcol=seagreen]
Windows[vbcol=seagreen]
Client) to[vbcol=seagreen]
are[vbcol=seagreen]
disk[vbcol=seagreen]
utilized[vbcol=seagreen]
up[vbcol=seagreen]
on[vbcol=seagreen]
non-working[vbcol=seagreen]
running[vbcol=seagreen]
wish[vbcol=seagreen]
host[vbcol=seagreen]
client[vbcol=seagreen]
executed[vbcol=seagreen]
come[vbcol=seagreen]
any[vbcol=seagreen]
data[vbcol=seagreen]
nodes.[vbcol=seagreen]
device[vbcol=seagreen]
database[vbcol=seagreen]
multiple[vbcol=seagreen]
message[vbcol=seagreen]
we do[vbcol=seagreen]
a[vbcol=seagreen]
servers[vbcol=seagreen]
as[vbcol=seagreen]
you[vbcol=seagreen]
at[vbcol=seagreen]
nodes[vbcol=seagreen]
is[vbcol=seagreen]
1. Say for 2 nodes cluster, Do we need to have 2 copies of Databases( 1 on
each node)
2. Hows does the data Synchronization between different nodes of databases
takes place?
3. In Active/Passive mode, does the passive node database is exactly in the
same state (in terms of data) as that of Active?
4. Is 'Server Cluster' specifically for DB clustering ?
Thanks in advance,
Pankaj A. Chitriv
Answers Inline
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pankaj" <pankajchitriv@.rediffmail.com(donotspam)> wrote in message
news:847A2BE3-74E1-4B9E-9D61-EEE40D117155@.microsoft.com...
> Hi, Below are few queries:
> 1. Say for 2 nodes cluster, Do we need to have 2 copies of Databases( 1 on
> each node)
No. Data is on shared storage and is controlled by one node at a time.
> 2. Hows does the data Synchronization between different nodes of databases
> takes place?
There is no synchronization. There is a single data store. Access to this
store is arbitrated by the cluster software.
> 3. In Active/Passive mode, does the passive node database is exactly in
the
> same state (in terms of data) as that of Active?
>
Clustering is failover not scaleout technology.
> 4. Is 'Server Cluster' specifically for DB clustering ?
I am not sure what you mean by "Server Cluster"?
> Thanks in advance,
> Pankaj A. Chitriv
>
|||Thanks Geoff.
"Server Cluster" is a inbuild clustering service provided by Windows 2003
Server.
Just wondering, whether that Single Data Store is a seperate windows system?
If so what if that system breaks down? Is that the case that we do DB
clustering only to distribute the processing capabilities?
What I understood by Single Data Store means is there will be a system on
which SQL DB will be created and there would be multiple servers accessing
the same database. But this cannot be called as DB clustering as we don't
have to configure any VIP to access the single data store. Can you clarify
this please?
Thanks a lot again for your answers.
Regards
Pankaj A. Chitriv
"Geoff N. Hiten" wrote:
> Answers Inline
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pankaj" <pankajchitriv@.rediffmail.com(donotspam)> wrote in message
> news:847A2BE3-74E1-4B9E-9D61-EEE40D117155@.microsoft.com...
> No. Data is on shared storage and is controlled by one node at a time.
> There is no synchronization. There is a single data store. Access to this
> store is arbitrated by the cluster software.
> the
> Clustering is failover not scaleout technology.
> I am not sure what you mean by "Server Cluster"?
>
>
|||Server clustering is available on Windows Server 2003 Enterprise Edition.
"Single Data Store" is not a service, it is a description. All data resides
on a single logical device physically connected to all host nodes. This can
be a SCSI array, a Fiber array, or a SAN. Ownership of this device is
arbitrated by the cluster service. Microsoft SQL DB clustering exists as a
failover technology only and has no distributed computing capabilities. It
is not a scale-out technology. One server owns the entire database and no
other server can access the data without moving the entire SQL instance to
another host. Active-Passive and Active-Active are not accurate
descriptions of the current SQL clustering technology but are somewhat
misleading holdovers from an earlier version.
Again, clustering is for availability and does not allow multiple
simultaneous connections to the data store from different host nodes.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pankaj" <pankajchitriv@.rediffmail.com(donotspam)> wrote in message
news:4A51BB01-D028-4B3B-9244-12EFA8469987@.microsoft.com...
> Thanks Geoff.
> "Server Cluster" is a inbuild clustering service provided by Windows 2003
> Server.
> Just wondering, whether that Single Data Store is a seperate windows
system?[vbcol=seagreen]
> If so what if that system breaks down? Is that the case that we do DB
> clustering only to distribute the processing capabilities?
> What I understood by Single Data Store means is there will be a system on
> which SQL DB will be created and there would be multiple servers accessing
> the same database. But this cannot be called as DB clustering as we don't
> have to configure any VIP to access the single data store. Can you clarify
> this please?
> Thanks a lot again for your answers.
> Regards
> Pankaj A. Chitriv
> "Geoff N. Hiten" wrote:
Databases( 1 on[vbcol=seagreen]
databases[vbcol=seagreen]
this[vbcol=seagreen]
in[vbcol=seagreen]
|||Hi Geoff.
Thankyou very much for your help. It is just great. I really really
appreciate it.
Further, to summarise our discussion what I understood to implement the SQL
Db Cluster is:
1. I need to have SCSI array, a Fiber array, or a SAN as a shared device
"on which I'll install SQL Server Database".
2. Say in a 2 node cluster, both the nodes would be typically Windows 2k3
Server systems, with the SQL Server Instance reference (SQL Client) to the
shared device on which SQL Server is installed.
3. Say in Active / Passive mode, only 1 Win2k3 system will be utilized and
in case of faliure, the other win2k3 server node will be active.
4. I need to install SQL Client on both the nodes and Sql Server on shared
device.
5. Just wondering whether stored procedures of SQL DB will be executed on
the shared drive or on the Node. Does the shared drive have processing
capabilities?
With this queries clarified , I'm ready to shoot :-).
I really appreciate your help and request your comment on above queries.
Regards,
Pankaj A. Chitriv
"Geoff N. Hiten" wrote:
> Server clustering is available on Windows Server 2003 Enterprise Edition.
> "Single Data Store" is not a service, it is a description. All data resides
> on a single logical device physically connected to all host nodes. This can
> be a SCSI array, a Fiber array, or a SAN. Ownership of this device is
> arbitrated by the cluster service. Microsoft SQL DB clustering exists as a
> failover technology only and has no distributed computing capabilities. It
> is not a scale-out technology. One server owns the entire database and no
> other server can access the data without moving the entire SQL instance to
> another host. Active-Passive and Active-Active are not accurate
> descriptions of the current SQL clustering technology but are somewhat
> misleading holdovers from an earlier version.
> Again, clustering is for availability and does not allow multiple
> simultaneous connections to the data store from different host nodes.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pankaj" <pankajchitriv@.rediffmail.com(donotspam)> wrote in message
> news:4A51BB01-D028-4B3B-9244-12EFA8469987@.microsoft.com...
> system?
> Databases( 1 on
> databases
> this
> in
>
>
|||You are getting closer. More comments inline.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pankaj" <pankajchitriv@.rediffmail.com(donotspam)> wrote in message
news:1D8FA145-7AF2-4EBE-9FA1-FD9822233F81@.microsoft.com...
> Hi Geoff.
> Thankyou very much for your help. It is just great. I really really
> appreciate it.
> Further, to summarise our discussion what I understood to implement the
SQL
> Db Cluster is:
> 1. I need to have SCSI array, a Fiber array, or a SAN as a shared device
> "on which I'll install SQL Server Database".
The database(s) will live on the shared storage. SQL binaries will live on
the local disks of each cluster host.
> 2. Say in a 2 node cluster, both the nodes would be typically Windows 2k3
> Server systems, with the SQL Server Instance reference (SQL Client) to the
> shared device on which SQL Server is installed.
A basic two-node SQL cluster will have four systems visible. There are the
two physical host nodes. There is the cluster vrtual server itself. There
is the SQL Server virtual server. Each virtual system must have a minimum
of one unique IP address, one unique network name, and a physical disk
device located on the shared array. You access the SQL server by connecting
to the virtual server by name or IP address.
>
> 3. Say in Active / Passive mode, only 1 Win2k3 system will be utilized and
> in case of faliure, the other win2k3 server node will be active.
>
Correct. The current terms are single-instance and multi-instance. Each
new instance of SQL will have its own disk(s), IP address(es), and Network
name. Once an instance is installed, you can set the preferred host order
to determine the "normal" home host for that instance. You can have up to
16 instances on a single cluster.
> 4. I need to install SQL Client on both the nodes and Sql Server on shared
> device.
>
First you install MSCS (Clustering). Windows 2003 has an excellent
clustering wizard that makes it very difficult to create a non-working
cluster. Then you install a clustered instance of SQL server, running the
install CD from the node that currently owns the disk resource you wish to
use as the first SQL disk. You can assign additional disks after
installation. The installer writes the executable files to each host node
you choose as part of the installation. This includes server and client
components.
> 5. Just wondering whether stored procedures of SQL DB will be executed on
> the shared drive or on the Node. Does the shared drive have processing
> capabilities?
The binaries are on each host node. The memory and CPU resources come from
the host node. The data is stored on the shared array. SQL uses a "Shared
Nothing" model so after installation you can run any instance from any host
node, regardless of whether any other node or instance is running.
[vbcol=seagreen]
> With this queries clarified , I'm ready to shoot :-).
> I really appreciate your help and request your comment on above queries.
> Regards,
> Pankaj A. Chitriv
>
>
> "Geoff N. Hiten" wrote:
Edition.[vbcol=seagreen]
resides[vbcol=seagreen]
can[vbcol=seagreen]
as a[vbcol=seagreen]
It[vbcol=seagreen]
no[vbcol=seagreen]
to[vbcol=seagreen]
2003[vbcol=seagreen]
on[vbcol=seagreen]
accessing[vbcol=seagreen]
don't[vbcol=seagreen]
clarify[vbcol=seagreen]
time.[vbcol=seagreen]
to[vbcol=seagreen]
exactly[vbcol=seagreen]
|||I have a question for Geoff.
I have a similar situation where I plan to install/configure multi-instance
cluster.
My question is
a) as we plan to use/assign drive letters what care shoud be taken for
multi-instance cluster (3 active 1, passive/standby)?
Thanks.
Kamal.
"Geoff N. Hiten" wrote:
> You are getting closer. More comments inline.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pankaj" <pankajchitriv@.rediffmail.com(donotspam)> wrote in message
> news:1D8FA145-7AF2-4EBE-9FA1-FD9822233F81@.microsoft.com...
> SQL
> The database(s) will live on the shared storage. SQL binaries will live on
> the local disks of each cluster host.
> A basic two-node SQL cluster will have four systems visible. There are the
> two physical host nodes. There is the cluster vrtual server itself. There
> is the SQL Server virtual server. Each virtual system must have a minimum
> of one unique IP address, one unique network name, and a physical disk
> device located on the shared array. You access the SQL server by connecting
> to the virtual server by name or IP address.
> Correct. The current terms are single-instance and multi-instance. Each
> new instance of SQL will have its own disk(s), IP address(es), and Network
> name. Once an instance is installed, you can set the preferred host order
> to determine the "normal" home host for that instance. You can have up to
> 16 instances on a single cluster.
> First you install MSCS (Clustering). Windows 2003 has an excellent
> clustering wizard that makes it very difficult to create a non-working
> cluster. Then you install a clustered instance of SQL server, running the
> install CD from the node that currently owns the disk resource you wish to
> use as the first SQL disk. You can assign additional disks after
> installation. The installer writes the executable files to each host node
> you choose as part of the installation. This includes server and client
> components.
>
> The binaries are on each host node. The memory and CPU resources come from
> the host node. The data is stored on the shared array. SQL uses a "Shared
> Nothing" model so after installation you can run any instance from any host
> node, regardless of whether any other node or instance is running.
> Edition.
> resides
> can
> as a
> It
> no
> to
> 2003
> on
> accessing
> don't
> clarify
> time.
> to
> exactly
>
>
|||All drives will need to be visible to all hosts for failover. Drive letters
are assigned cluster-wide for shared resources. The easiest way is to
pretend you are building a multi-instance stand-alone system where SQL Data
and Logs from multiple instances cannot intersect on the same LUN. Also
remember to add a drive for MSDTC and for the Quorum. Don't forget to leave
room for expansion.
Example
C for local boot, Z for local CD-ROM (Old Novell habit)
Q for Quorum, M for MSDTC
K,L for SQLInstance1 data and logs respectively
R,S for SQLInstance2 data and logs respectively
lather, rinse, repeat.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Kamal Hassan" <KamalHassan@.discussions.microsoft.com> wrote in message
news:5D8375C6-8269-46FC-B619-BD75E0F8A6CD@.microsoft.com...
> I have a question for Geoff.
> I have a similar situation where I plan to install/configure
multi-instance[vbcol=seagreen]
> cluster.
> My question is
> a) as we plan to use/assign drive letters what care shoud be taken for
> multi-instance cluster (3 active 1, passive/standby)?
> Thanks.
> Kamal.
>
>
> "Geoff N. Hiten" wrote:
the[vbcol=seagreen]
device[vbcol=seagreen]
on[vbcol=seagreen]
2k3[vbcol=seagreen]
the[vbcol=seagreen]
the[vbcol=seagreen]
There[vbcol=seagreen]
minimum[vbcol=seagreen]
connecting[vbcol=seagreen]
and[vbcol=seagreen]
Each[vbcol=seagreen]
Network[vbcol=seagreen]
order[vbcol=seagreen]
to[vbcol=seagreen]
shared[vbcol=seagreen]
the[vbcol=seagreen]
to[vbcol=seagreen]
node[vbcol=seagreen]
on[vbcol=seagreen]
processing[vbcol=seagreen]
from[vbcol=seagreen]
"Shared[vbcol=seagreen]
host[vbcol=seagreen]
queries.[vbcol=seagreen]
This[vbcol=seagreen]
is[vbcol=seagreen]
exists[vbcol=seagreen]
capabilities.[vbcol=seagreen]
and[vbcol=seagreen]
instance[vbcol=seagreen]
somewhat[vbcol=seagreen]
nodes.[vbcol=seagreen]
Windows[vbcol=seagreen]
windows[vbcol=seagreen]
DB[vbcol=seagreen]
system[vbcol=seagreen]
we[vbcol=seagreen]
message[vbcol=seagreen]
a[vbcol=seagreen]
of[vbcol=seagreen]
Access[vbcol=seagreen]
|||First, manythanks for quick reply.
In your suggestion is the SQLinstance1 and SQLInstance refer to as ACTIVE
nodes with StandyBy Server or ?
We are not using MSDTC do we still have to setup/configure? and what do you
mean don't forget to leave for expnasion?
Thanks a lot!
Kamal.
"Geoff N. Hiten" wrote:
> All drives will need to be visible to all hosts for failover. Drive letters
> are assigned cluster-wide for shared resources. The easiest way is to
> pretend you are building a multi-instance stand-alone system where SQL Data
> and Logs from multiple instances cannot intersect on the same LUN. Also
> remember to add a drive for MSDTC and for the Quorum. Don't forget to leave
> room for expansion.
> Example
> C for local boot, Z for local CD-ROM (Old Novell habit)
> Q for Quorum, M for MSDTC
> K,L for SQLInstance1 data and logs respectively
> R,S for SQLInstance2 data and logs respectively
> lather, rinse, repeat.
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Kamal Hassan" <KamalHassan@.discussions.microsoft.com> wrote in message
> news:5D8375C6-8269-46FC-B619-BD75E0F8A6CD@.microsoft.com...
> multi-instance
> the
> device
> on
> 2k3
> the
> the
> There
> minimum
> connecting
> and
> Each
> Network
> order
> to
> shared
> the
> to
> node
> on
> processing
> from
> "Shared
> host
> queries.
> This
> is
> exists
> capabilities.
> and
> instance
> somewhat
> nodes.
> Windows
> windows
> DB
> system
> we
> message
> a
> of
> Access
>
>
|||Active\Active and Active\Passive are not accurate terms. Each SQL instance
is its own virtual server.
SQLInstance1 and 2 refer to the SQL virtual servers\instances. The host
nodes are all configured identically.
You will have to add disk storage sometime down the road. Leave empty drive
letters for adding new disk resources.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Kamal Hassan" <KamalHassan@.discussions.microsoft.com> wrote in message
news:DD172480-C6FA-41A6-86CC-65A2C790D3C6@.microsoft.com...
> First, manythanks for quick reply.
> In your suggestion is the SQLinstance1 and SQLInstance refer to as ACTIVE
> nodes with StandyBy Server or ?
> We are not using MSDTC do we still have to setup/configure? and what do
you[vbcol=seagreen]
> mean don't forget to leave for expnasion?
> Thanks a lot!
> Kamal.
>
> "Geoff N. Hiten" wrote:
letters[vbcol=seagreen]
Data[vbcol=seagreen]
leave[vbcol=seagreen]
really[vbcol=seagreen]
implement[vbcol=seagreen]
live[vbcol=seagreen]
Windows[vbcol=seagreen]
Client) to[vbcol=seagreen]
are[vbcol=seagreen]
disk[vbcol=seagreen]
utilized[vbcol=seagreen]
up[vbcol=seagreen]
on[vbcol=seagreen]
non-working[vbcol=seagreen]
running[vbcol=seagreen]
wish[vbcol=seagreen]
host[vbcol=seagreen]
client[vbcol=seagreen]
executed[vbcol=seagreen]
come[vbcol=seagreen]
any[vbcol=seagreen]
data[vbcol=seagreen]
nodes.[vbcol=seagreen]
device[vbcol=seagreen]
database[vbcol=seagreen]
multiple[vbcol=seagreen]
message[vbcol=seagreen]
we do[vbcol=seagreen]
a[vbcol=seagreen]
servers[vbcol=seagreen]
as[vbcol=seagreen]
you[vbcol=seagreen]
at[vbcol=seagreen]
nodes[vbcol=seagreen]
is[vbcol=seagreen]
4 node cluster
I want to set up a 4 node cluster where 3 nodes are active and 1 is the
passive node that would take over in case any one of those 3 active nodes
fail. How can I set this up ? Any documentation..
Using SQL 2005..
"Hassan" <hassan@.hotmail.com> wrote in message
news:eDbSEq7hHHA.4680@.TK2MSFTNGP06.phx.gbl...
>I want to set up a 4 node cluster where 3 nodes are active and 1 is the
>passive node that would take over in case any one of those 3 active nodes
>fail. How can I set this up ? Any documentation..
> Using SQL 2005..
First, you get the proper training...
Basically, you build the four node cluster then install SQL three times to
create three instances with each instance hosted in its own resource group.
Place a SQL instance on each node that you want to be the active node.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
The next ClusterHelp class is:
April 30, 2007 - Denver
|||You can find a lot of documentation on MSDN about this. Setting up clustering
is a very eloborate process and you need to prepare a lot before actually
setting one up.
All the best.
Suresh
"Hassan" wrote:
> I want to set up a 4 node cluster where 3 nodes are active and 1 is the
> passive node that would take over in case any one of those 3 active nodes
> fail. How can I set this up ? Any documentation..
> Using SQL 2005..
>
>
passive node that would take over in case any one of those 3 active nodes
fail. How can I set this up ? Any documentation..
Using SQL 2005..
"Hassan" <hassan@.hotmail.com> wrote in message
news:eDbSEq7hHHA.4680@.TK2MSFTNGP06.phx.gbl...
>I want to set up a 4 node cluster where 3 nodes are active and 1 is the
>passive node that would take over in case any one of those 3 active nodes
>fail. How can I set this up ? Any documentation..
> Using SQL 2005..
First, you get the proper training...
Basically, you build the four node cluster then install SQL three times to
create three instances with each instance hosted in its own resource group.
Place a SQL instance on each node that you want to be the active node.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
The next ClusterHelp class is:
April 30, 2007 - Denver
|||You can find a lot of documentation on MSDN about this. Setting up clustering
is a very eloborate process and you need to prepare a lot before actually
setting one up.
All the best.
Suresh
"Hassan" wrote:
> I want to set up a 4 node cluster where 3 nodes are active and 1 is the
> passive node that would take over in case any one of those 3 active nodes
> fail. How can I set this up ? Any documentation..
> Using SQL 2005..
>
>
Subscribe to:
Posts (Atom)