public inbox for [email protected]  

help / color / mirror / Atom feed

From: legrand legrand <[email protected]>
To: [email protected] <[email protected]>
Subject: Fast switchover
Date: Mon, 8 Sep 2025 15:03:41 +0000
Message-ID: <AS1P190MB17014CF63D3EDDB0F4F7B66B900CA@AS1P190MB1701.EURP190.PROD.OUTLOOK.COM> (raw)

Hello all the readers,

For some projects we need a fast manual switchover to address Near Zero downtime maintenance
(not speaking here about automated failover like those provided by HA tools, but just planned, controlled operations)


Database Physical replication switchover itself:
- initial replication (before switchover) should be synchronous or replication LAG should be controlled to prevent data loss.
- Switchover duration seems not "compressible" under a few seconds (because of primary shutdown, promotion, new standby catch up, ...)
- Application retry strategy (after disconnection) should be tuned using proper retry delay. Pooler or specific driver may help.


May logical replication ( bi-directional, with one instance RW and the other RO) be a better solution ?
This solution is more complex because of sequences, DDL, Large Objects, Conflict resolution (if any)
but switchover should be faster ...

what could we expect (in term of downtime in both worlds) ?
Are there any Logical Replication Manager available, or admin tools (preferably open source) ?
any feedback is welcome

Thanks in advance
Regards
PAscal

view thread (2+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Fast switchover
  In-Reply-To: <AS1P190MB17014CF63D3EDDB0F4F7B66B900CA@AS1P190MB1701.EURP190.PROD.OUTLOOK.COM>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox