Is this image production ready with persistent storage? about mysql-container HOT 4 CLOSED

Hi @nathanawmk

I am solving problems with the Persistant Storage here #269. Related Bugzilla report https://bugzilla.redhat.com/show_bug.cgi?id=1653215.

But what do you mean with your question?
Do you have any issues with using persistent storage?

from mysql-container.

This versions has error. When I Try create on Deployment with version 8.0, I receive this message:

=> sourcing 25-validate-replication-variables.sh ...

  | => sourcing 30-base-config.sh ...
  | ---> 15:19:38 Processing basic MySQL configuration files ...
  | => sourcing 60-replication-config.sh ...
  | => sourcing 70-s2i-config.sh ...
  | ---> 15:19:38 Processing additional arbitrary MySQL configuration provided by s2i ...
  | => sourcing 40-paas.cnf ...
  | => sourcing 50-my-tuning.cnf ...
  | ---> 15:19:38 Initializing database ...
  | ---> 15:19:38 Running /opt/rh/rh-mysql80/root/usr/libexec/mysqld --initialize --datadir=/var/lib/mysql/data
  | ---> 15:19:38 Starting MySQL server with disabled networking ...
  | ---> 15:19:38 Waiting for MySQL to start ...
  | 2019-10-05T15:19:38.660900Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
  | 2019-10-05T15:19:38.667093Z 0 [System] [MY-010116] [Server] /opt/rh/rh-mysql80/root/usr/libexec/mysqld (mysqld 8.0.13) starting as process 39
  | 2019-10-05T15:19:38.680756Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
  | 2019-10-05T15:19:38.680968Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
  | 2019-10-05T15:19:38.681009Z 0 [ERROR] [MY-010119] [Server] Aborting
  | 2019-10-05T15:19:38.683791Z 0 [System] [MY-010910] [Server] /opt/rh/rh-mysql80/root/usr/libexec/mysqld: Shutdown complete (mysqld 8.0.13) Source distribution.

from mysql-container.

@oseiasgomes How do you execute mysql S2I image. In Openshift or via docker/podman?
From the log I can see error:

 | 2019-10-05T15:19:38.680756Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.

Do you mount the proper data directory?

https://github.com/sclorg/mysql-container/tree/master/8.0#usage

from mysql-container.

@oseiasgomes Yes, this image is already production ready in OpenShift environment.

We have a lot of tests in OpenShift 4 environment, including persistent storage template.

I guess, this is not valid at all and closing this issue.

Feel free to re-open it and even file a pull request.

from mysql-container.