Re: How to send queries to master and failover to slave ?

Поиск
Список
Период
Сортировка
От Mikko Tiihonen
Тема Re: How to send queries to master and failover to slave ?
Дата
Msg-id AM4PR0701MB20512F08D340B07CEFFCD13DE6220@AM4PR0701MB2051.eurprd07.prod.outlook.com
обсуждение исходный текст
Ответ на How to send queries to master and failover to slave ?  (Benoit Salotti <benoit.salotti@gmail.com>)
Ответы Re: How to send queries to master and failover to slave ?  (Benoit Salotti <benoit.salotti@gmail.com>)
Список pgsql-jdbc
Дерево обсуждения

Assuming that the old slave will become new master if master ever goes down then the option "master" would do what you want. Right?

But if you do take the master down for maintenance without failing over to slave then yes. A small code change could be done to add support for preferMaster.


-Mikko

From: pgsql-jdbc-owner@postgresql.org <pgsql-jdbc-owner@postgresql.org> on behalf of Benoit Salotti <benoit.salotti@gmail.com>
Sent: 28 June 2016 12:41
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] How to send queries to master and failover to slave ?
 
Hi all,

I have a setup with 1 master and 1 slave (hot standy to serve read queries if necessary).
I would like the JDBC driver to talk preferrably to the master (to be sure to get the freshest data). If the master is not available I would like to send the queries to the slave.

The documentation mentions the following values for the parameter targetServerType: any, master, slave, preferSlave.
I'm surprised there is no preferMaster option which would allow me to implement easily my requirement.

Anyone already encountered the same need ?

Regards,

Benoit

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Benoit Salotti
Дата:
Сообщение: How to send queries to master and failover to slave ?
Следующее
От: John R Pierce
Дата:
Сообщение: Re: How to send queries to master and failover to slave ?