Services not running that should be: mysql

[james beedy]

percona.yaml -> http://paste.ubuntu.com/16247696/
juju --version -> 2.0-beta7-xenial-amd64
maas -> 2.0.0~beta4+bzr4985-0ubuntu1~xenial1

after `juju deploy percona.yaml` settles, my juju env shows -> http://paste.ubuntu.com/16247657/

`sudo crm status` from one of the blocked containers -> http/paste.ubuntu.com/16247671/

`juju ssh mysql/2 cat /var/log/syslog` -> http://paste.ubuntu.com/16247743/

`juju ssh mysql/2 cat /var/log/juju/unit-mysql-2.log` -> http://paste.ubuntu.com/16247754/

`juju ssh mysql/2 cat /var/log/juju/unit-mysql-hacluster-2.log` -> http://paste.ubuntu.com/16247768/

[James Page (james-page)]

Something is causing mysql to fail to start; this might be related to memory consumption - although you are constraining the dataset-size of each instance to 512M, using 25k max-connections will increased the memory footprint of each instance on startup hugely in mysql 5.6 (which allocates memory for performance schema on startup)

[James Page (james-page)]

Example with 25k configured:

16477 mysql 20 0 14.189g 5.413g 10160 S 0.0 34.9 0:02.65 mysqld

You can see this consumes nearly 4.4G of RAM over the default of 151:

17390 mysql 20 0 9.823g 1.051g 11424 S 0.0 6.8 0:00.75 mysqld

[James Page (james-page)]

Marking 'Incomplete' for now; there is a bug re disabling the performance schema, but I think you're just blowing the memory consumption on the server.

[Launchpad Janitor (janitor)]

[Expired for percona-cluster (Juju Charms Collection) because there has been no activity for 60 days.]