Problem/Motivation

The database images are not updated last 2 years and Oracle no longer using Debian.
Build of mysql-5.7 and mysql-8.0 images is broken (no apt-get)
The base mysql:8 now containes Mysql 8.1

Oracle no longer shipping Debian-based Mysql 5.7 image https://github.com/docker-library/mysql/issues/988

But mysql:8.0-debian still maintained

Proposed resolution

- fix base image for 8.0 and optimize layers (testing will be done via :dev image) https://hub.docker.com/r/drupalci/mysql-8/tags
- use yum instead of apt-get for mysql-5.7 https://hub.docker.com/r/drupalci/mysql-5.7/tags

Remaining tasks

User interface changes

API changes

Data model changes

Issue fork drupalci_environments-3388135

Command icon Show commands

Start within a Git clone of the project using the version control instructions.

Or, if you do not have SSH keys set up on git.drupalcode.org:

  • 3388135-mysql57 Comparecompare
About issue forks

Comments

andypost created an issue. See original summary.

  • andypost committed 086ca054 on dev 
    Fix base image for mysql-8 #3388135

- removed extra layer saved 20MB of...
andypost’s picture

andypost
he/him
Primary language Russian
commented
Status: Active » Needs work

Needs work for 5.7

andypost’s picture

andypost
he/him
Primary language Russian
commented
Issue summary: View changes

  • andypost committed 41a47755 on dev 
    Fix base image for mysql-8 #3388135

- removed extra layer saved 20MB of...

  • andypost committed 25f2cae0 on dev 
    Fix base image for mysql-5.7 #3388135

- transition to yum
- mysqld_safe...
andypost’s picture

andypost
he/him
Primary language Russian
commented
Assigned: andypost » Unassigned
Issue summary: View changes

pushed to dev tags

new version https://git.drupalcode.org/issue/drupal-3386474/-/pipelines/21352

$ mysql --version
mysql  Ver 14.14 Distrib 5.7.43, for Linux (x86_64) using  EditLine wrapper

old (production)
mysql Ver 14.14 Distrib 5.7.22, for Linux (x86_64) using EditLine wrapper

Mysql 8.0 also upgraded https://git.drupalcode.org/issue/drupal-3386474/-/pipelines/21350

$ docker run --rm drupalci/mysql-8:dev mysql --version
mysql: [Warning] World-writable config file '/etc/mysql/conf.d/drupalci.cnf' is ignored.
mysql  Ver 8.0.34 for Linux on x86_64 (MySQL Community Server - GPL)

production is
mysql Ver 8.0.28 for Linux on x86_64 (MySQL Community Server - GPL)

andypost’s picture

andypost
he/him
Primary language Russian
commented
Issue summary: View changes
Status: Needs work » Needs review

dev images pushed and passed tests

  • hestenet committed 245ea26d on production 
    Fix base image for mysql-5.7 / mysql-8 #3388135
hestenet’s picture

hestenet
He/Him
Location Portland, OR 🇺🇸
commented

Okay - let's give this a try...

... I have cherry picked these changes to this MR #24:
https://git.drupalcode.org/project/drupalci_environments/-/merge_request...

... And merged.

Leaving this issue as Needs review until we confirm test runs for each.

hestenet’s picture

hestenet
He/Him
Location Portland, OR 🇺🇸
commented

Cherry pick merge request for MySQL 8 - #25:
https://git.drupalcode.org/project/drupalci_environments/-/merge_request...

hestenet’s picture

hestenet
He/Him
Location Portland, OR 🇺🇸
commented

Queued retests:

If those complete successfully we can mark this issue fixed.

andypost’s picture

andypost
he/him
Primary language Russian
commented
Status: Needs review » Fixed

Thank you!

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.