Postgres-r(si): Combining replica control with concurrency control based on snapshot isolation

DMCA

Postgres-r(si): Combining replica control with concurrency control based on snapshot isolation (2005)

Cached

Download Links

Other Repositories/Bibliography

DBLP

by Shuqing Wu , Bettina Kemme

Venue:	In International Conference on Data Engineering
Citations:	93 - 10 self

BibTeX

@INPROCEEDINGS{Wu05postgres-r(si):combining,
    author = {Shuqing Wu and Bettina Kemme},
    title = {Postgres-r(si): Combining replica control with concurrency control based on snapshot isolation},
    booktitle = {In International Conference on Data Engineering},
    year = {2005}
}

OpenURL

Abstract

Replicating data over a cluster of workstations is a powerful tool to increase performance, and provide fault-tolerance for demanding database applications. The big challenge in such systems is to combine replica control (keeping the copies consistent) with concurrency control. Most of the research so far has focused on providing the tra-ditional correctness criteria serializability. However, more and more database systems, e.g., Oracle and PostgreSQL, use multi-version concurrency control providing the iso-lation level snapshot isolation. In this paper, we present Postgres-R(SI), an extension of PostgreSQL offering trans-parent replication. Our replication tool is designed to work smoothly with PostgreSQL’s concurrency control provid-ing snapshot isolation for the entire replicated system. We present a detailed description of the replica control algo-rithm, and how it is combined with PostgreSQL’s concur-rency control component. Furthermore, we discuss some challenges we encountered when implementing the proto-col. Our performance analysis based on the TPC-W bench-mark shows that this approach exhibits excellent perfor-mance for real-life applications even if they are update in-tensive. 1.

Keyphrases

replica control concurrency control snapshot isolation iso-lation level snapshot isolation detailed description excellent perfor-mance postgresql concur-rency control component replication tool database system copy consistent entire replicated system database application performance analysis trans-parent replication powerful tool real-life application multi-version concurrency control tra-ditional correctness criterion serializability big challenge tpc-w bench-mark show

DMCA