3 ms·
HA, Read load balancing for a simple master-slave setup.
by fgonzag 9y ago
HA, Read load balancing for a simple master-slave setup.
- pmarreck 9y agoBack in my SQL Server days they had something called "log shipping" which is basically sending the transaction log over the wire to another machine where it is re-run. Does that still exist? EDIT: It turns out there is https://www.postgresql.org/docs/9.1/static/warm-standby.html https://www.postgresql.org/docs/9.1/static/warm-standby.html and this seems to accomplish the same goal without actually being replication, so what gives?
- tapoxi 9y agoI think warm standby is a relatively new feature for Postgres. As someone who's had to configure warm standby recently, it's fine, but it's not active-active, which infuriated a few Oracle DBA colleagues. The best way to do that at the moment is by using a proxy like PgPool II.