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

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.