SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Replication Gets Some Love

By Steve Jones,

I really like replication in SQL Server. At least, I like it as a concept. It solves some hard problems and lets me move data around in a way that can handle larger loads, reduce queries to OLTP servers, and more. I've been hoping Microsoft would see this feature as critical to the future success of SQL Server and enhance it's tooling, reliability, and feature set. Each time a new version is completed, I'm hoping that the Release Notes include a lot of replication changes.

I'm usually disappointed, but not always. Recently I was excited by a change in a CU, not a new version. The SQL Server team added the ability to put the distribution database in an Availability Group. This is incredibly useful and helpful for ensuring HADR for replication scenarios. Prior to this, you could put the publication database in an AG, but not the distribution database. This is being added in CU6 for SQL Server 2017 and will be back ported to SQL Server 2016 in a future CU. 

There are plenty of restrictions in this first version of the feature, including the fact that local distributors aren't supported. In fact, with all of the ways you can't use this, I bet many replication environments can't implement this. 

Yet.

I have hope that future CUs will enhance this feature to remove restrictions and allow more flexibility with replication in AGs. I think that handling naming and networking issues in HADR situations is incredibly complex and replication was built quite some time ago, when we didn't think so deeply about distributed systems. I slowly see Microsoft adapting parts of SQL Server to the modern world, and I hope that they continue to do so for replication.

 
Total article views: 52 | Views in the last 30 days: 1
 
Related Articles
FORUM

SQL server distributed database

Database Distribution

FORUM

Moving Distribution Database to different server.

Moving Distribution database to different server

ARTICLE

Scaling Out the Distribution Database

Replication is a great technology for moving data from one server to another, and it has a great man...

ARTICLE

Replication: Distribution Agent Monitoring

Learn about the distribution agent and how to identify replication bottlenecks.

ARTICLE

Distribution Database Migration

This article shows a step-by-step guide to move the distribution database to a new SQL Server instan...

Tags
editorial    
 
Contribute