Re: replication help ... - Mailing list pgsql-admin

From Hunley, Douglas
Subject Re: replication help ...
Date
Msg-id CAAD=pwG_VBXUt3sq4vrzj6v=uCBdvtK5bevKdj-x3Ww8-pp6rQ@mail.gmail.com
Whole thread Raw
In response to replication help ...  (Sunil N Shinde <Sunil.Shinde@mastek.com>)
List 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 by date:

Previous
From: Tomáš Uko
Date:
Subject: Re: Problem with extension
Next
From: Rainer Leo
Date:
Subject: connection problems