Installation and deployment Questions on installation, system configuration and deployment to the live server.
Version 6.x > Installation and deployment > Web Farm + SQL marge replication (2 SQL Servers) View modes: 
User avatar
Member
Member
andrey.bezruchko-gmail - 12/28/2013 7:45:51 PM
   
Web Farm + SQL marge replication (2 SQL Servers)
Dear All,

We are going to setup 4 servers in Kentico web farm in two datacenter. Also we want to use separate instances for SQL DB in each DC with merge replication.
Will work this solution on Kentico 6?

User avatar
Member
Member
kentico_sandroj - 12/28/2013 8:10:45 PM
   
RE:Web Farm + SQL marge replication (2 SQL Servers)
Hello,

Would it be possible to provide more details about the environment? Web farms would mean sharing a single database so how would you configure the environment across the two datacenters? Would you run one instance in each or what did you have in mind? There are some limitations for replication but there should not be any issues with this setup.

Please let me know if you have any questions.

Best Regards,
Sandro

User avatar
Member
Member
andrey.bezruchko-gmail - 12/29/2013 3:09:41 AM
   
RE:Web Farm + SQL marge replication (2 SQL Servers)
Dear Sandro,

Many thanks for your answer!
On this diagram planned architecture of solution
SiteArchitecture.pdf

We want to use single installation of Kentico for all sites, of course database must be single and we want use marge replication. I know about all limitations for replication.
Can we be faced with some surprises in the implementation of this architecture?

Best Regards,
Andrey

User avatar
Member
Member
kentico_sandroj - 12/29/2013 10:25:30 AM
   
RE:Web Farm + SQL marge replication (2 SQL Servers)
Dear Andrey,

Thank you for the additional details. Other than the limitation specified in the documentation, there should not be any surprises. You may have to configure an additional workaround due to the loadbalancer. Otherwise, there shouldn't be anything out of the ordinary. If anything does come up, please let us know and we will do our best to assist.

Best Regards,
Sandro

User avatar
Kentico MVP
Kentico MVP
Brenden Kehren - 12/30/2013 7:03:48 AM
   
RE:Web Farm + SQL marge replication (2 SQL Servers)
Having worked with Merge Replication the 2005/2008 versions, I'd recommend not using Merge Replication unless it is the only option. It's such a resource hog and has too many pieces that don't work well for a dynamic database and schema like Kentico has. The limitations Sandro mentioned would be enough where I wouldn't recommend any of my clients use Merge Replication unless they planned to modify a publication everytime a custom table or document type were added or modified OR it was the only solution they had or were offered by their server team.

I'm not stating it won't work, I'm stating it will be a maintenance nightmare for IT. This might not be the best option but it's not the only option.

User avatar
Member
Member
andrey.bezruchko-gmail - 12/30/2013 8:04:19 AM
   
RE:Web Farm + SQL marge replication (2 SQL Servers)
Dear Frogg,

Thanks for your comment, we are looking optimal solutions now for our project, and we have 3 possible options.
The last our idea - to use two instance of Kentico for each DC and to use "Staging module" for content sync.
What do you think about it?

User avatar
Kentico MVP
Kentico MVP
Brenden Kehren - 12/30/2013 11:35:34 AM
   
RE:Web Farm + SQL marge replication (2 SQL Servers)
I've setup an instance like that. There is a test, staging and production setup each with it's own install of Kentico. There are 2 servers for each instance (test, staging, production) in a web farm with a F5 load balancer. The SQL Server is running on a different server (again same type of setup, test, staging, production) and is mirrored.

Once I was able to figure out the web farm setup between Kentico and Microsoft DFS, it works like a charm and is very reliable and fast. I've setup Content Staging as well and it too works without issue. Since Content Staging can sync not only content but objects and data, is a very good way to handle and track changes made through the UI.