How to enable monitoring
Enable monitoring requires that you:
- Have a PgBouncer deployed
- Deploy
cos-litebundle in a Kubernetes environment - COS configured for Charmed PostgreSQL
Switch to COS K8s environment and offer COS interfaces to be cross-model related with PgBouncer model:
# Switch to Kubernetes controller, for the cos model.
juju switch <k8s_cos_controller>:<cos_model_name>
juju offer grafana:grafana-dashboard grafana
juju offer loki:logging loki
juju offer prometheus:receive-remote-write prometheus
Switch to PgBouncer model, find offers and consume them:
# We are on the Kubernetes controller, for the cos model. Switch to postgresql model
juju switch <vm_controller>:<postgresql_model_name>
juju find-offers <k8s_cos_controller>: # Do not miss ':' here!
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 admin grafana:grafana-dashboard
k8s admin/cos.loki admin loki:logging
k8s admin/cos.prometheus admin prometheus:receive-remote-write
...
Consume offers to be reachable in the current model:
juju consume <k8s_cos_controller>:admin/cos.grafana
juju consume <k8s_cos_controller>:admin/cos.loki
juju consume <k8s_cos_controller>:admin/cos.prometheus
Now, deploy ‘grafana-agent’ (as pgbouncer-cos-agent) and integrate (relate) it with PgBouncer, later integrate (relate) pgbouncer-cos-agent with consumed COS offers:
juju deploy grafana-agent pgbouncer-cos-agent
juju relate pgbouncer-cos-agent grafana
juju relate pgbouncer-cos-agent loki
juju relate pgbouncer-cos-agent prometheus
juju relate pgbouncer-cos-agent pgbouncer:cos-agent
juju relate pgbouncer-cos-agent data-integrator:juju-info
After this is complete, Grafana will show the new dashboards: PgBouncer Exporter and allows access for PgBouncer logs on Loki.
The example of juju status for Charmed PostgreSQL K8s + PgBouncer K8s model:
Model Controller Cloud/Region Version SLA Timestamp
tutorial lxd localhost/localhost 3.1.8 unsupported 01:24:48+02:00
SAAS Status Store URL
grafana active mk8s admin/cos.grafana
loki active mk8s admin/cos.loki
prometheus active mk8s admin/cos.prometheus
App Version Status Scale Charm Channel Rev Exposed Message
data-integrator active 1 data-integrator latest/stable 27 no
pgbouncer 1.21.0 active 1 pgbouncer 1/stable 88 no
pgbouncer-cos-agent active 1 grafana-agent latest/stable 65 no
postgresql 14.10 active 1 postgresql 14/stable 363 no Primary
Unit Workload Agent Machine Public address Ports Message
data-integrator/0* active idle 1 10.184.219.188
pgbouncer-cos-agent/0* active idle 10.184.219.188
pgbouncer/0* active idle 10.184.219.188
postgresql/0* active idle 0 10.184.219.86 5432/tcp Primary
Machine State Address Inst id Base AZ Message
0 started 10.184.219.86 juju-801057-0 ubuntu@22.04 Running
1 started 10.184.219.188 juju-801057-1 ubuntu@22.04 Running
The example of juju status on COS K8s model:
Model Controller Cloud/Region Version SLA Timestamp
cos mk8s microk8s/localhost 3.1.6 unsupported 01:23:57+02:00
App Version Status Scale Charm Channel Rev Address Exposed Message
alertmanager 0.27.0 active 1 alertmanager-k8s latest/edge 112 10.152.183.130 no
catalogue active 1 catalogue-k8s latest/edge 39 10.152.183.96 no
grafana 9.5.3 active 1 grafana-k8s latest/edge 112 10.152.183.208 no
loki 2.9.5 active 1 loki-k8s latest/edge 144 10.152.183.153 no
prometheus 2.50.1 active 1 prometheus-k8s latest/edge 186 10.152.183.116 no
traefik v2.11.0 active 1 traefik-k8s latest/edge 189 10.76.203.38 no
Unit Workload Agent Address Ports Message
alertmanager/0* active idle 10.1.204.230
catalogue/0* active idle 10.1.204.201
grafana/0* active idle 10.1.204.227
loki/0* active idle 10.1.204.239
prometheus/0* active idle 10.1.204.222
traefik/0* active idle 10.1.204.223
Offer Application Charm Rev Connected Endpoint Interface Role
grafana grafana grafana-k8s 112 1/1 grafana-dashboard grafana_dashboard requirer
loki loki loki-k8s 144 1/1 logging loki_push_api provider
prometheus prometheus prometheus-k8s 186 1/1 receive-remote-write prometheus_remote_write provider
To connect Grafana WEB interface, follow the COS section “Browse dashboards”:
juju run grafana/leader get-admin-password --model <k8s_cos_controller>:<cos_model_name>
