This paper presents a new tool to preserve coherency of data in a set of Relational Databases: PGSYNC. It performs replication over a set of single tables with a simply Multiple-Reader/Single-Writer scheme. PGSYNC claims to be closely to real-time, simple, low latent, secure, multi-platform, and open source solution to the synchronization database problem. It's specially designed to process that generates high volumes of SQL queries. Additionally we present a real life heavy loaded system using PGSYNC as incremental backup manager and work load distributor.
PGSYNC: A Multiple-Reader/Single-Writer Table Replication Tool For High Loaded Distributed Relational SQL Databases
2007-09-01
240833 byte
Conference paper
Electronic Resource
English
Writer-to-reader delays in military communications systems
Tema Archive | 1979
|Electronic writer-to-reader system in data (record) communications
Tema Archive | 1975
|Use of HSM with Relational Databases
British Library Conference Proceedings | 1996
|The CD Writer: The Demise of Low-Run CD Replication
British Library Online Contents | 1999
|