---
title: Charmhub | Deploy Openstack Telemetry using Charmhub - The Open Operator Collection
description: Deploy the latest version of Openstack Telemetry on any cloud.
url: https://charmhub.io/openstack-telemetry/configurations/mysql-router
---

##### We've discontinued the registration of new Bundles

New Bundle registrations are no longer accepted. Existing bundles remain functional. We recommend using the Juju Terraform Provider for new deployments.

[Learn more](https://discourse.charmhub.io/t/discontinuing-new-charmhub-bundle-registrations/15344)

# Openstack Telemetry

[OpenStack Charmers](https://charmhub.io/publisher/openstack-charmers "View all packages from OpenStack Charmers")
| bundle

* [OpenStack Charmers](https://charmhub.io/publisher/openstack-charmers "View all packages from OpenStack Charmers")
  | bundle

Platform:

stable 65

```
juju deploy openstack-telemetry
```

[Learn to deploy on juju >](https://juju.is/docs/juju/manage-applications)

* [Aodh](https://charmhub.io/openstack-telemetry/configurations/aodh)
* [Mysql Router](https://charmhub.io/openstack-telemetry/configurations/mysql-router)
* [Ceilometer](https://charmhub.io/openstack-telemetry/configurations/ceilometer)
* [Ceilometer Agent](https://charmhub.io/openstack-telemetry/configurations/ceilometer-agent)
* [Ceph Mon](https://charmhub.io/openstack-telemetry/configurations/ceph-mon)
* [Ceph Osd](https://charmhub.io/openstack-telemetry/configurations/ceph-osd)
* [Ceph Radosgw](https://charmhub.io/openstack-telemetry/configurations/ceph-radosgw)
* [Cinder](https://charmhub.io/openstack-telemetry/configurations/cinder)
* [Cinder Ceph](https://charmhub.io/openstack-telemetry/configurations/cinder-ceph)
* [Mysql Router](https://charmhub.io/openstack-telemetry/configurations/mysql-router)
* [Mysql Router](https://charmhub.io/openstack-telemetry/configurations/mysql-router)
* [Glance](https://charmhub.io/openstack-telemetry/configurations/glance)
* [Mysql Router](https://charmhub.io/openstack-telemetry/configurations/mysql-router)
* [Gnocchi](https://charmhub.io/openstack-telemetry/configurations/gnocchi)
* [Mysql Router](https://charmhub.io/openstack-telemetry/configurations/mysql-router)
* [Keystone](https://charmhub.io/openstack-telemetry/configurations/keystone)
* [Mysql Router](https://charmhub.io/openstack-telemetry/configurations/mysql-router)
* [Memcached](https://charmhub.io/openstack-telemetry/configurations/memcached)
* [Mysql Innodb Cluster](https://charmhub.io/openstack-telemetry/configurations/mysql-innodb-cluster)
* [Neutron Api](https://charmhub.io/openstack-telemetry/configurations/neutron-api)
* [Neutron Api Plugin Ovn](https://charmhub.io/openstack-telemetry/configurations/neutron-api-plugin-ovn)
* [Mysql Router](https://charmhub.io/openstack-telemetry/configurations/mysql-router)
* [Nova Cloud Controller](https://charmhub.io/openstack-telemetry/configurations/nova-cloud-controller)
* [Nova Compute](https://charmhub.io/openstack-telemetry/configurations/nova-compute)
* [Mysql Router](https://charmhub.io/openstack-telemetry/configurations/mysql-router)
* [Ntp](https://charmhub.io/openstack-telemetry/configurations/ntp)
* [Openstack Dashboard](https://charmhub.io/openstack-telemetry/configurations/openstack-dashboard)
* [Ovn Central](https://charmhub.io/openstack-telemetry/configurations/ovn-central)
* [Ovn Chassis](https://charmhub.io/openstack-telemetry/configurations/ovn-chassis)
* [Placement](https://charmhub.io/openstack-telemetry/configurations/placement)
* [Mysql Router](https://charmhub.io/openstack-telemetry/configurations/mysql-router)
* [Rabbitmq Server](https://charmhub.io/openstack-telemetry/configurations/rabbitmq-server)
* [Vault](https://charmhub.io/openstack-telemetry/configurations/vault)
* [Mysql Router](https://charmhub.io/openstack-telemetry/configurations/mysql-router)

[Learn about configurations >](https://juju.is/docs/juju/configuration#heading--application-configuration)

* auth\_cache\_refresh\_interval | int

  Default: 2

  Time (in seconds) between the auth-cache refresh attempts. Defaults to
  2. The value must be smaller than auth\_cache\_ttl and ttl else Router
  won't start.
* auth\_cache\_ttl | int

  Default: -1

  Time (in seconds) until the cache becomes invalid if not refreshed.
  Defaults to -1 (infinite). The value must be larger than
  auth\_cache\_refresh\_interval else Router won't start.
* base-port | int

  Default: 3306

  Base port number for RW interface. RO, xRW and xRO will
  increment from base\_port.
* debug | boolean

  Enable debug logging
* max\_connections | int

  Default: 1024

  If mysql router version < 8.0.27, this option will be set as max\_connections
  in the config. Else will be max\_total\_connections.
  The max\_connections is maximum number of connections to allow in direction to each MySQL
  routing sessions, with one for the RW unit and another one for the RO
  units of the MySQL innodb cluster. A valid range is between 1 and 65535.
  The max\_total\_connections is the maximum number of client connections handled by Router, to help
  prevent running out of the file descriptors. A valid
  range is between 1 and 9223372036854775807.
* source | string

  Default: distro

  Repository from which to install. May be one of the following:
  distro (default), ppa:somecustom/ppa, a deb url sources entry,
  or a supported Ubuntu Cloud Archive e.g.
  .
  cloud:<series>-<openstack-release>
  cloud:<series>-<openstack-release>/updates
  cloud:<series>-<openstack-release>/staging
  cloud:<series>-<openstack-release>/proposed
  .
  See https://wiki.ubuntu.com/OpenStack/CloudArchive for info on which
  cloud archives are available and supported.
* ssl\_ca | string

  TLS CA to use to communicate with other components in a deployment.
  .
  \_\_NOTE\_\_: This configuration option will take precedence over any
  certificates received over the ``certificates`` relation.
* ssl\_cert | string

  TLS certificate to install and use for any listening services.
  .
  \_\_NOTE\_\_: This configuration option will take precedence over any
  certificates received over the ``certificates`` relation.
* ssl\_key | string

  TLS key to use with certificate specified as ``ssl\_cert``.
  .
  \_\_NOTE\_\_: This configuration option will take precedence over any
  certificates received over the ``certificates`` relation.
* ttl | float

  Default: 0.5

  Time to live (in seconds) of information in the metadata cache.
  Accepts either an integer or a floating point value. The granularity is
  limited to milliseconds, where 0.001 equates to one millisecond.
  Precision is truncated to the supported range; for example ttl=0.0119
  is treated as 11 milliseconds. The value 0 means that the metadata
  cache module queries the metadata continuously in a tight loop.
* use-syslog | boolean

  Setting this to True will allow supporting services to log to syslog.
* use\_gr\_notifications | boolean

  Enables Group Replication notifications. When enabled, the mysql router is
  asynchronously notified about most cluster changes. This allows for a higher ttl
  value, as periodic metadata refreshes serve as an additional safeguard rather
  than the primary method of keeping cluster state information up to date.
  When disabled, a low ttl value (such as 0.5s, the default) is recommended
  to reduce the cache misalignment window between routers and mysql clusters.
