Migration BizTalk 2009 to BizTalk 2010 : Clustered Servers

hey,

here is the last post about the migration of the BizTalk environment 2009 to 2010. And today, we’ll discuss about the clustered environment (for production).

Here is the Architecture,

• 2 BizTalk Servers
• 3 SQL Server with Active/Passive mode

We can see the architecture on the following picture :

What is the benefit of this architecture :

• performance with the cluster 1 with an Active/Active configuration for the MessageBox
• redundancy with the cluster 2 with an Active/Passive configuration for the Database ManagementDb, BAMPrimaryImportDb, personal Db and SSO.

So the question is ? how to migrate from BizTalk 2009/SQL Server 2008 to BizTalk 2010/SQL Server 2008 R2 in this configuration limiting service breakdown.

You have first to follow this steps :

1. Upgrade the SQL Server 2008 to SQL Server 2008 SP1 (because BizTalk 2010 doesn’t support SQL Server 2008)
2. Upgrade the SSO to the .Net 4 version on the SQL Server of the Cluster 02.

When you have to upgrade a node of a cluster, you have to realize the following Step.

1. Exclude nodes as possible owners from that particular instance (or instances) of SQL Server that will be upgraded. Microsoft recommends that you remove half of the nodes, but if you have an odd number of nodes, half is not possible.
2. Apply the update to the nodes that were removed.
3. Add the excluded nodes back as owners.
4. Fail the SQL Server instance over to one of the upgraded nodes.
5. Exclude the nodes as possible owners that were not upgraded and upgrade them.
6. Add those excluded nodes back as possible owners.

Applying to the upgrade to SP1 on cluster 01 :

1. Exclude SQL Server 01 as possible owners of the Cluster 01
2. Apply the update on the SQL Server 01
3. Add the SQL Server 01 as possivble owners of the Cluster 01
4. Exclude SQL Server 02 as possible owners of the Cluster 01
5. Exclude SQL Server 02 as possible owners of the Cluster 02
6. Apply the update on the SQL Server 02
7. Add those excluded nodes back as possible owners

Once you’ve upgrade SQL to SP1 and SSO you can upgrade the platform in the following order :

1. Upgrade each BizTalk computer to the 2010 edition
2. Upgrade each SQL Server to 2008 R2 following the previous procedure

The upgrade of BizTalk will do :

For the first server :

• Install .Net 4 runtime
• Upgrade of SSO
• Upgrade BizTalk Runtime
• Upgrade BizTalk DataBase

For the second server :

• Install .Net 4 runtime
• Upgrade of SSO
• Upgrade BizTalk Runtime

The Installation of the .net 4 runtime require the reboot of the server.

When you upgrade BizTalk, be sure that the installation wizard reference all you database like this :

If not you may have a problem or a change in your original configuration  — like the name of your biztalk group (we’ve seen on previous post that there is some problem with hard coded value in the installation wizard)

That the end for the migration.

Hope this post will help you.

Advertisement