Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #534 > unrolled thread

PostgreSQL replication using DRBD multi primary + GFS2??

Back to article view | Back to comp.databases.postgresql

Contents

  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

#534 — PostgreSQL replication using DRBD multi primary + GFS2??

Hi everyone,

As per subject, would such a setup work?

What I need is the fastest replication possible and the second PostgreSQL server should be a read only just to run reports and selects.

Thanks for the answers.

[toc] | [next] | [standalone]

#535

cancedda@gmail.com writes:
> What I need is the fastest replication possible and the second PostgreSQL
> server should be a read only just to run reports and selects.

  http://www.postgresql.org/docs/current/interactive/hot-standby.html

-- 
Dimitri Fontaine
PostgreSQL DBA, Architecte

[toc] | [prev] | [next] | [standalone]

#536

On Sunday, 19 January 2014 20:38:35 UTC, Dimitri Fontaine  wrote:
> **@gmail.com writes:
> 
> > What I need is the fastest replication possible and the second PostgreSQL
> 
> > server should be a read only just to run reports and selects.
> 
> 
> 
>   http://www.postgresql.org/docs/current/interactive/hot-standby.html
> 
> 
> 
> -- 
> 
> Dimitri Fontaine
> 
> PostgreSQL DBA, Architecte

Hi Dimitri,

Thanks for the answer.

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.

Please let me know if I'm wrong.

Kind regards,
Marco

[toc] | [prev] | [next] | [standalone]

#537

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

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.postgresql

csiph-web