4 ms·
Run multiple replicas with synchronous replication. For Postgres see: https://wiki.postgresql.org/wiki/Synchronous_replication https://wiki.postgresql.org/wiki
by grosskur 13y ago
Run multiple replicas with synchronous replication. For Postgres see:
https://wiki.postgresql.org/wiki/Synchronous_replication https://wiki.postgresql.org/wiki/Synchronous_replication
This way you should be able to tolerate failure of a single instance without losing data.
- joevandyk 13y agowe do async replication with good monitoring of the slaves to make sure the slaves don't get too far behind. couple that with wal-e. of course, if a comet hits the master db server, you might lose a tiny bit data (typically 0.1 seconds) if not using sync replication. you can use sync replication for the important things that you absolutely can't lose, and async replication for everything else.
- copergi 13y agoBut the thing people are needlessly concerned about with EBS is full datacenter failure. Which is just as much a problem for those EC2 instances. Synchronous replication to another data center is a massive performance killer.