Load balancing in postgres master slave HA cluster

Поиск

Список

Период

Сортировка

От	soumitra bhandary
Тема	Load balancing in postgres master slave HA cluster
Дата	19 февраля 2019 г. 12:13:51
Msg-id	PN1PR0101MB210960505AC86C0E5C6A2607E07C0@PN1PR0101MB2109.INDPRD01.PROD.OUTLOOK.COM обсуждение исходный текст
Ответы	Re: Load balancing in postgres master slave HA cluster Re: Load balancing in postgres master slave HA cluster Re: Load balancing in postgres master slave HA cluster Re: Load balancing in postgres master slave HA cluster Re: Load balancing in postgres master slave HA cluster
Список	pgsql-admin

Hi ,

Any one has experience on working with HA proxy set up with Postgres Master Slave replication .

Query : I would like to divert the Write requests to Master and all read requests to Slave server .

To achieve that can I use HA proxy server ? If any one has already implemented the same . Please share me the steps .

Or ,

Any other method can be used to achieve the same using freeware .

Thanks

Soumitra

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

От: Steven Crandell
Дата: 18 февраля 2019 г., 22:11:21
Сообщение: Re: Make grant all on all tables in schema x persistent for new tables

От: Prince Pathria
Дата: 19 февраля 2019 г., 12:20:57
Сообщение: Re: Load balancing in postgres master slave HA cluster