BizTalk and SQL Clustering

Hi,

I have following questions in clustering:
1. When we say BizTalk cluster. Does that mean that all the server nodes that participate will use the same SQL server cluster, SSO cluster?

2. In case of SQL Server cluster, one is active and one is passive. Will both the servers be replica of each other? I mean to ask will they have same data and configuration?  If not then how will it work in a failover scenario because the passive instance will not the all the information of Active instance?

3. Does a Single node of SQL Cluster includes MsgBox and ManagementDB or are they on different Server?

4. What is the ideal setup of Sql DB? Eg: a different for MsgBox, Management DB, SSO etc?

5. Also, as per my understanding, for high availabilty we should have a BizTalk cluster, Sql cluster and SSO cluster? Is that correct?

Thanks.

January 12th, 2014 11:15am

1. Technically, it could but an HA BizTalk Group really should start with 4 computers, 2 BizTalk 2 SQL. SQL Server is clustered across it's two servers and the two BizTalk computers provide HA either through multiple Host Instances or clustering if you're using message queuing, FTP, POP3.

2. SQL Server supports several HA patterns now, however, BizTalk only supports a 2 node SQL Cluster with shared storage.  So, no, there is only one copy of the data but only one SQL process active at a time.

3. Well, you can't have a single node cluster.  A single SQL Cluster can host all BizTalk databases.

4. That entirely depends on your SLA and throughput requirements.  There is no one 'ideal' setup, only a properly sized setup.

5. See #1.  HA with BizTalk requires at least 4 computers.  The SSO Master Secret Server can be clustered on the same computers as SQL Server and there is a special licensing provision for just that so you don't have to have a BizTalk license on those machines.

BizTalk Hosts should only be clustered using Windows Clustering in very specific circumstances: http://msdn.microsoft.com/en-us/library/aa561801.aspx

Free Windows Admin Tool Kit Click here and download it now
January 12th, 2014 4:35pm

  1. Cluster or Not, all BizTalk Servers are configured in the same group and use the Master SSO instance. Only in the case of a cluster the associated DB's are clustered. Does not really change anything w.r.t configuration of the BizTalk Group.
  2. I would refer you to the following links http://msdn.microsoft.com/en-us/library/aa373130(v=vs.85).aspx and http://technet.microsoft.com/en-us/library/cc757731(v=ws.10).aspx to get a better understanding of clusters. Clusters in Microsoft are a shared resource so to answer your question, the passive node will (in case of failover) get access to the resources which were with the active instance and thus no further configu sync is required. Its is the same information from the drives, master DB, services, registry which fails over onto the passive node.
  3. How you utilize the two (or more) nodes of the cluster depends on the load you expect to handle. You may choose to split databases across the TWO nodes [called Active/Active in Microsoft parlance]. This way BOTH the nodes have to be licensed. Each BizTalk Database has different needs w.r.t frequency of reads/writes, size, etc. The BizTalk Performance Optimization Guide @http://msdn.microsoft.com/en-us/library/ee377064.aspx in addition to best Practices for Maintaining BizTalk Database @http://msdn.microsoft.com/en-us/library/gg634566.aspx should provide you with guidance on how to split the BizTalk Databases across multiple cluster nodes.
  4. I would like to provide you ONE configuration fits all BUT that is not possible. The setup of the SQL is highly dependant on the load you expect to address through BizTalk, the HA/DR consideration pertaining to availability/licensing, etc. In short it is a topic for an infrastructure architect.
  5. BizTalk Cluster is again a subject of requirement. There is no BizTalk Cluster per-se, BizTalk Services (BTSNTSvc.exe) can be clustered so implying that specific host instance can be clustered. As a rule one should only look at clustering those Receive Protocols which need to be configured for availability. Examples would be FILE, FTP, even DB locations. IIS/Web Services provide HA + scalability through NLB. If you have a SQL Cluster then it is recomended to also cluster SSO on the same set of servers primarily because it does not require additonal BizTalk Licensing.

Regards.

January 12th, 2014 11:55pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics