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

Author

Téllez, Eric Sadit ; Ortiz, José ; Graff, Mario

Author_Institution

Univ. Michoacana de San Nicolas de Hidalgo, Hidalgo

fYear

2007

fDate

25-28 Sept. 2007

Firstpage

735

Lastpage

739

Abstract

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.

Keywords

SQL; query processing; relational databases; software tools; table lookup; PGSYNC; SQL queries; high loaded distributed relational SQL databases; incremental backup manager; multiple-reader/single-writer table replication tool; open source solution; synchronization database problem; work load distributor; Automotive engineering; Delay; Distributed databases; Feeds; Load management; Master-slave; Open source software; Process design; Relational databases; Robots;

fLanguage

English

Publisher

ieee

Conference_Titel

Electronics, Robotics and Automotive Mechanics Conference, 2007. CERMA 2007

Conference_Location

Morelos

Print_ISBN

978-0-7695-2974-5

Type

conf

DOI

10.1109/CERMA.2007.4367775

Filename

4367775