Hi Laurenz,
Thank you for your answer
>> For some projects we need a fast manual switchover to address Near Zero downtime maintenance
I forgot to say that application would not be stopped during maintenance…
I forgot to say that application would not be stopped during maintenance…
>There is no need for synchronous replication; you cannot lose data with a switchover,
>if you do it right:
Ok
>> May logical replication ( bi-directional, with one instance RW and the other RO) be a better solution ?
> I'd say no.
Really ?
>> what could we expect (in term of downtime in both worlds) ?
> Usually seconds, so plan for ten minutes.
>> what could we expect (in term of downtime in both worlds) ?
> Usually seconds, so plan for ten minutes.
Brrr, I was thînking about a more reliable process.
Regards
PAscal
