| From: | Greg Stark <gsstark(at)mit(dot)edu> |
|---|---|
| To: | Yaroslav Tykhiy <yar(at)barnet(dot)com(dot)au> |
| Cc: | Bryan Murphy <bmurphy1976(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Failover, Wal Logging, and Multiple Spares |
| Date: | 2009-08-18 00:59:45 |
| Message-ID: | 407d949e0908171759u53bcf0acq7587b4c9f5d0f783@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Aug 18, 2009 at 1:25 AM, Yaroslav Tykhiy<yar(at)barnet(dot)com(dot)au> wrote:
> Encouraged by Bruce Momjian, I tried and had some success in this area. It
> was a controlled failover but it worked like a charm. An obvious condition
> was that the warm standbys be in perfect sync; you can't do the trick if
> some of them received the last WAL segment while the others didn't.
It seems like it should be possible to weaken this constraint. As long
as you're careful to fail over to the slave which is the furthest
ahead in replaying WAL. All the other slaves must switch to replaying
logs from the new master before the point where it took over.
This does seem like a very useful area to explore.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Crawford | 2009-08-18 01:03:12 | Re: Get most recent message between users? |
| Previous Message | Sam Mason | 2009-08-18 00:53:40 | Re: Get most recent message between users? |