mysql-shell in ubuntu/mysql image

[Jose C. Massón]

In the Operator Engineering Team we are writing a charm[1] to deploy a MySQL InnoDB Cluster in K8s using the `ubuntu/mysql` docker image you upload to docker hub.

In order to setup the cluster we need a package called mysql-shell[2] inside the image.

Would that be possible?

[1] https://github.com/canonical/mysql-operator/tree/develop
[2] https://dev.mysql.com/downloads/shell/

[Jose C. Massón (jose-masson)]

Attached you'll find the modified Dokerfile I am using to test my development.
It needs refactor, but "works"

[Jose C. Massón (jose-masson)]

To install mysql-shell in the image I used this:

https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/#repo-qg-apt-repo-manual-setup

[Robie Basak (racb)]

We haven't packaged mysql-shell as a deb in Ubuntu due to questions about its security supportability. Similar policy questions would arise were we to include mysql-shell in our OCI images.

[Jose C. Massón (jose-masson)]

Hello Robie, is completely understandable your point.

Do you think that would be possible not modifying this image but creating a new one (for instance: ubuntu/mysql-mysql-shell) with this package so we can use it in our charm to deploy a MySQL InnoDB cluster?

[Richard Harding (rharding)]

@Jose, the issue is that there is no package to stick into the image currently. Our images are built from Ubuntu sources of packaging and since Ubuntu has no package for this, we'd first need to overcome that hurdle before it could be delivered as part of the image. Since these images are intended to be supported by the Canonical security and server teams, we'll have to go through that process of audit and review to get it into Ubuntu first.

[Cristovao Cordeiro (cjdc)]

Assigning it to @paulomachado, just in case the ticket is still relevant. If not, please close it