Postgres Pro
Downloads
Home   >   mailing lists

Thread: replication help ...

replication help ...

From
Sunil N Shinde
Date:

Hi,

 

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

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

 

I have gone through the below link. But could not formulate the exact document to put forward to  client regarding the best solution .

 

                https://www.postgresql.org/docs/9.5/static/high-availability.html

 

I am bit confused with the terms Hot standby, warm standby, streaming replication, log shipping, synchronous, asynchronous, etc.

I can understand the meaning and definition. But I am unable to consolidate in a proper manner or order or unable to correlate with each other.

 

Can someone please help me in this regard?

 

 

Thanks & Regards,

Sunil N Shinde

 

Re: replication help ...

From
"Hunley, Douglas"
Date:

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",
}