Charmed MySQL K8s
- By Canonical Data Platform
| Channel | Revision | Published | Runs on |
|---|---|---|---|
| 8.0/stable | 75 | 20 Apr 2023 | |
| 8.0/candidate | 75 | 20 Apr 2023 | |
| 8.0/beta | 75 | 20 Apr 2023 | |
| 8.0/edge | 83 | 26 May 2023 |
juju deploy mysql-k8s --channel 8.0/stable
You will need Juju 2.9 to be able to run this command. Learn how to upgrade to Juju 2.9.
Deploy Kubernetes operators easily with Juju, the Universal Operator Lifecycle Manager. Need a Kubernetes cluster? Install MicroK8s to create a full CNCF-certified Kubernetes system in under 60 seconds.
Platform:
How to enable monitoring
Creating and listing backups requires that you:
Switch to COS K8s environment and offer COS interfaces to be cross-model related with Charmed MySQL K8s model:
# Switch to Kubernetes controller, for the cos model.
juju switch <k8s_cos_controller>:<cos_model_name>
juju offer grafana:grafana-dashboard grafana-dashboards
juju offer loki:logging loki-logging
juju offer prometheus:metrics-endpoint prometheus-metrics-endpoint
Switch to Charmed MySQL K8s model, find offers and consume them:
# We are on the Kubernetes controller, for the cos model. Switch to mysql model
juju switch <k8s_db_controller>:<mysql_model_name>
juju find-offers <k8s_cos_controller>:
A similar output should appear, if k8s is the k8s controller name and cos the model where cos-lite has been deployed:
Store URL Access Interfaces
k8s admin/cos:grafana-dashboard admin grafana_dashboard:grafana-dashboard
k8s admin/cos.loki-logging admin loki_push_api:logging
k8s admin/cos.prometheus-metrics-endpoint admin prometheus-metrics-endpoint:metrics-endpoint
...
Consume offers to be reachable in the current model:
juju consume k8s:admin/cos.grafana-dashboards
juju consume k8s:admin/cos.loki-logging
juju consume k8s:admin/cos.prometheus-metrics-endpoint
Now, relate Charmed MySQL K8s with newly consumed COS offers:
juju relate mysql-k8s grafana-dashboards
juju relate mysql-k8s loki-logging
juju relate mysql-k8s prometheus-metrics-endpoint
After this is complete, Grafana will show the new dashboards: MySQL Exporter and allows access for Charmed MySQL logs on Loki.
The example of juju status on Charmed MySQL K8s model:
Model Controller Cloud/Region Version SLA Timestamp
mysql charmed-dev microk8s/localhost 2.9.42 unsupported 02:20:09+02:00
SAAS Status Store URL
grafana-dashboards active charmed-dev admin/cos.grafana-dashboards
loki-logging active charmed-dev admin/cos.loki-logging
prometheus-metrics-endpoint active charmed-dev admin/cos.prometheus-metrics-endpoint
App Version Status Scale Charm Channel Rev Address Exposed Message
mysql-k8s 8.0.32-0ubuntu0.22.04.2 active 1 mysql-k8s 8.0/stable 61 10.152.183.115 no Primary
Unit Workload Agent Address Ports Message
mysql-k8s/0* active idle 10.1.84.116 Primary
The example of juju status on COS K8s model:
Model Controller Cloud/Region Version SLA Timestamp
cos charmed-dev microk8s/localhost 2.9.42 unsupported 02:20:11+02:00
App Version Status Scale Charm Channel Rev Address Exposed Message
alertmanager 0.23.0 active 1 alertmanager-k8s stable 47 10.152.183.206 no
catalogue active 1 catalogue-k8s stable 13 10.152.183.183 no
grafana 9.2.1 active 1 grafana-k8s stable 64 10.152.183.140 no
loki 2.4.1 active 1 loki-k8s stable 60 10.152.183.241 no
prometheus 2.33.5 active 1 prometheus-k8s stable 103 10.152.183.240 no
traefik 2.9.6 active 1 traefik-k8s stable 110 10.76.203.178 no
Unit Workload Agent Address Ports Message
alertmanager/0* active idle 10.1.84.125
catalogue/0* active idle 10.1.84.127
grafana/0* active idle 10.1.84.83
loki/0* active idle 10.1.84.79
prometheus/0* active idle 10.1.84.96
traefik/0* active idle 10.1.84.119
Offer Application Charm Rev Connected Endpoint Interface Role
grafana-dashboards grafana grafana-k8s 64 1/1 grafana-dashboard grafana_dashboard requirer
loki-logging loki loki-k8s 60 1/1 logging loki_push_api provider
prometheus-metrics-endpoint prometheus prometheus-k8s 103 1/1 metrics-endpoint prometheus_scrape requirer
To connect Grafana WEB interface, follow the COS section “Browse dashboards”.
Help us improve this documentation
Most of this documentation can be collaboratively discussed and changed on the respective topic in the doc category of the Charmhub forum. See the documentation guidelines if you’d like to contribute.