Problem/Motivation

MySQL has released a new version of its database. It is version 8.4 and it has been promoted to a LTS version. MySQL has currently 2 LTS versions. The other one is 8.0. That version will be end of life in April 2026. See: https://en.wikipedia.org/wiki/MySQL
Drupal 12 will have to set the minimum required version for MySQL to at least 8.4. We shall need to do so, because Drupal 12 will be released after MySQL 8.0 will go EOL.

Also Mysql 9.0 is out

Steps to reproduce

Proposed resolution

Add daily testing with new LTS and decide when to set as default in follow-up

Adopt new Vector data-type as it was fixed in upcoming PHP 8.3.11/8.2.23/8.4.0

Remaining tasks

User interface changes

API changes

Data model changes

Release notes snippet

Issue fork drupal-3458878

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:

About issue forks

Comments

andypost created an issue. See original summary.

andypost opened merge request !8652

andypost’s picture

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

Last commit should be removed as production images will be rolled

andypost opened merge request !8653

andypost’s picture

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

Second MR probably preferable

smustgrave’s picture

smustgrave commented

Not sure I follow which MR should be reviewed?

andypost’s picture

andypost
he/him
Primary language Russian
commented

Both but second has less changes

smustgrave’s picture

smustgrave commented
Status: Needs review » Needs work

So in MR 8652 this seems to be consistently failing https://git.drupalcode.org/issue/drupal-3458878/-/pipelines/215144

MaxWhitehead made their first commit to this issue’s fork.

MaxWhitehead opened merge request !9106

andypost’s picture

andypost
he/him
Primary language Russian
commented

Looks like DB container failed https://git.drupalcode.org/issue/drupal-3458878/-/jobs/2361081

MaxWhitehead closed merge request !9106

andypost’s picture

andypost
he/him
Primary language Russian
commented

Meantime I published MySQL 9.0.1 image https://dev.mysql.com/doc/relnotes/mysql/9.0/en/

andypost’s picture

andypost
he/him
Primary language Russian
commented

Rebased and added 9.0

andypost’s picture

andypost
he/him
Primary language Russian
commented
Status: Needs work » Needs review
Related issues: +#3466119: mysql8 db images: Test `mysqladmin ping` when waiting for mysqld startup

Looks related issue solved problem with random failures so I think it ready for review

andypost’s picture

andypost
he/him
Primary language Russian
commented
Title: Add core testing with Mysql 8.4 LTS » Add core testing with Mysql 8.4 LTS and 9.0
Issue summary: View changes
andypost’s picture

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

Next releases of PHP will support new Vector data-type for Mysql 9.0 ref https://github.com/php/php-src/issues/15432

PS: will be released in 8.3.11/8.2.23/8.4.0beta4+

andypost’s picture

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

Added link to https://dev.mysql.com/doc/refman/9.0/en/vector.html

smustgrave’s picture

smustgrave commented
Status: Needs review » Reviewed & tested by the community

Seems to be passing so don't see an issue to add.

  • catch committed 9e91e06c on 11.x 
    Issue #3458878 by andypost, MaxWhitehead: Add core testing with Mysql 8....
catch’s picture

catch
he/him
Primary language English
commented
Version: 11.x-dev » 10.4.x-dev
Status: Reviewed & tested by the community » Patch (to be ported)

Committed/pushed to 11.x, thanks!

Not sure how much we'd want to backport this to 10.4 but moving to 'to be ported' for discussion. MR doesn't apply cleanly so would need a real backport.

andypost closed merge request !8652

andypost closed merge request !8653

andypost opened merge request !9375

andypost’s picture

andypost
he/him
Primary language Russian
commented
Status: Patch (to be ported) » Needs review

Backported, thank you!

nit: I'm using 8.3-ubuntu for new jobs, guess no reason to use 8.1

smustgrave’s picture

smustgrave commented
Status: Needs review » Reviewed & tested by the community

10.4 pipeline looks green.

andypost’s picture

andypost
he/him
Primary language Russian
commented

Looking at tests log which is full of warnings (as they enabled here for debugging purposes)

[service:drupalci/mysql-8-database] 2024-08-29T13:00:47.302353023Z 2024-08-29T13:00:47.302203Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity.
[service:drupalci/mysql-8-database] 2024-08-29T13:00:48.783864493Z 2024-08-29T13:00:48.783716Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity.
[service:drupalci/mysql-8-database] 2024-08-29T13:00:51.099659581Z 2024-08-29T13:00:51.099573Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity.

...
[service:drupalci/mysql-8.4-database] 2024-08-29T13:02:19.154554084Z 2024-08-29T13:02:19.154369Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity.
[service:drupalci/mysql-8.4-database] 2024-08-29T13:02:19.936404754Z 2024-08-29T13:02:19.936218Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity.
[service:drupalci/mysql-8.4-database] 2024-08-29T13:02:23.006410242Z 2024-08-29T13:02:23.006223Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity.
[service:drupalci/mysql-8.4-database] 2024-08-29T13:02:23.595133871Z 2024-08-29T13:02:23.594927Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity.

...
Drupal\FunctionalTests\Entity\RevisionRevertFormTest           5 passes                                      
[service:drupalci/mysql-9-database] 2024-08-29T13:05:06.662786573Z 2024-08-29T13:05:06.662624Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity.
[service:drupalci/mysql-9-database] 2024-08-29T13:05:08.670726447Z 2024-08-29T13:05:08.670592Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity.
Drupal\FunctionalTests\Update\UpdatePathTestBaseTest           6 passes

Probably we need to tune images a bit

  • longwave committed 7c3cdb72 on 10.4.x 
    Issue #3458878 by andypost, MaxWhitehead: Add core testing with Mysql 8....
longwave’s picture

longwave
he/him
Primary language English
Location UK
commented
Status: Reviewed & tested by the community » Fixed

I think this is worth backporting just to ensure that 10.x stays compatible, as we still have a couple of years of support and people might run on newer MySQL while remaining on an older Drupal install.

Committed 7c3cdb7 and pushed to 10.4.x. Thanks!

andypost closed merge request !9375

Status: Fixed » Closed (fixed)

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