You have enabled the binary log, but you haven't provided the mandatory server-id.

[Jason Hobbs]

mysql is failing to start:

2018-05-22 20:58:26 DEBUG leader-settings-changed Exception: Failed to start mysql (max retries reached)

in syslog:
May 22 20:58:34 juju-303c23-1-lxd-7 mysql-systemd-start[22681]: 2018-05-22T20:58:34.948980Z 0 [ERROR] You have enabled the binary log, but you haven't provided the mandatory server-id. Please refer to the proper server start-up parameters documentation

http://paste.ubuntu.com/p/DHqQF5wd5v/

This dosen't seem racy - we hit this everytime in our testing.

[Corey Bryant (corey.bryant)]

This error occurs when setting enable-binlogs=True with PXC 5.7, which is version that is available in the bionic archive.

[Corey Bryant (corey.bryant)]

It looks like server-id just needs to be set correctly when binlog is enabled in the config template. Will be testing this shortly.

[Corey Bryant (corey.bryant)]

Seems to be limited to the charm nonetheless.

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/571264
Committed: https://git.openstack.org/cgit/openstack/charm-percona-cluster/commit/?id=78d1df2d50d94bae829c33767bc0e99a7e2afcf1
Submitter: Zuul
Branch: master

commit 78d1df2d50d94bae829c33767bc0e99a7e2afcf1
Author: David Ames <email address hidden>
Date: Wed May 30 10:35:34 2018 -0700

    Set server_id when using binlogs

    Percona-cluster was failing to start when enable-binlogs was set to
    True due to missing server_id in the configuration.

    Set the server_id to a unique, non-zero, positive number from 1 to
    2**32 - 1.

    Closes-Bug: #1772947
    Change-Id: Id7da6dd8f27e364e0d5244e4ec33ae4645e4ef96

[Jason Hobbs (jason-hobbs)]

After testing with the new version of the charm, we're not seeing this anymore. Looks fixed to me.