Hey everyone, We are just about to merge the PR that adds MySQL 8.1 support in our CI: https://github.com/apache/airflow/pull/33522
It would not be worth mentioning in devlist, but Oracle changed their strategy on releases and 8.1 (released about a month ago) is the first from the series of "innovation releases" that will be followed by next LTS release (some time next year) - as Andrey helpfully explained in the PR. Which means that we will likely have to bump the MySLQ versions a bit more frequently. It looks like there are no breaking changes (or at least not ones that would break our tests) and adding 8.1 was just a matter of adding it to our list of versions. I do not think there is much say for the future, but assuming it will work in a stable way, we might simply implement it in the future similarly to Postgres - that we will run our tests for 8.0 + last of the 8.* innovation releases (assuming that all versions in-between will work). For example when we will have 8.0, 8.1, 8.2, 8.3 - we will run tests for 8.0 and 8.3 and assume that 8.1 and 8.2 are also working fine. This is calling for a lazy consensus on that approach, with the proposal that the 2.7.1 version of Airflow will get official 8.0 and 8.1 support. Let me know if there are any doubts, otherwise I assume a consensus. I will let it run till Wednesday 23rd of August 2023, 7.30 pm CEST J.
