Does 1C:Enterprise support SQL Server AlwaysOn?

The 1C:Enterprise developers forum

#1
People who like this:0Yes/0No
Active user
Rating: 4
Joined: Nov 19, 2012
Company: BizzSimple.com

Microsoft is positioning AlwaysOn as primary solution for HADR at this point and I was wondering if 1C platform supports it.
I was testing it with two node cluster and was unable to make it works.

The client access point registered in DNS with two IP addresses in different subnets. For example:
sqldb-qa-001.contoso.com
10.55.6.200
10.55.7.200

1C is able to connect to "sqldb-qa-001.contoso.com" when cluster is active on the first node with ip 10.55.6.200, but unable after failover to another node.

I guess 1C should add parameter "MultiSubnetFailover=True" into connection string in order to make it works.

Is there any plans to support this feature?

Edited: Aleksey Bochkov - Oct 26, 2016 11:49 PM
 
#2
People who like this:0Yes/0No
Active user
1C:Professional
Rating: 4
Joined: May 8, 2013
Company: 1C Company

1. 1C works with AlwaysOn failover cluster, and there are several examples of using it in real life.

2. "I guess 1C should add parameter "MultiSubnetFailover=True" into connection string in order to make it works. "

MS SQL Server AlwaysOn failover should work regardless of the MultiSubnetFailover parameter. This is what MSDN says on the subject: "By default, the client tries the IP addresses in order. When the client uses the new optional MultiSubnetFailover=True parameter in its connection string, it will instead try the IP addresses simultaneously and connects to the first server that responds. This can help minimize the client recovery latency when failovers occur."

So, this parameter optimizes switching between nodes in a case of failure, but it should work anyway. I am pretty sure that this parameter has nothing to do with your issue.

3. "unable after failover to another node"

Could you, please, describe the experiment in much more detailed way? What did you do to simulate the failure? What happens next? If it was an error message, I need a full text of a screenshot of it.

4. What version of the Platform do you use?

 
#3
People who like this:0Yes/0No
Active user
Rating: 4
Joined: Nov 19, 2012
Company: BizzSimple.com

After some additional work we were able to achieve immediate changes in DNS after failover between nodes.

How it was before - nslookup was returning two IP addresses for AlwaysOn Client Access Point. In this case 1C:Enterprise was able to connect to SQL Server only when Availability Group was active on first listed IP.
Same story with JDBC driver (not related to 1C) - it was working with "MultiSubnetFailover=True" only.

Now - nslookup returns only one current active IP address - so 1C doesn't have any issues with connection.

However, I don't feel like it is the best solution because we rely on DNS a lot.

I'll investigate it further when I get more data points.

Thank you.

Edited: Aleksey Bochkov - Nov 13, 2016 03:47 PM
 
#4
People who like this:0Yes/0No
Just came
Rating: 0
Joined: Nov 15, 2016
Company:

Dear 1C' supporter

Our company is using 1C, We are install it in my one local server. We bought license for 1C in this server and we are running it.
Now, we want to install a cluster fail-over system with 2 server (active -passive) Do I have to buy new one more license for new one server?

Could you help me please!

Best regard,

NGUYỄN HOÀNG PHAN LONG
MSc Computer Science
IT Department

AASC Ltd. | No.1 Le Phung Hieu, Hanoi, Vietnam
M (84) 92 8383 252
T (84) 24 3824 1990 F (84) 24 3825 3973
E longnhp.it@aasc.com.vn W www.aasc.com.vn
Skype ID nhplong2003

 
Subscribe