F43 Change Proposal: Switch the distribution default version of MySQL from MySQL 8.0 to MySQL 8.4 (self-contained)

Wiki - https://fedoraproject.org/wiki/Changes/switch_distribution_default_MySQL_from_80_to_84
Discussion thread -
https://discussion.fedoraproject.org/t/f43-change-proposal-switch-the-distribution-default-version-of-mysql-from-mysql-8-0-to-mysql-8-4-self-contained/155256

This is a proposed Change for Fedora Linux.
This document represents a proposed Change. As part of the Changes
process, proposals are publicly announced in order to receive
community feedback. This proposal will only be implemented if approved
by the Fedora Engineering Steering Committee.

== Summary ==
MySQL is packages now use the versioned package layout.
Currently we have packages `mysql8.0` and `mysql8.4` which both
provides their respective versioned named sub-packages (e.g.
`mysql8.0-server` or `mysql8.4-errmsg` etc.)

A "distribution default" version is the one, that also provides the
unversioned names (e.g. `mysql-server` or `mysql-errmsg` etc.)

Currently the "distribution default" version of MySQL is 8.0. Let's
switch to 8.4.

== Owner ==
* Name: [[User:mschorm| Michal Schorm]]
* Email: mschorm@redhat.com



== Detailed Description ==

The technical implementation is by a On/OFF macro in the MySQL
packages SPECfiles.
There can't be two same "distribution default" packages at the same
time, since they would create conflicts. So the switch must be done
simultaneously.

There are two potential technical problems:

1) MySQL 8.4 no longer supports 32-bit builds.
So any packages depending on it will no longer build on i686.

There are two packages that are directly affected: `perl-DBD-MySQL`,
`mysql-connector-odbc`, but both are part of the MySQL stack and are
expected to follow MySQL upstream development.

All of the other packages in the distribution should be already
adapted to using MariaDB instead of MySQL.

Please let me know if you know of any other packages.


2) Unknown issues
This is the first time such switch is done for the packages that
recently adopted the versioned layout after the end of modularity.
I may encounter unexpected issues and I will need to solve them on the go.




== Feedback ==


== Benefit to Fedora ==

MySQL 8.4 is the latest LTS version of MySQL and the upstream
development focus steer to it.

The MySQL 8.4 contains major improvements and AFAIK there's no reason
to stay with the old LTS.


== Scope ==
* Proposal owners:
** will do switch in the packages `mysql8.0` and `mysql8.4`
** will check for any issues with the dependent packages

* Other developers:
** are expected to cooperate in case of fixes in dependent packages are needed

* Release engineering: I assume the Mass Rebuild will take place, so I
don't need to rebuild the dependent packages myself.

* Policies and guidelines: N/A (not needed for this Change)

* Trademark approval: N/A (not needed for this Change)

* Alignment with the Fedora Strategy: Fedora leads in the Linux
distribution development

== Upgrade/compatibility impact ==

DB administrators need to handle the DB upgrade, as usual.
In case the DB admin need more time with the old MySQL 8.0, is still
will be available as an alternative in Fedora 43.


== Early Testing (Optional) ==
None defined yet.

== How To Test ==
Test the Fedora upgrade, on systems with MySQL DBs, to Fedora 43, once
the change is implemented.

== User Experience ==
Load of features and enhancements inside of the software itself.

== Dependencies ==
`perl-DBD-MySQL`, `mysql-connector-odbc`


== Contingency Plan ==

* Contingency mechanism: The change will be reverted.

* Contingency deadline: N/A (not a System Wide Change)

* Blocks release? No


== Documentation ==

https://dev.mysql.com/doc/relnotes/mysql/8.1/en/
https://dev.mysql.com/doc/relnotes/mysql/8.2/en/
https://dev.mysql.com/doc/relnotes/mysql/8.3/en/
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/


== Release Notes ==


--
Aoife Moloney

Fedora Operations Architect

Fedora Project

Matrix: @amoloney:fedora.im

IRC: amoloney

--
_______________________________________________
devel-announce mailing list -- devel-announce@lists.fedoraproject.org
To unsubscribe send an email to devel-announce-leave@lists.fedoraproject.org
Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/
List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines
List Archives: https://lists.fedoraproject.org/archives/list/devel-announce@lists.fedoraproject.org
Do not reply to spam, report it: https://pagure.io/fedora-infrastructure/new_issue