Re: replication help ...

Поиск
Список
Период
Сортировка
От Hunley, Douglas
Тема Re: replication help ...
Дата
Msg-id CAAD=pwG_VBXUt3sq4vrzj6v=uCBdvtK5bevKdj-x3Ww8-pp6rQ@mail.gmail.com
обсуждение исходный текст
Ответ на replication help ...  (Sunil N Shinde <Sunil.Shinde@mastek.com>)
Список pgsql-admin

On Thu, Sep 22, 2016 at 12:51 AM, Sunil N Shinde <Sunil.Shinde@mastek.com> wrote:

I need to create some concrete document regarding the replication method.

We want to suggest best method for load balancing to client.


If you're wanting load balancing, then you need a hot standby and pgPool-II. This will send writes to the master and reads to the slave.

You probably want async replication. Unless you're doing financial transaction (or similar) where it must be guaranteed to be written in two places (then you want sync). Note though that this both slows down the master's performance (it waits for the slave to ACK the write) and makes the slave a point of failure since the master can't commit if it is down (unless you setup multiple slaves and have them all ready to assume the sync role)


--
{
  "name" : "douglas j hunley",
  "email" : "douglas.hunley@openscg.com",
  "title" : "database engineer",
  "phone" : "+1 614 316 5079",
}

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

Предыдущее
От: Tomáš Uko
Дата:
Сообщение: Re: Problem with extension
Следующее
От: Rainer Leo
Дата:
Сообщение: connection problems