Charmed MySQL

  • By Canonical Data Platform
  • Cloud
Channel Revision Published Runs on
8.0/stable 240 20 Jun 2024
Ubuntu 22.04
8.0/candidate 240 17 Jun 2024
Ubuntu 22.04
8.0/beta 240 17 Jun 2024
Ubuntu 22.04
8.0/edge 253 12 Jul 2024
Ubuntu 22.04
8.0/edge 252 12 Jul 2024
Ubuntu 22.04
juju deploy mysql --channel 8.0/stable
Show information



Clients for Async replication

WARNING: it is an ‘8.0/candidate’ article. Do NOT use it in production!
Contact Canonical Data Platform team if you are interested in the topic.


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

Offer and consume DB endpoints

juju switch rome
juju offer db1:database db1-database

juju switch lisbon
juju offer db2:database db2-database

juju add-model app ; juju switch app
juju consume rome.db1-database
juju consume lisbon.db2-database

Internal Juju app/clients

juju switch app

juju deploy mysql-test-app
juju deploy mysql-router --channel dpe/edge

juju relate mysql-test-app mysql-router
juju relate mysql-router db1-database

External Juju clients

juju switch app

juju deploy data-integrator --config database-name=mydatabase
juju deploy mysql-router mysql-router-external --channel dpe/edge

juju relate data-integrator mysql-router-external
juju relate mysql-router-external db1-database

juju run data-integrator/leader get-credentials