MySQL 9 compatibility

[jeffchown]

Hello @brianmario - Thanks for your work on mysql2 👍

I have legacy Rails projects on my local dev machine, and after a recent update of MySQL to v9 I can no longer run the Rails projects making the ongoing support of those client projects challenging.

Are there plans to add MySQL 9 compatibility to mysql2?

If so, is there an estimated timeline?

Thanks.

[jeremy]

1. Please do add CI for MySQL 9 and address the incompatibilities that arise in your tests. See CI: Add Ruby 3.4, MySQL 8.4, MariaDB 11.4, Ubuntu 24.04 and other updates #1387 for an example.
2. Recommend using LTS releases (MySQL 8.0 or 8.4) for your client projects.

[sodabrew]

Echoing @jeremy, yes pull requests for MySQL 9 appreciated. No timeline is offered by the active collaborators, I don't think anybody on here has tried 9 yet!

At the moment only LTS releases of MySQL and MariaDB are in CI, but it would be nice to have an auto-updated pointer to the latest versions of MySQL and MariaDB to help catch incoming changes.