steve icon indicating copy to clipboard operation
steve copied to clipboard

Community feedback wanted: Drop support for MySQL 5.7

Open goekay opened this issue 2 years ago • 5 comments

Hey all,

MySQL 5.7 has been released in late 2015. MySQL 8 is around since 2018. We support MySQL 5.7 and upwards. Our DB migration tool Flyway dropped MySQL 5.7 in its free tier. Therefore, we cannot upgrade Flyway beginning with this.

I want to make MySQL 8 the baseline. Feedback and ideas are welcome. Are you okay with this?

goekay avatar Sep 03 '22 09:09 goekay

Okay by me.

shadsnz avatar Sep 03 '22 09:09 shadsnz

I understand the motivation. Unfortunately Debian based Linux distribution are relative conservative regarding new packages especially to databases, so MySQL 8 is included just in Ubuntu 22.04.

Is there some kind of timeline for the migration? Will there be a step wise migration like a temporary test & development branch for the brave ones?

Personally i suggest to migrate to MySQL 8 before migrate to Java 17.

lategoodbye avatar Sep 04 '22 21:09 lategoodbye

@goekay What will be the impact? I think having a features/mysql8-migration with the changes (at least the jooq plugin upgrade) could help to give feedbacks.

juherr avatar Sep 05 '22 19:09 juherr

since we support mysql 8 already, there won't be any code changes. we will just be dropping the support of mysql 5.7. this means:

  • updating the readme.
  • removing the github actions builds that include mysql 5.7.
  • update flyway's maven plugin.

this issue has more of a "what if..." character and is a heads up, since we might break your installation if you still use mysql 5.7. i am trying to gauge community support or backlash.

goekay avatar Sep 05 '22 19:09 goekay

Just to get this right, MariaDB (10.2 and higher) support is completely unaffected by this change?

lategoodbye avatar Sep 17 '22 07:09 lategoodbye

i am not sure about "10.2 and higher" but i think "10.3 and higher" should be fine. we have 10.3 and 10.5 in our github action build matrix and they pass.

goekay avatar Oct 18 '22 22:10 goekay