How can we help you today? How can we help you today?

Do I still need to manually configure and install a MySQL driver in Flyway 8.2.0 and later versions?

Do I still need to manually configure and install a MySQL driver in Flyway 8.2.0 and later versions? If no MySQL driver is found on the Classpath, Flyway will automatically default to the MariaDB driver. Is this correct?

As my current Flyway version is outdated, at 5.2.4, and I'm planning to upgrade to version 10.11.0, I noticed that the MySQL driver is no longer included in Flyway 10.11.0. I checked the official documentation and learned that the MySQL driver was removed in Flyway 8.2.0. Thus, I'm wondering: after upgrading Flyway, will I still need to manually configure a driver for MySQL?
liuyangtopone
1

Comments

3 comments

Sort by
  • Patrick893

    Yes, you are correct. Starting from Flyway version 8.2.0, the MySQL driver is no longer included by default. Instead, if no MySQL driver is found on the classpath, Flyway will automatically use the MariaDB driver as a default option.

    https://forum.red-gate.com/discussion/90182/migration-info-table-not-displayed-from-api-using-flyway-info slope ball

    When you upgrade from Flyway 5.2.4 to 10.11.0, you will need to manually add the MySQL driver to your classpath if you want to use it instead of the MariaDB driver. If you prefer to stick with the MariaDB driver, you won't need to configure anything manually, as it will be used automatically.

    Patrick893
    1
  • liuyangtopone
    Patrick893 said:

    Yes, you are correct. Starting from Flyway version 8.2.0, the MySQL driver is no longer included by default. Instead, if no MySQL driver is found on the classpath, Flyway will automatically use the MariaDB driver as a default option.

    https://forum.red-gate.com/discussion/90182/migration-info-table-not-displayed-from-api-using-flyway-info slope ball

    When you upgrade from Flyway 5.2.4 to 10.11.0, you will need to manually add the MySQL driver to your classpath if you want to use it instead of the MariaDB driver. If you prefer to stick with the MariaDB driver, you won't need to configure anything manually, as it will be used automatically.

    thanks Patrick . it's so useful.
    liuyangtopone
    1
  • regainfielder

    Re: space waves 2

    Hey everyone! Just saw the announcement for SQL Prompt 11 and I’m super excited about the new support for SSMS 21 GA. It’s great to see how Redgate is keeping up with the latest versions! I’m really curious about how integrating these updates will improve query writing efficiency. Has anyone had a chance to test it out yet? What specific features do you think will be game-changers in your daily work? Looking forward to hearing your thoughts!

    regainfielder
    -1

Add comment

Please sign in to leave a comment.