[wp-trac] [WordPress Trac] #59779: Consider testing against MySQL "Innovation Releases"

[WordPress Trac]

#59779: Consider testing against MySQL "Innovation Releases"
------------------------------+-----------------------------
 Reporter:  desrosj           |      Owner:  (none)
     Type:  enhancement       |     Status:  new
 Priority:  normal            |  Milestone:  Awaiting Review
Component:  Build/Test Tools  |    Version:
 Severity:  normal            |   Keywords:
  Focuses:                    |
------------------------------+-----------------------------
 The [https://dev.mysql.com/blog-archive/introducing-mysql-innovation-and-
 long-term-support-lts-versions/ MySQL project has announced a new version
 release cadence] that it has begun following with version 8.1 (eleased on
 July 18, 2023), and has since been superseded with 8.2 (released on
 October 25, 2023).

 I recommend reading their full post, but here are some important details
 I've extracted:

 > Support for Innovation releases is limited until the next minor release
 (Innovation or LTS). The current cadence goal is to have an Innovation
 release every quarter, incrementing the minor version number (eg. 8.2,
 8.3, etc.). Patch releases within Innovation releases are possible but are
 less likely to happen.

 > About every 2 years a new Long Term Support version will be released
 (blue). An exception is the 8.x LTS release which will happen well before
 EOL of 8.0

 > Innovation releases will also be Generally Available and are recommended
 to be used in production environments. Bugfixes and Security patches will
 generally be included in the next Innovation or LTS release and not as
 part of a patch release within that Innovation release. When using
 Innovation releases, it is necessary to upgrade to the latest innovation
 releases regularly to keep up with the latest bugfixes and security
 patches.

 Because innovation versions are considered production safe, we should
 consider testing against these new versions of MySQL as they are released.
 However, since innovation releases are replaced more frequently, it's not
 clear how long we should consider testing against them.

 For example, the current Innovation release is 8.2, which will be replaced
 by 8.3 in (approximately) January 2024. Because of backwards compatibility
 concerns, should 8.1 and 8.2 continue to be tested? Or is testing against
 the latest innovation release, and any supported LTS versions enough?

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/59779>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform