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
01.09.2007
240833 byte
Aufsatz (Konferenz)
Elektronische Ressource
Englisch
Writer-to-reader delays in military communications systems
Tema Archiv | 1979
|Electronic writer-to-reader system in data (record) communications
Tema Archiv | 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
|