James Page Percona Cluster Bug1583898

Learn about configurations >

• access-network | string

  The IP address and netmask of the 'access' network (e.g., 192.168.0.0/24) . This network will be used for access to database services.

• dataset-size | string

  (DEPRECATED - use innodb-buffer-pool-size) How much data should be kept in memory in the DB. This will be used to tune settings in the database server appropriately. Supported suffixes include K/M/G/T. If suffixed with %, one will get that percentage of RAM allocated to the dataset.

• ha-bindiface | string

  Default: eth0

  Default network interface on which HA cluster will bind to communication with the other members of the HA Cluster.

• ha-mcastport | int

  Default: 5490

  Default multicast port number that will be used to communicate between HA Cluster nodes.

• harden | string

  Apply system hardening. Supports a space-delimited list of modules to run. Supported modules currently include os, ssh, apache and mysql.

• innodb-buffer-pool-size | string

  By default this value will be set according to 50% of system total memory 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-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

• key | string

  Key ID to import to the apt keyring to support use with arbitary source configuration from outside of Launchpad archives or PPA's.

• lp1366997-workaround | boolean

  Adds two config options (wsrep_drupal_282555_workaround and wsrep_retry_autocommit) as a workaround for Percona Primary Key bug (see LP 1366997).

• max-connections | int

  Default: -1

  Maximum connections to allow. A value of -1 means use the server's compiled-in default.

• min-cluster-size | int

  Minimum number of units expected to exist before charm will attempt to bootstrap percona cluster. If no value is provided this setting is ignored.

• nagios_context | string

  Default: juju

  Used by the nrpe-external-master subordinate charm. A string that will be prepended to instance name to set the host name in nagios. So for instance the hostname would be something like: . juju-myservice-0 . If you're running multiple environments with the same services in them this allows you to differentiate between them.

• nagios_servicegroups | string

  A comma-separated list of nagios servicegroups. If left empty, the nagios_context will be used as the servicegroup.

• 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.

• root-password | string

  Root password for MySQL access; must be configured pre-deployment for Active-Active clusters.

• source | string

  Package install location for Percona XtraDB Cluster (defaults to distro for >= 14.04)

• sst-method | string

  Default: xtrabackup-v2

  Percona method for taking the State Snapshot Transfer (SST), can be: 'rsync', 'xtrabackup', 'xtrabackup-v2', 'mysqldump', 'skip' - see https://www.percona.com/doc/percona-xtradb-cluster/5.5/wsrep-system-index.html#wsrep_sst_method

• sst-password | string

  Re-sync account password for new cluster nodes; must be configured pre-deployment for Active-Active clusters.

• table-open-cache | int

  Default: 2048

  Sets table_open_cache (formerly known as table_cache) to mysql.

• vip | string

  Virtual IP to use to front Percona XtraDB Cluster in active/active HA configuration

• vip_cidr | int

  Default: 24

  Netmask that will be used for the Virtual IP.

• vip_iface | string

  Default: eth0

  Network interface on which to place the Virtual IP.

• wait-timeout | int

  Default: -1

  The number of seconds the server waits for activity on a noninteractive connection before closing it. -1 means use the server's compiled in default.