Re: Dev chat reminder, issue 0fbcd3ab-0ace-4e23-9100-53e04aaea892
Robert Kaye <[email protected]>
| Newsgroups | gmane.comp.audio.musicbrainz.devel |
|---|---|
| Message-ID | <[email protected]> |
On Jun 3, 2014, at 2:09 PM, Wieland Hoffmann <[email protected]> wrote: > It could probably be modified to just dump the changes, but that sounds > a lot like PGs streaming replication feature [0]. > > [0] https://wiki.postgresql.org/wiki/Streaming_Replication It certainly does -- however, I am not sure how well postgres can deal with network (or other outages). When we were using our stream replication between two servers in the same rack, we didn't have a lot of time to get the replication on the slave to work. Otherwise the slave could fall behind so far that it could not store more logs to catch up again. An hour long outage would cause replication to fail, requiring a fresh copy of the DB. But, that may have just been a disk space issue which we may be able to fix by throwing larger disks at the problem. -- --ruaok Robert Kaye -- [email protected] -- http://musicbrainz.org