Charmed MySQL

  • By Canonical Data Platform
  • Cloud
Channel Revision Published Runs on
8.0/stable 196 29 Sep 2023
Ubuntu 22.04
8.0/candidate 239 10 Jun 2024
Ubuntu 22.04
8.0/beta 239 10 Jun 2024
Ubuntu 22.04
8.0/edge 239 10 Jun 2024
Ubuntu 22.04
juju deploy mysql --channel 8.0/stable
Show information

Platform:

Ubuntu
22.04

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.

Pre-requisits

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