Whats up with Mysql


#1

I think we asked this before, and I think for a while it got fixed, but maybe it didn’t.

The MySQL charm, which my gut tells me probably gets smoke tested a lot by people wondering how Juju works, tried to launch a Zesty instance by default, but there’s no Zesty images on AWS or something cause it never starts.

Can someone(Marco?) either switch the default to Xenial or better yet Bionic? Its a bit sad when MySQL fails when you try and deploy it when infact the charm is fine.


#2

This happened to me to a while ago. I don’t know where Zesty is coming from.


#3

My guess is the charm declares “series: zesty, xenial, trusty”
which means it defaults to Zesty unless otherwise specified with --series.

I would agree that the default should certainly be an LTS, either Xenial or Bionic at this point.

I don’t think the mysql charm is particularly well maintained, as the most active one is probably percona-cluster used by the openstack charms. Its owned by “mysql-charmers” which is a aggregated group of Openstack charmers and Canonical Charm Leads, so there should be a few people with rights to update the series: and then publish a new version.

@james-page @beisner ^^


#4

It shows zesty as a series now. It didn’t before.


#5

To confirm, the mysql charm repo [1] appears to be ahead of the charm store charm [2].

[1] https://github.com/juju-solutions/charm-mysql/blob/master/metadata.yaml
[2] https://api.jujucharms.com/charmstore/v5/mysql/archive/metadata.yaml

From an OpenStack perspective, we use the Percona Cluster charm (not the MySQL charm).

I’ll check into the ETA of getting that updated in the charm store.


#6

FYI, the updated mysql charm is currently in ‘candidate’:


#7

Related to this, I filed https://bugs.launchpad.net/juju/+bug/1807241 against juju for consideration


#8

@rick_h, regarding the charm store community engagement/curation approach you mentioned in the bug above, I already have https://github.com/CanonicalLtd/jujucharms.com/issues/473. Hope to see some more action towards curation tools to help folks clean up things and make informed decisions in the store.