Charmed MySQL
- Canonical
- Cloud
| Channel | Revision | Published | Runs on |
|---|---|---|---|
| 8.0/stable | 240 | 20 Jun 2024 | |
| 8.0/candidate | 297 | 15 Oct 2024 | |
| 8.0/candidate | 296 | 15 Oct 2024 | |
| 8.0/beta | 297 | 07 Oct 2024 | |
| 8.0/beta | 296 | 07 Oct 2024 | |
| 8.0/edge | 303 | 09 Oct 2024 | |
| 8.0/edge | 302 | 09 Oct 2024 |
juju deploy mysql --channel 8.0/edge
Deploy universal operators easily with Juju, the Universal Operator Lifecycle Manager.
Platform:
22.04
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 no longer exist (lost) ONLY! 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
forcewill cause the old primary to be invalidated.