Increasingly global? You’ll need a better SQL Server WAN replication strategy
As organizations grow geographically and expectations for real-time data increase, the challenge of supporting business in a networked environment requires innovative, simple-to-use solutions.
Because wide area networked (WAN) sites or servers are often connected by network connections that vary in speed and reliability, database administrators must identify a WAN replication solution that guarantees secure and timely data delivery without increasing bandwidth costs.
This post provides a view into the options available for SQL Server to address distributing data across WAN boundaries and makes the case for using NitroAccelerator, a breakthrough compression solution that makes WAN replication fast and secure, even over the slowest connections. Whether you are using or considering snapshot replication, merge replication, transaction replication, log shipping, SSIS or other methods, this is a must read.
Table 1: SQL Server data distribution options
As you can see from the table, there is no native mechanism that performs well over lower bandwidth connections. However, using NitroAccelerator on the end-points, in a proper configuration, can enable real-time replication to remote instances of SQL Server. In fact, several NitroAccelerator users are experiencing an 80% reduction in TCP packets and between 80 to 90% reduction in latency.
How are you approaching WAN replication today? What challenges are you running into?
Dramatically accelerate and secure your end-to-end SQL Server network traffic for:
- SQL Server Tabular Data Stream (TDS)
- Windows SMB File Transfer
- Database Mirroring
- SQL Server Analysis Services (SSAS)