Charmed MySQL K8s

Channel Revision Published Runs on
8.0/stable 180 02 Sep 2024
Ubuntu 22.04
8.0/stable 181 02 Sep 2024
Ubuntu 22.04
8.0/candidate 180 26 Aug 2024
Ubuntu 22.04
8.0/candidate 181 26 Aug 2024
Ubuntu 22.04
8.0/beta 207 15 Nov 2024
Ubuntu 22.04
8.0/beta 206 15 Nov 2024
Ubuntu 22.04
8.0/edge 207 09 Oct 2024
Ubuntu 22.04
8.0/edge 206 09 Oct 2024
Ubuntu 22.04
juju deploy mysql-k8s --channel 8.0/stable
Show information

Platform:

Switchover / Failover of Async replication

Pre-requisits

Make sure both Rome and Lisbon Clusters are deployed using the Async Deployment manual!

Switchover (safe)

Assuming Rome is currently Primary and you want to promote Lisbon to be new primary
(Rome will be converted to StandBy member):

juju run -m lisbon db2/leader promote-to-primary 

Failover (forced)

Warning: this is a dangerous operation which can cause the split-brain situation.
It should be executed if Primary cluster is NOT recoverable any longer!
Otherwise please use safe ‘switchover’ procedure above!

Assuming Rome was a Primary (before we lost the cluster Rome) and you want to promote Lisbon to be the new primary:

juju run -m lisbon db2/leader promote-to-primary force=True

Warning: The force will cause the old primary to be invalidated.


Help improve this document in the forum (guidelines). Last updated 2 months ago.