Service Communautaire d'Information sur la Recherche et le Développement - CORDIS

FP5

ADAPT Résumé de rapport

Project ID: IST-2001-37126
Financé au titre de: FP5-IST
Pays: Canada

Postgres-R: Kernel-based database replication

Postgres-R is a prototype replication tool integrated into the open-source database system PostgreSQL. The replication tool allows several PostgreSQL database replicas to run on different machines. A transaction can be submitted to any replica where it is executed locally. Before transaction commit, the replication tool transparently multicasts all data changed by the transaction to the other replicas. The replication tool will detect any two concurrent conflicting transactions and abort one of them. It provides the same snapshot isolation level as the original.

PostgreSQL system. The system provides excellent scalability since the overhead to propagate and apply data changes is small. Different to most other work in this direction, replication is integrated into the kernel of the database system. This avoids the indirection of a middleware layer and allows the replication tool to access the internal components of the database system such as concurrency control, query execution etc. The work is already well known among PostgreSQL developers. A group of developers employed or sponsored by several companies have started in January 2005 to reimplement the functionalities of Postgres-R within an advanced prototype that can then be tested by a wide audience. Therefore, we have not yet made our latest version of Postgres-R publicly available. But interested parties can contact us and receive the source code.

Contact

Bettina KEMME, (Assistant Professor)
Tél.: +1-514-3988930
Fax: +1-514-3983883
E-mail