How to send queries to master and failover to slave ?
| От | Benoit Salotti |
|---|---|
| Тема | How to send queries to master and failover to slave ? |
| Дата | |
| Msg-id | CAH9tKGn1QpazJjt6jxGfXO-tDMTYbrBUzxz4cZaESZt==6x_BQ@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: How to send queries to master and failover to slave ?
Re: How to send queries to master and failover to slave ? Re: How to send queries to master and failover to slave ? Re: How to send queries to master and failover to slave ? RE: How to send queries to master and failover to slave ? |
| Список | pgsql-jdbc |
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 по дате отправления: