In a standard docker MySQL image there are options to get app user and database automatically when creating a MySQL instance for the first time.
For example:
https://hub.docker.com/_/mysql
MYSQL_DATABASE
MYSQL_USER
MYSQL_PASSWORD
Init script creates database for app without manual actions required.
If I’m right, when creating a new PXC cluster all yamls can be applied in one go, if app user/database-name/password would be in deploy/secrets.yaml and these details picked up to:
CREATE DATABASE app;
CREATE USER …
GRANT ALL ON …
FLUSH PRIVILEGES;
… and app should be able to start using a new DB without manual steps
(just interested to think on what is missing to get a cluster in one button click)
Obviously, this can be easily done in an additional container, if this automation is not offered for now.