--- 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-innodb-cluster --- ##### 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) * auto-rejoin-tries | string Default: 1000 The number of tries instances make to rejoin the cluster after being expelled. * binlogs-expire-days | int Default: 10 Sets the expire\_logs\_days mysql configuration option, which will make mysql server automatically remove logs older than configured number of days. * binlogs-max-size | string Default: 100M Sets the max\_binlog\_size mysql configuration option, which will limit the size of the binary log files. The server will automatically rotate binlogs after they grow to be bigger than this value. Keep in mind that transactions are never split between binary logs, so therefore binary logs might get larger than configured value. * binlogs-path | string Default: /var/log/mysql/mysql-bin.log Location on the filesystem where binlogs are going to be placed. Default mimics what mysql-common package would do for mysql. Make sure you do not put binlogs inside mysql datadir (/var/lib/mysql/)! * cluster-name | string Default: jujuCluster Cluster name for the InnoDB cluster. Must be unique. * enable-binlogs | boolean Turns on MySQL binary logs. The placement of the logs is controlled with the binlogs\_path config option. * expel-timeout | int Default: 20 An integer value that specifies the period of time in seconds that cluster members should wait for a non-responding member before expelling it from the cluster. This value can be changed while Group Replication is running. Setting this value to N will mean that a member will be expelled after N + 5 seconds after the loss of connectivity. See the MySQL documentation related to the group\_replication\_member\_expel\_timeout option for more information. https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-expel.html https://dev.mysql.com/doc/refman/8.0/en/group-replication-options.html#sysvar\_group\_replication\_member\_expel\_timeout * group-replication-message-cache-size | string By default this value will be set as 1G. For nodes with strict memory requirements, this number can be chosen as a lower value. Supported suffixes include K/M/G/T. See the MySQL documentation for the allowed maximum and minimum values for this option for different versions and for more information. https://dev.mysql.com/doc/refman/8.0/en/group-replication-options.html#sysvar\_group\_replication\_message\_cache\_size * innodb-buffer-pool-size | string By default this value will be set according to 50% of system total memory or 512MB (whichever is lowest) but also can be set to any specific value for the system. Supported suffixes include K/M/G/T. If suffixed with %, one will get that percentage of system total memory allocated. * innodb-change-buffering | string Default: all Configure whether InnoDB performs change buffering, an optimization that delays write operations to secondary indexes so that the I/O operations can be performed sequentially. . Permitted values include . none Do not buffer any operations. inserts Buffer insert operations. deletes Buffer delete marking operations; strictly speaking, the writes that mark index records for later deletion during a purge operation. changes Buffer inserts and delete-marking operations. purges Buffer the physical deletion operations that happen in the background. all The default. Buffer inserts, delete-marking operations, and purges. . For more details https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar\_innodb\_change\_bufferring * innodb-file-per-table | boolean Default: True Turns on innodb\_file\_per\_table option, which will make MySQL put each InnoDB table into separate .idb file. Existing InnoDB tables will remain in ibdata1 file - full dump/import is needed to get rid of large ibdata1 file * innodb-io-capacity | int Default: 200 Configure the InnoDB IO capacity which sets an upper limit on I/O activity performed by InnoDB background tasks, such as flushing pages from the buffer pool and merging data from the change buffer. . This value typically defaults to 200 but can be increased on systems with fast bus-attached SSD based storage to help the server handle the background maintenance work associated with a high rate of row changes. . Alternatively it can be decreased to a minimum of 100 on systems with low speed 5400 or 7200 rpm spindles, to reduce the proportion of IO operations being used for background maintenance work. . For more details https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar\_innodb\_io\_capacity * max-connections | int Default: 600 Maximum connections to allow. A value of -1 means use the server's compiled-in default. This is not typically that useful so the charm will configure PXC with a default max-connections value of 600. Note: Connections take up memory resources. This value is a balance between connection exhaustion and memory exhaustion. . Consult a MySQL memory calculator like http://www.mysqlcalculator.com/ to understand memory resources consumed by connections. See also MySQL Performance Schema at https://dev.mysql.com/doc/refman/8.0/en/performance-schema.html. * os-db-router-hostname | string The hostname or address of the db-router endpoint for mysql-innodb-cluster * prefer-ipv6 | boolean If True enables IPv6 support. The charm will expect network interfaces to be configured with an IPv6 address. If set to False (default) IPv4 is expected. . NOTE: these charms do not currently support IPv6 privacy extension. In order for this charm to function correctly, the privacy extension must be disabled and a non-temporary address must be configured/available on your network interface. * prometheus-exporter-snap-channel | string Choose which channel to install for mysql prometheus exporter Supported values are: "stable", "candidate", "beta" and "edge" * snapd\_refresh | string How often snapd handles updates for installed snaps. The default (an empty string) is 4x per day. Set to "max" to check once per month based on the charm deployment date. You may also set a custom string as described in the 'refresh.timer' section here: https://forum.snapcraft.io/t/system-options/87 * 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:- cloud:-/updates cloud:-/staging cloud:-/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. * table-open-cache | int Default: 2048 Sets table\_open\_cache (formerly known as table\_cache) to mysql. * tuning-level | string Default: safest Valid values are 'safest', 'fast', and 'unsafe'. If set to 'safest', all settings are tuned to have maximum safety at the cost of performance. 'fast' will turn off most controls, but may lose data on crashes. 'unsafe' will turn off all protections but this may be OK in clustered deployments. * wait-timeout | int Default: 3600 The number of seconds the server waits for activity on a noninteractive connection before closing it. https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar\_wait\_timeout