Re: Failover with a tertiary read-only secondary

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: Failover with a tertiary read-only secondary
Дата
Msg-id CAGrpgQ8chc67K0M+XYRfAAjyHcRp5tEjHd-FYOh4o+E4zLBM9w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Failover with a tertiary read-only secondary  ("Hammerman, Joseph" <JosephHammerman@iheartmedia.com>)
Ответы Re: Failover with a tertiary read-only secondary  (Jerry Sievers <gsievers19@comcast.net>)
Список pgsql-admin
On Fri, Mar 31, 2017 at 11:35 AM, Hammerman, Joseph <JosephHammerman@iheartmedia.com> wrote:
  1. Not a bad idea, but that only delays the necessity of a resync until the next failover…. Unless I’m missing something?
I've used cascading replication extensively over the past few years and rarely had to resync a downstream replica. The several thousand Postgres clusters I'm administering now are almost exclusively set up with the primary replica streaming from the master and the master shipping WALs to the secondary replica in DR data centre, so I can't test any cascading replication promotions at the moment. My suggestion is to test your replication setup in a cascade and see what happens, I don't expect you'll need to resync. If you do, report back with how you've set up your replication settings.

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Hammerman, Joseph"
Дата:
Сообщение: Re: Failover with a tertiary read-only secondary
Следующее
От: Jerry Sievers
Дата:
Сообщение: Re: Failover with a tertiary read-only secondary