search

sclorg / mysql-container

MySQL container images based on Red Hat Software Collections and intended for OpenShift and general usage. Users can choose between Red Hat Enterprise Linux, Fedora, and CentOS based images.
http://softwarecollections.org
Apache License 2.0
128 stars 201 forks source link

Is this image production ready with persistent storage? #267

Closed nathanawmk closed 4 months ago

nathanawmk commented 4 years ago

Is this image production ready with persistent storage?

phracek commented 4 years ago

Hi @nathanawmk

I am solving problems with the Persistant Storage here https://github.com/sclorg/mysql-container/pull/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?

oseiasgomes commented 4 years ago

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.

phracek commented 4 years ago

@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

phracek commented 4 months ago

@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.