Mult-standby streaming replication master failover

From: Vladislav Tchernev <vtchernev(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Mult-standby streaming replication master failover
Date: 2015-02-09 16:26:50
Message-ID: CAABbR0F2xbMM94f4Kf6X66yqqsUMGMto-NjncgDutCXYgKDfxw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello All,
I am trying to figure out a clear way to preform a post-disaster (where the
master hasn't had the chance to shut down properly) master failover in a
multi-standby streaming replication setup. I found a couple of old posts
suggesting that the choice of the new master is very important and if not
done correctly might lead to database corruption.The posts suggest that the
first thing to do is to find the most caught-up replica, by compare WAL
replay locations among all standby servers. This makes perfect scene but
also makes the failover process a little bit more complicated and difficult
to automate. I guess my question is, does my understanding is right and if
there are any changes in this regard in the newer Postgresql 9.3/9.4
releases.

Best,
Vlad

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Drolet 2015-02-09 16:37:30 Re: Cluster seems broken after pg_basebackup
Previous Message Oliver 2015-02-09 14:11:52 Re: Change postgresql encoding