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.


    Access

    Check access

    Check availability in my library

    Order at Subito €


    Export, share and cite



    Title :

    PGSYNC: A Multiple-Reader/Single-Writer Table Replication Tool For High Loaded Distributed Relational SQL Databases


    Contributors:


    Publication date :

    2007-09-01


    Size :

    240833 byte




    Type of media :

    Conference paper


    Type of material :

    Electronic Resource


    Language :

    English



    Writer-to-reader delays in military communications systems

    Feldman, N.E. / Sollfrey, W. / Katz, S. et al. | Tema Archive | 1979


    Electronic writer-to-reader system in data (record) communications

    Harper, W. / Murdock, E. | Tema Archive | 1975


    Use of HSM with Relational Databases

    Breeden, R. / Burgess, J. / Higdon, D. et al. | British Library Conference Proceedings | 1996


    The CD Writer: The Demise of Low-Run CD Replication

    Bennett, H. | British Library Online Contents | 1999


    Fuzzy Join Dependency in Fuzzy Relational Databases

    P. C. Saxena / D. K. Tayal | BASE | 2007

    Free access