Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #569

Re: Using SQL Server IP for non-sql uses on a failover cluster

Show all headers | View raw

On Jul 25, 4:57 am, Erland Sommarskog <esq...@sommarskog.se> wrote:

> Since I'm into clustering myself, I relayed the question to my MVP mates.
> Here are two responses I recevied:
>
>     There is no different impact to SQL Between using the SQL name/ip or a
>     different name/ip in the same resource group.  All it is in either
>     case is a socket connection to the server on one ip or another.
>
> And response to this comment was:
>
>    The impact is this: if they add it to the SQL group, make it a
>    dependency of the SQL resource, and it goes down, it can potentially
>    take SQL down.
>
>    So never add anything to the SQL group for non-SQL access if you care
>    about HA.
>

 If I understand correctly, there would be no difference between using
the SQL IP vs. a generic IP for non-SQL related network traffic.
Thanks.

It occurred to me that creating additional IP/Network name resources,
but not putting them in the resource group with the SQL Server
resources as was mentioned, would have negative consequences as well.
For example, if you need to perform administrative work on SQL Server
and are connected to the server using the SQL's IP, then if you take
the SQL resources offline, you will become disconnected.  Or, If
instead you connect using the IP in Core Resources, you may connect to
the passive cluster node and will not have direct access to the disks
and other resources used by the DB.  So, I'm back to creating my own
general purpose IP/Network name resource and putting it in the same
group with the SQL Server resources.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

Using SQL Server IP for non-sql uses on a failover cluster Mark <google@markginsburg.com> - 2011-07-24 12:52 -0700
  Re: Using SQL Server IP for non-sql uses on a failover cluster Erland Sommarskog <esquel@sommarskog.se> - 2011-07-25 10:57 +0200
    Re: Using SQL Server IP for non-sql uses on a failover cluster Mark <google@markginsburg.com> - 2011-07-25 06:09 -0700

csiph-web