Sybase is a leading RDBMS vendor that started by providing OLTP systems for the client-server environment and is currently maturing into an enterprise-wide data management solution provider. As a critical part of this enterprise-wide data management strategy, Sybase Replication Server supports data replication in a distributed environment. In such an enviromnent, the same data may be replicated at multiple sites for quick data access and for high data availability. Replicated data can be maintained using strong consistency or weak consistence algorithms. Algorithms for maintaining strong consistency, such as primary copy and quorum consensus, severely limit data availability during network partition.Sybase Replication Server implements asynchronous, transactionally consistent log replication using primary copy replication model. Figure 1. shows the basic replication system architecture. Applications update the primary database. The updates are logged and scanned from the primary database log by the Log Transfer Manager (LTM). The LTM passes the updates to the primary Replication Server which determines which replicates are interested in the updates and forwards them to the appropriate replicate Replication Server.The replicate Replication Server applies the updates to the replicate database in the same serial transaction order that was applied at the primary site.A data replication request is called a subscription. A subscription includes data qualifications similar to the where Figure 1. Sybase Replication System Architecture .(3 Replication Server Replication Server WAN .@ Log -.@ Transfer Manager Replicate Primary Database clause in a SQL select command, making fine-granularity data replication possible. A highly scalable subscription rules resolution engine determines which subscriptions are interested in which rows, Some rows can be subscribed to by multiple subscriptions, while other rows can migrate in and out of the subscription data set. Both cases are handled in a transactionally consistent manner.When a subscription is created, its initial data set needs to be copied to the replicate database. When a subscription is dropped, its data set needs to be deleted from the replicate database. Both operations are performed dynamically and keep the data at the replicates transactionally consistent. The Replication Server scans the primary database log and continuously propagates the updates using store and forward techniques, At the primary database, the Log Transfer Manager prevents the database log from being truncated before the updates are replicated, Distributed mirroring allows messages to be stored at multiple sites to facilitate disaster recovery. Primary and replicate database dumps are coordinated in order to recover the entire distributed system to a consistent state. Replicates can update primary data asynchronously using request functions. Requests are submitted at the replicates by executing stored procedures, They are delivered to the primary and applied. The updates caused by these requests at t...
No abstract
scite is a Brooklyn-based organization that helps researchers better discover and understand research articles through Smart Citations–citations that display the context of the citation and describe whether the article provides supporting or contrasting evidence. scite is used by students and researchers from around the world and is funded in part by the National Science Foundation and the National Institute on Drug Abuse of the National Institutes of Health.
hi@scite.ai
10624 S. Eastern Ave., Ste. A-614
Henderson, NV 89052, USA
Copyright © 2024 scite LLC. All rights reserved.
Made with 💙 for researchers
Part of the Research Solutions Family.