Back when Gomez became the Web Performance division of Compuware, one of the keys to success was the ability to use NitroAccelerator to help provide real-time performance data to global customers over the internet. Thousands of companies worldwide rely on Gomez to optimize the performance, quality, and availability of their web and mobile applications.
With over 100,000 networked locations worldwide, Gomez faced a challenge providing real-time performance data that it promised its customers. Particularly many of its largest customers are distributed and require performance data to be collected from around the globe. In order to be a real-time solution, they had to improve the ability to push data around the world, no matter the network scenarios.
The Gomez Performance Network relies on SQL Server to house their customers’ performance data. This data is stored geographically local to the websites they monitor and is replicated back to their headquarters using transactional replication. The replication from the remote sites occurs over WAN connections that vary in speed and reliability. These WAN connections in many cases are unable to maintain a real-time flow of performance data.
With NitroAccelerator, Compuware’s Gomez team is able to maintain real-time replication across even their slowest WAN connections. NitroAccelerator provides an 80% reduction in TCP packets and between 80 to 90% reduction in latency.
With NitroAccelerator, our SQL Server replication latency was reduced up to 80%. Since we are running replication on hundreds of servers around the world, this improvement has enabled us to deliver better customer service and has allowed us to continue to expand our business into new regions and countries.”
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?