Re: Scalable cluster

Поиск
Список
Период
Сортировка
От Gregg Jaskiewicz
Тема Re: Scalable cluster
Дата
Msg-id CAJY59_jFd+V3nsNGuz6aFzPHnPEqhU5PRKaJBFLfe2QsCvUi4w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Scalable cluster  (John R Pierce <pierce@hogranch.com>)
Ответы Re: Scalable cluster
Список pgsql-general



On 3 March 2013 22:56, John R Pierce <pierce@hogranch.com> wrote:

did you look at pgbouncer ?  thats the simple pooler for postgres, and its quite robust, because its so simple.


Yes, it is one of the solutions I do consider. Having applications decide whether they should write to master, or use slaves and/or master for read queries (for instance in case it is a transaction, etc). 

I wonder however, how others are handing it. There seems to be nothing out there apart from pgbouncer and pgpool. And only the latter can handle (albeit not really that quick) pooling between master and slaves. 
 
How do you guys go about designing such cluster. 


--
GJ

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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Scalable cluster
Следующее
От: G N
Дата:
Сообщение: out of memory issue