Skip to content

postgrespro/postgres_cluster

Repository files navigation

  1. Design

General concept oberview. wiki link. This repo implements Snapshot Sharing mechnism. Protocol description. README.protocol Presentation

  1. Installing
  • patch postgres
  • install extension
  • configure two postgreses
  • run dtmd
  • run postgreses

1b) Automatic provisioning

  • For a wide deploy we use ansible. Layouts/Farms. More details later.
  1. Usage

now you can use global tx between this two nodes

table with two columns

example
  1. Consistency testing

To ensure consistency we use simple bank test: perform a lot of simultaneous transfers between accounts on different servers, while constantly checking total amount of money on all accounts.

go run ...

also there is the test for measuring select performance.

  1. Using with fdw.

patch go run ...

  1. Using with pg_shard

checkout repo go run ...

  1. Results

Some graphs

About

Various experiments with PostgreSQL clustering

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published