Re: Fully-automatic streaming replication failover when master dies?

On Fri, Jan 24, 2014 at 1:38 AM, Susan Cassidy <
susan(dot)cassidy(at)decisionsciencescorp(dot)com> wrote:

> pgpool-II may do what you want. Lots of people use it.
>

I don't think pgpool adds the lost node on its own (once the node is live
or available again). Plus if you have a 3 node replication you need to have
your own failover_command (as a shell script) which changes the master node
for 2nd secondary when one of the secondary servers decides to be promoted
to primary). I hope things will get easy with version 9.4 (I guess in 9.4
one won't have to rebuild a master node from backup. if the wal files are
available it will just roll forward).

> for all the machines). At least MongoDB does the work well, and with
> almost
> > zero configuration.
> Mongo's data guarantees are, um, somewhat less robust than
> PostgreSQL's.

I don't think this has anything to do with data reliability or ACID
property (if that is what you are referring to).

Failover is easy if you don't have to be exactly right.

IMHO That's not a fair point. PostgreSQL supports sync replication (as well
as async) and does that complicate the failover process or an async
replication? I guess what he is asking for is automation of whatever
feature PostgreSQL already supports.

Best Regards,
*Sameer Kumar | Database Consultant*

*ASHNIK PTE. LTD.*101 Cecil Street, #11-11 Tong Eng Building, Singapore
069533
M : *+65 8110 0350 <%2B65%208110%200350>* T: +65 6438 3504 | www.ashnik.com
www.facebook.com/ashnikbiz | www.twitter.com/ashnikbiz

[image: email patch]

This email may contain confidential, privileged or copyright material and
is solely for the use of the intended recipient(s).