Post reply

Windows Cluster (SQL server 2008 R2) for BIZTALK Setup Active/Passive or Active/Active

  • November 20, 2015 at 12:02 pm

    #322797

    Hello Experts,

    I have a requirement to setup Cluster for BIZTALK 2010/2913 setup. They need BizTalkMsgBoxDb db in one server, (BizTalkDTADb, BizTalkMgmtDb and BizTalkRuleEngineDb) in another another server and all other BAM dbs in another server.

    Considering the below MSDN article, "https://msdn.microsoft.com/en-us/library/aa577514.aspx"

    I have proposed to create 3 pair of Active/Passive nodes.

    Question is:

    1. Is this possible to have 3 Active/active pair of nodes to implement the same setup?

    2. If so, what about the SQL BIZ maint Jobs? Active/Active setup will certainly make them fail as once databases fail over completely to another node and one node will have all databases then jobs cant work.

    Any further suggestion to make a clear move on this task will be highly welcome.

    Thanks

    Thanks.

  • November 20, 2015 at 4:21 pm

    #1841477

    Any advise may be?

    Thanks.

  • November 23, 2015 at 9:08 am

    #1841766

    HI Steve/Gila

    Any suggestions pleaase

    Thanks.

  • November 24, 2015 at 8:33 am

    #1842084

    SQL-DBA-01 (11/20/2015)

    Hello Experts,

    I have a requirement to setup Cluster for BIZTALK 2010/2913 setup. They need BizTalkMsgBoxDb db in one server, (BizTalkDTADb, BizTalkMgmtDb and BizTalkRuleEngineDb) in another another server and all other BAM dbs in another server.

    Considering the below MSDN article, "https://msdn.microsoft.com/en-us/library/aa577514.aspx"

    I have proposed to create 3 pair of Active/Passive nodes.

    3 pairs of clusters is what you call overkill really, that's at least 6 nodes, you thought about the hardware and software costs for this??

    The first thing I recommend you do is to read my stairway to HA starting at this link[/url]

    SQL-DBA-01 (11/20/2015)

    1. Is this possible to have 3 Active/active pair of nodes to implement the same setup?

    if you have 3 pairs of clusters then they wont be fully active since only one instance will run on one node. 6 nodes across 3 clusters with 3 clustered instances means only 3 nodes running resources

    SQL-DBA-01 (11/20/2015)

    2. If so, what about the SQL BIZ maint Jobs? Active/Active setup will certainly make them fail as once databases fail over completely to another node and one node will have all databases then jobs cant work.

    Any further suggestion to make a clear move on this task will be highly welcome.

    Thanks

    I think you're misunderstanding how this works, hence you should ready my stairway.

    Active\active is no longer the terminology used to describe multi instance clusters.

    A sensible design here would be a 3 node cluster with one instance running on each but able to failover to a partner should an outage occur.

    You really need to have an expert help you design this otherwise you'll ending blowing a whole budget when you probably didn't need to

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply