3 ms·
PG is awesome, but I remember people often complaining about its replication features a few years ago. Have they been improved?
by mixmastamyk 11y ago
PG is awesome, but I remember people often complaining about its replication features a few years ago. Have they been improved?
- dagw 11y agoImproved, yes. Fixed, no. Basically if you want proper full replication, you won't get it out of the box, but will have to use various third party tools. That being said 9.4 added a bunch of the fundamental changes that that laid the foundation for full replication, now we're just waiting PG to finish exposing those features with userland tools.
- amatix 11y agoBuilt-in multi-master replication is the only real missing piece there, AFAIK every other replication base is covered well natively. Besides that, sync & async replication has been there nicely since 9.2. 9.3 added timeline switches, needed for cascaded slave setups in practice. 9.4 added replication slots so the master can keep track of slave sync status, and the foundations for multi-master & logical replication. 9.5 added pg_rewind which speeds up resyncs.
- DrJokepu 11y agoWhat do you mean by "proper full replication"?
- barrkel 11y agoMaster-master
- rgacote 11y agoThe EnterpriseDB folk http://www.enterprisedb.com/products-services-training/products-overview/xdb-replication-server-multi-master http://www.enterprisedb.com/products-services-training/produ... and 2ndQuadrant http://2ndquadrant.com/en-us/resources/bdr/ http://2ndquadrant.com/en-us/resources/bdr/ both have multi-master replication.
- akurilin 11y agoYou get streaming replication out of the box now and you get WAL-based replication assuming you configure a shared drive or use something like S3. The latter isn't super fun to setup automation for. Also not much of a story for logical replication (tried slony, meh, feels like a relic of olden days when every deployment was carefully hand-massaged into existence) and for automated failover. Nowadays you actually can skip a lot of setup automation with RDS, with backups, read mirrors and automated failover taken care of for you, although you frequently hear folks complain about some of those scenarios not working as nicely as you'd expect.
- travisby 11y agoHeroku has open-sourced the product they use to upload WAL files to S3. Can confirm (not with S3, but with Swift) that it works fantastically: https://github.com/wal-e/wal-e https://github.com/wal-e/wal-e
- ksec 11y agoWondering on the same thing, anything PG working on to ease this?
- jeltz 11y agoYes, it has improved a lot and is continuing to improve with new replication features every release. The built-in replication covers the simple master-salve replication case, and is simple to set up and stable.