Обсуждение: Postgres warm standby in production

Поиск
Список
Период
Сортировка

Postgres warm standby in production

От
Dmitry Mordovin
Дата:
Dear friends!

Anybody use Postgres 9.5 warm standby in production?

Which schemes you use?

My setup:
  - 2 DB servers (master and slave)
  - 4 APP servers (tomcat)

Each tomcat server have JDBC connect to master and prepared config for
slave.
Business task permit switch between DB server on APP servers manually
when failover.

What is the best scheme in my configuration?

BR, Dmitry