Data Backup and Recovery

SnapCenter on SQL cluster active-active

cheche030
8,261 Views

Hi,

   I have installed SnapCenter 4.2.0 agents in two node SQL Server cluster with active-active configuration. But SnapCenter only can access to the instances running in the node which own cluster name resource. Does anybody know how can I work with the instances on the secod cluster node?

12 REPLIES 12

Ontapforrum
8,243 Views

Hi,

 

Interesting query, Is that not a normal behavior ?

 

SQL Cluster supports a Failover Clustering only where only one node is active at a certain point of time and next node takes up the work post a failover happens automatically/manually triggered.

 

Considering that , SnapCenter agent will only see the resources for the Node that is active.

 

Does SQL Server support 'true' Active/Active Clustering?
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/a367a0cb-9231-42ae-9ddb-d59b9aa83ab9/does-sql-server-support-true-activeactive-clustering?for...


Could someone from SnapCreator team confirm this ?

 

Thanks!

 

cheche030
8,241 Views

When I say active/active I mean that each node runs different instances of SQL Server. For example:

 

  - Node 1 executes instances A and B
  - Node 2 executes instances C and D

 

SnapCenter can only access instances that run on the node that has the cluster name. If the cluster name is on node 1, SnapCenter only accesses instances A and B. If the cluster name is on node 2, SnapCenter only accesses instances C and D.

 

Ontapforrum
8,165 Views

Thanks for clearing that for me, that makes sense when you say 'active/active'.

 

I guess, the question now is : Is it supported with SnapCenter ?

 

I will try to find this out.

 

Thanks!

Ontapforrum
8,142 Views

Hi,

 

There is a reference of installing plug-in on SQL cluster.

 

Adding hosts and installing SnapCenter Plug-in for Microsoft Windows:
http://docs.netapp.com/ocsc-40/index.jsp?topic=%2Fcom.netapp.doc.ocsc-isg%2FGUID-8674BCB1-0CA6-4B2B-8D07-146E1AB9AE79.html

 

Installing plug-ins on a cluster: (I don't know if AlwaysOn means Active/Active)
If you install plug-ins on a cluster (WSFC, Oracle RAC, SQL Always OnAvailability Groups, or Exchange DAG), they are installed on all of the nodes of the cluster.


Could you ensure this:
SnapCenter depends on the proper configuration of the DNS. Therefore, the best practice is to enter the fully qualified domain name (FQDN). If you are adding a host using SnapCenter and it is part of a subdomain, you must provide the FQDN.

 

Thanks!

cheche030
8,071 Views

It is possible that the problem lies in the resolution names. We have a disjoint Windows namespace: the domain FQDN is "usc.es" but the servers FQDN is "server1.rpso.usc.es" being "rpso.usc.es", not a Windows subdomain , but a DNS zone.

SnapCenter doesn't understand that and insists on always resolving "server1.usc.es" so we have to fool it with a "hosts" file establishiong alias like "server1.usc.es".

 

But after installing the agents we find this problem.

 

Ontapforrum
8,068 Views

Thanks for the update. Yes, it could well be.

 

I think looking at the version of the SnapCenter, you should be able to raise a ticket with NetApp. Have you already raised one regarding this issue ?  If not, I suggest please do so, chances are your issue will get resolved sooner.

 

Also, I come across this KB, talking about DNS issue. I guess you have acces to KBs. Please take a look.

SnapCenter Resource "Availability Group":
https://kb.netapp.com/app/answers/answer_view/a_id/1087384/loc/en_US

 

Thanks!

cheche030
8,062 Views

Yes, I have raised a ticket with NetApp.

 

Thanks for your help.

cheche030
7,947 Views

I added an sql server that is not clustered and the server registers correctly. The DNS resolution error only occurs with clustered computers.

cheche030
7,758 Views

An active-active clúster with normal DNS resolution works fine. The problem lies in the disjoint namespace. Netapp is woking on this issue.

cheche030
7,362 Views

NetApp responds that disjoint domains are not supported by SnapCenter.

cheche030
7,361 Views

This problem has nothing to do with the disjoint namespace. In order to work with all instances the nodes have to be able to access the SQL Browser service, which we had disabled. By enabling it all instances are accessible by Snapcenter.

Ontapforrum
7,351 Views

Very interesting and valuable information. Thanks a lot for sharing this information.

Public