Re: [GENERAL] PostgreSQl HA solution

2016-11-30 Thread Jehan-Guillaume de Rorthais 
On Wed, 30 Nov 2016 08:58:13 -0800
"Joshua D. Drake"  wrote:

> On 11/30/2016 06:00 AM, Marcin Giedz wrote:
> > Hello,
> >
> > Does anyone know any reliable open source HA solution with stream
> > replication and IP live migration in case of master node failure?
> > Recently I've been attending Fujitsu PostgreSQL webinar and they
> > presented so called "mirroring controler" + sync stream replication .
> > I'm wondering if this combines of regular stream replication + some kind
> > of keepalive mechanism ?  
> 
> LinuxHA/Pacemaker/Corosync can do this.

Just for the record, PAF is a new resource agent for such stack. It just
replaces the default "pgsql" RA delivered in the resource-agents package on
various distro.

Regards,


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] PostgreSQl HA solution

2016-11-30 Thread Joshua D. Drake 

On 11/30/2016 06:00 AM, Marcin Giedz wrote:

Hello,

Does anyone know any reliable open source HA solution with stream
replication and IP live migration in case of master node failure?
Recently I've been attending Fujitsu PostgreSQL webinar and they
presented so called "mirroring controler" + sync stream replication .
I'm wondering if this combines of regular stream replication + some kind
of keepalive mechanism ?


LinuxHA/Pacemaker/Corosync can do this.

JD


--
Command Prompt, Inc.  http://the.postgres.company/
+1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.
Unless otherwise stated, opinions are my own.


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] PostgreSQl HA solution

2016-11-30 Thread Jehan-Guillaume de Rorthais 
On Wed, 30 Nov 2016 15:00:16 +0100 (CET)
Marcin Giedz  wrote:

> Hello, 
> 
> Does anyone know any reliable open source HA solution with stream replication
> and IP live migration in case of master node failure? Recently I've been
> attending Fujitsu PostgreSQL webinar and they presented so called "mirroring
> controler" + sync stream replication . I'm wondering if this combines of
> regular stream replication + some kind of keepalive mechanism ? 

You should look at PostgreSQL Automatic Failover project:

  http://dalibo.github.io/PAF/

It relies on the Pacemaker project, the industry reference for HA under Linux.
 
Make sure to consult the documentation, especially the quick starts:

  http://dalibo.github.io/PAF/documentation.html

Installation: http://dalibo.github.io/PAF/install.html

Here is some conference slides including video of demos:

  http://www.dalibo.org/_media/2016-pgconfeu-paf.html.gz

PAF only requiers streaming replication between nodes. Whether you want it sync
or async is your choice.

2.0 is perfect for production. 2.1 with minor improvements should be out before
2017 hopefully (see github commit history if curious).

It appears PAF 2.0 (or 2.1 if released before 2017) might be included in
Debian 9. There is a pending discussion with a Debian packager.

Regards,
-- 
Jehan-Guillaume (ioguix) de Rorthais
Dalibo


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] PostgreSQl HA solution

2016-11-30 Thread Marcin Giedz 
Hello, 

Does anyone know any reliable open source HA solution with stream replication 
and IP live migration in case of master node failure? Recently I've been 
attending Fujitsu PostgreSQL webinar and they presented so called "mirroring 
controler" + sync stream replication . I'm wondering if this combines of 
regular stream replication + some kind of keepalive mechanism ? 

Regards 
Marcin