Groups > comp.databases.postgresql > #537

Re: PostgreSQL replication using DRBD multi primary + GFS2??

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From	Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Newsgroups	comp.databases.postgresql
Subject	Re: PostgreSQL replication using DRBD multi primary + GFS2??
Date	Tue, 21 Jan 2014 16:24:16 +0100
Organization	A noiseless patient Spider
Lines	23
Message-ID	<m2lhy91hpb.fsf@2ndQuadrant.fr> (permalink)
References	<cbdd63f8-a168-48d7-a30d-0dd06097afaf@googlegroups.com> <m2k3dvhflg.fsf@2ndQuadrant.fr> <28bcf6e3-95bd-471c-bd81-eac2214aefef@googlegroups.com>
Mime-Version	1.0
Content-Type	text/plain
Injection-Info	mx05.eternal-september.org; posting-host="e13479fb90181b35a4db8ef1a01113af"; logging-data="31670"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18iXtogaZWYTpm6dM8pDR3x"
User-Agent	Gnus/5.130008 (Ma Gnus v0.8) Emacs/24.3 (darwin)
Cancel-Lock	sha1:8H8dTsr5WUO1zTaqwNb5224cQw0= sha1:Uor0Rc+id/aGqTr8AR+YpYp0/hQ=
Xref	csiph.com comp.databases.postgresql:537

Show key headers only | View raw

cancedda@gmail.com writes:
> We tried that already but long queries being run on the master break
> replication and make running queries on the slave impossible to complete.
>
> Or that's what I got reading about the error.

When using Hot Standby you need to be careful about the setup, which is
quite different if you are implementing HA or load balancing. With async
replication you always are going to have conflicts to handle, here as
the stanbdy is read-only the conflicts are limited to replaying actions
from the primary that are incompatible with the queries run on the
standby.

See the following parameters to help PostgreSQL figure out you're
wanting to implement Load Balancing:

  max_standby_streaming_delay = '20 mins'
  hot_standby_feedback = on

Regards,
-- 
Dimitri Fontaine
PostgreSQL DBA, Architecte

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Find similar

Thread

PostgreSQL replication using DRBD multi primary + GFS2?? cancedda@gmail.com - 2014-01-19 10:15 -0800
  Re: PostgreSQL replication using DRBD multi primary + GFS2?? Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2014-01-19 21:38 +0100
    Re: PostgreSQL replication using DRBD multi primary + GFS2?? cancedda@gmail.com - 2014-01-21 07:01 -0800
      Re: PostgreSQL replication using DRBD multi primary + GFS2?? Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2014-01-21 16:24 +0100

csiph-web