Sybase Business Intelligence Solutions - Database Management, Data Warehousing Software, Mobile Enterprise Applications and Messaging
Sybase Brand Color Bar

Multi-Path Replication – Faster, Better and Cheaper

December 16, 2011 in Uncategorized | Comments (0)

Faster, Better and Cheaper (FBC) has long been the motto for Replication Server product development. FBC aims to improve replication performance and usability, reducing total cost of ownership for users. Sybase Replication Server 15.7, the newest release of Replication Server family, best illustrates this principle.

The crème de la crème of all RS 15.7 features is Multi-Path Replication (MPR). In our last MPR blog post, we introduced the MPR technology and its usages. But users traditionally have to acquire new expensive hardware in order to boost software performance to meet ever increasing business demands for low latency data movement.

In this post, performance improvement from a recent user’s testing will illustrate FBC through MPR without additional hardware CapEx. We will compare an existing single-path replication to the same replication done with increasing numbers of parallel replication paths (i.e., MPR) on the same set of hardware. User measured volume of replication data is in GB per hour, and latency is in minutes.

Increased performance with MPR*

The performance chart demonstrates near linear scalability when multiple parallel replication paths are employed in user’s test environment. User found 96 percent increase in the replication volume by using two parallel paths, and 173 percent increase by using three parallel paths.

Reduced latency with MPR*

Latency measurement goes hand-in-hand with volume to best demonstrate performance. The replication latency chart shows less time consumed when replication is done using multiple parallel paths. User found 44 percent latency reduction by using two parallel paths. With three parallel paths, latency is further reduced by 57 percent over single-path replication.

This user testing of MPR demonstrates Replication Server’s FBC development principle via increased replication volume and reduced latency without additional cost of new hardware. We expect other users will be able to benefit from this new feature of Replication Server to meet increasing demand for real time data.

* Your performance improvement may vary based on your own transaction profile and hardware employed.

Replication Server Improves Performance and Reduces Latency with MPR

December 10, 2011 in Uncategorized | Comments (5)

Sybase Replication Server is a real-time enterprise data movement tool widely used for database disaster recovery, real-time reporting and data distribution. Its enterprise-level features and performance have made it an industry standard among the most demanding customers since its introduction more than 20 years ago. The imminent release of Replication Server 15.7 continues pushing envelop and maintaining its leading edge by introducing new Multi-Path Replication (MPR) technology.

So, what is MPR? MPR improves replication performance and reduces latency by enabling parallel paths of data from the source database to the target database. These parallel paths will process data independently of each other to improve overall efficiency, performance and load balancing.

Replication without MPR (Single-path)

Replication without MPR handles transactions one at a time in a serial fashion, which looks like this:

Transactions in this single path of replication can get held up behind another larger transaction, typically a batch job, until the larger transaction is completely replicated. The transaction next in queue could be a higher priority transaction, but it must wait its turn in the queue.

Quality of Service and Performance Improvement with MPR

MPR lets the scenario above handle data via the following deployment topology, with the transactions replicated in parallel along multiple independent paths:

The illustration above shows all three paths replicating side-by-side, without one having to wait for the other to complete. A transaction with higher priority can now replicate in parallel, and doesn’t have to wait for an unrelated larger transaction to complete. This advantage helps users to meet a better Service Level Agreement (SLA) and achieve a higher Quality of Service (QoS).

Employing MPR’s parallel features does not mean compromising the replicated data’s reliability. The disparate transactions traveling over different paths still retain reliability of data that is a hallmark of Replication Server.
MPR’s benefits of same parallelism also apply when replicating over large distances e.g., over Wide-Area Networks spanning different states, countries or continents.

In the illustration above, multiple parallel replicated datasets transit from one Replication Server to another remote Replication Server via multiple routes, before replicating to their intended target. The parallel nature of MPR improves overall performance compared to single-path mode of operation by removing bottlenecks between source and target of replication system.

Load-Balancing with MPR

MPR can also help users to improve performance and reduce latency by better arranging transaction loads across several Replication Servers. In the illustration below, user divides replication process into multiple paths using MPR and routes each path with appropriate transaction profile based on each Replication Server’s work load. By optimizing replication system using load-balancing, user can efficiently replicate more volume within defined operating window without requiring additional hardware cost.

Sybase Replication Server’s addition of MPR further extends leadership by increasing performance, reducing latency and enhancing quality of services. These attributes of MPR are essential to distribute, consolidate and synchronize data in the most demanding environments today.