1

I have multiple Postgres servers up, running in master / slave streaming replication mode.

I was wondering what the suggested methods of routing write traffic to the master, and the read traffic to the slave nodes.

1 Answer 1

1

PgPool-II can do this, with some limitations, as outlined in its user manual.

The best way is to make the application aware of which queries are read-only/poolable, and which are write queries that must go to the master.

There aren't really any other alternatives at this point.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.