Support for Amazon Aurora databases is missing

[prof-schnitzel]

Which version and edition of Flyway are you using?

9.16.3 community edition

If this is not the latest version, can you reproduce the issue with the latest one as well? (Many bugs are fixed in newer releases and upgrading will often resolve the issue)

Yes

Which client are you using? (Command-line, Java API, Maven plugin, Gradle plugin)

Maven plugin

Which database are you using? (Type & version)

Amazon Aurora MySQL 8.0

Which operating system are you using?

Windows 11

What did you do? (Please include the content causing the issue, any relevant configuration settings, the SQL statement(s) that failed (if any), and the command you ran)

According to the AWS documentation it is recommended to use aws-advanced-jdbc-wrapper to connect to Aurora databases. So I used that maven dependency, set the jdbc url to jdbc:aws-wrapper:mysql://* and the driver to software.amazon.jdbc.Driver.

What did you expect to see?

I would expect that Flyway supports Aurora MySQL, since it is listed as a supported database here: https://documentation.red-gate.com/flyway/flyway-cli-and-api/supported-databases/aurora-mysql
But there is no flyway DatabaseType that supports jdbc urls like this one: "jdbc:aws-wrapper:mysql://*". So it is not possible to use flyway together with Aurora databases.

What did you see instead?

I get the exception org.flywaydb.core.api.FlywayException: No database found to handle jdbc:aws-wrapper:mysql://

[Barry-RG]

Flyway's Aurora MySQL support is based off of direct connection to the database instance and treating it as a MySQL connection. This AWS Wrapper JDBC driver was not part of that support as it was only introduced in September 2023 and has not been requested for support. I will add this to the proposed support list.