top | item 42697066

(no title)

bblb | 1 year ago

I would say Pgpool-II is still the best we got.

This video covers pretty much all the practical stuff. I timestamped the parts in a comment.

PgPool II Performance and best practices https://www.youtube.com/watch?v=bMnVS0slgU0

discuss

Oh man, this takes me back to 2005 when I first moved to Pg and needed replication. Its replication is statement based, i.e. sends each DML query to all nodes. That means every write query must be deterministic. That wasn't always obvious. Though it did work for us until we moved to Slony then block level WAL replication. Thankfully we have logical replication today, even if it's still a bit more painful than MySQL.

jamesfinlayson|1 year ago

> Slony

Gosh, haven't heard that in years. I remember a company I used to work for used it on their old system but the new system didn't use it for whatever reason.