Обсуждение: Switchover
Hi all,
Any idea what prerequisite I should follow before I use the command patronictl switchover?
Do I have to take a downtime of few mns and stop the applications and do a switchover?
What happens internally when we use the command patronictl switchover? Just that the role is changed? Will it affect incoming connections?
On Sat, 23 Dec 2023, 23:38 Rajesh Kumar, <rajeshkumar.dba09@gmail.com> wrote:
Hi all,Any idea what prerequisite I should follow before I use the command patronictl switchover?
Patroni communication channels:
https://patroni.readthedocs.io/en/latest/CONTRIBUTING.html#contributing
br
Kaido
https://patroni.readthedocs.io/en/latest/CONTRIBUTING.html#contributing
br
Kaido
On Thu, 28 Dec 2023 at 07:39, Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
Do I have to take a downtime of few mns and stop the applications and do a switchover?What happens internally when we use the command patronictl switchover? Just that the role is changed? Will it affect incoming connections?On Sat, 23 Dec 2023, 23:38 Rajesh Kumar, <rajeshkumar.dba09@gmail.com> wrote:Hi all,Any idea what prerequisite I should follow before I use the command patronictl switchover?
In my experience: - Patroni switchover happens in a few seconds - If you use pgbouncer, the client connections don't get dropped. A client that issues a query in that brief window willget an error. - If your clients have retry logic, your users will never notice the failover. -- Scott Ribe scott_ribe@elevated-dev.com https://www.linkedin.com/in/scottribe/ > On Dec 27, 2023, at 10:38 PM, Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote: > > Do I have to take a downtime of few mns and stop the applications and do a switchover? > > What happens internally when we use the command patronictl switchover? Just that the role is changed? Will it affect incomingconnections? > > On Sat, 23 Dec 2023, 23:38 Rajesh Kumar, <rajeshkumar.dba09@gmail.com> wrote: > Hi all, > > > Any idea what prerequisite I should follow before I use the command patronictl switchover?
Can I take a small downtime and stop all applications and switchover or shall I simply switchover during low traffic time?
On Thu, 28 Dec 2023, 19:55 Scott Ribe, <scott_ribe@elevated-dev.com> wrote:
In my experience:
- Patroni switchover happens in a few seconds
- If you use pgbouncer, the client connections don't get dropped. A client that issues a query in that brief window will get an error.
- If your clients have retry logic, your users will never notice the failover.
--
Scott Ribe
scott_ribe@elevated-dev.com
https://www.linkedin.com/in/scottribe/
> On Dec 27, 2023, at 10:38 PM, Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
>
> Do I have to take a downtime of few mns and stop the applications and do a switchover?
>
> What happens internally when we use the command patronictl switchover? Just that the role is changed? Will it affect incoming connections?
>
> On Sat, 23 Dec 2023, 23:38 Rajesh Kumar, <rajeshkumar.dba09@gmail.com> wrote:
> Hi all,
>
>
> Any idea what prerequisite I should follow before I use the command patronictl switchover?