3 ms·
Postgres replication is probably not as easy to setup, but can be extremely powerful especially when use tools like WAL-E as well. We have a setup where our WA
by jordanthoms 11y ago
Postgres replication is probably not as easy to setup, but can be extremely powerful especially when use tools like WAL-E as well.
We have a setup where our WAL log is rotated every minute and backed up to S3. Replica databases can either load from S3 or connect to the master for streaming - so they will catch up using S3 and then connect, reducing load on the master.