This improves the messaging surrounding the
deprecation of this charm.
Fix links.
The removed upstream links will be placed in the
linked CDG resource (on upgrading to non-focal
series).
Change-Id: I6c00fa9f452583cdf5072938e57b4cf611a3115f
Add a NRPE check to monitor the number of threads connected
to the MySQL database, in proportion to the maximum number of connections.
For this check, a nagios user will be created. This user does not have any
permissions set, does not have access to any database and can only connect
from localhost.
Warning and Critical thresholds (in percentage) can be configured.
Add an action to reset nagios's password. This action could only be run
on the leader unit.
Closes-Bug: #1816759
Change-Id: Id35b0331322c2744a9f839b3eb153eed1bc53aac
Also move the section up the page to reflect
its importance.
Depends-on: Ic7ad2622b6aa3c8ae8821a8f5f531534d8cfb3d6
Change-Id: I31ba8a968cd7f42d639e1843e66714dbd0a067aa
This is a move towards a more standardised README.
The Series Upgrade section should probably eventually
be moved to the series-upgrade appendix in the CDG.
Change-Id: I9ca724dc9b3db02dc32f6462f5e24cc453d0dd3e
This patch ensures that the PROCESS permission is added to the sstuser
user during a series upgrade from xenial to bionic. Also patches the
README to correct some of the commands in terms of order of parameters.
Change-Id: I8ddc21e3914e3da0f64ffcedef7a6a4bb18ba4cb
Closes-Bug: #1838044
This patchset implements new relations: "master" and "slave" based
on a common "mysql-async-replication" interface which are used for
the purpose on enabling MySQL asynchronous replication between
multiple Percona XtraDB Clusters.
Change-Id: I94710bff17091516875c81ca769d8078ef5efd10
Closes-Bug: 1776171
In the past, its mandatory to provide the sst and root password
configuration options for clustered deployments to ensure consistent
use of passwords across the cluster from install onwards.
Rework password management and install process to seed passwords
from the lead unit if not supplied via configuration options.
Following units will defer installation until the leader has
stored this information in leader storage for retrieval by
followers.
Closes-Bug: 1454317
Change-Id: I5ab70cae78ed35322bf60048af841de071a69704
Include details of cluster and shared-db endpoint binding
options for Juju 2.0 network space support.
The 'access' extra-binding should be replaced with the actual
shared-db endpoint binding, so skipping that from the docs
for now.
Change-Id: Ied2628491391fd05126007458dc7acaa268276a8
Closes-Bug: 1654264
Percona cluster takes some time to fully cluster. The charm was
previously running shared-db-relation-changed hooks whenever they
were queued even if the cluster was not yet complete. This may lead
to split brain scenarios or unexpected behavior.
This change confirms the entire cluster is ready before running
client shared-db-relation-changed hooks.
min-cluster-size can now be used to attempt to guarantee the cluster
is ready with the expected number of nodes. If min-cluster-size is
not set the charm will still determine based on the information
available if all the cluster nodes are ready. Single node
deployments are still possible.
Partial-Bug: #1655417
Change-Id: Ie9deb266a9682e86f3a9cbc1103b655b13a8295e
The 5.6 version of mysql defauls to performance_schema=on at server
startup. This allocates all the memory that would be required to
handle max-connections plus several other memory settings.
We occasionally saw connection exhaustion in HA clouds with
max-connections near 2000. The common practice became to set
max-connections unrealistically high near 10k or 20k. In the move to
5.6 on Xenial this became a problem as the memory requirements for
values that high are unrealistic.
This change adds performance schema as a configuration option and
defaults to off giving 5.5 like behavior. It also considerably
updates documentation and highlights the need to carefully consider
memory related configuration settings for production environments.
Make the amulet test python2 and python3 capable.
Change-Id: Id01095ac2f73fa041b25b2602496a4c04a13e3ef
Partial-Bug: #1654086
Closes-Bug: #1600001
Implement DNS high availability. Pass the correct information to
hacluster to register a DNS entry with MAAS 2.0 or greater rather
than using a virtual IP.
Charm-helpers sync to bring in DNS HA helpers
Change-Id: I2d9e2b92b0ebf33dc2f62327df6edbfd1e81dcca
Juju 2.0 provides support for network spaces, allowing
charm authors to support direct binding of relations and
extra-bindings onto underlying network spaces.
Resync charm-helpers to pickup support for new charm hook
tools.
Update get_db_host function to attempt to use the network
space support with appropriate fallback if on an older
Juju version.
Add some unit tests to cover the new support.
Change-Id: I28ae4beab5329eb69baddce5715b7f049af65b06