3 ms·
Hey, Jason from Citus Data here (one of pg_shard's authors). Yes: if you have high availability needs, PostgreSQL's streaming replication feature can mitigate
by jasonmp85 12y ago
Hey, Jason from Citus Data here (one of pg_shard's authors).
Yes: if you have high availability needs, PostgreSQL's streaming replication feature can mitigate this failure risk by providing a hot standby for your master; otherwise, regular backups of the master can suffice (pg_shard's metadata is stored in regular PostgreSQL tables).
See our documentation page for more answers to questions like this: http://citusdata.com/docs/pg-shard http://citusdata.com/docs/pg-shard
- gunnark01 12y agoWe have something similar in house, it is basically proxy that runs on our app-server and our app connects to. It will then parse incoming queries and route queries to the correct schema/server base on the WHERE clause (also supports INSERT). We would like to on open source it, but right now it specific to our needs (e.g hard coded hash function).