Support for MySQL storage

[Yoni-Weisberg]

Feature or Problem Description

Implementing MySQL as an SQL storage option

Proposed Solution

I can create the necessary classes, but I’ll need your assistance, particularly with testing.

Additional Context

I noticed that this has already been suggested here, but there hasn't been any progress on it.

[EricWittmann]

This will be great. And it would not be very difficult. Happy to help!

If you want, we can start with a dedicated branch for the work. I don't think we need any new tests. We just need to run existing tests against the MySQL database.

[Yoni-Weisberg]

Hi. thanks for the quick response.

I've already started to to work on this locally, so let me know the way you want to create the branch.

Regarding tests:

1. How can I run the integration test specifying mysql as storage?
2. I see AbstractRegistryStorageTest tests are commented out - how should I run unit-tests against MySQL storage

[Yoni-Weisberg]

Hi @EricWittmann, I think I am done, please let me know the process of creating new branch, so I can push my changes.

[EricWittmann]

Hey @Yoni-Weisberg that's great! You should be able to just open a Pull Request against the main branch. The project README should have information about that.

Also, we very recently re-enabled the SQL test. So that should actually help you a lot I think. You should be able to create a new variant of that test very easily. Use this for inspiration:

https://github.com/Apicurio/apicurio-registry/blob/main/app/src/test/java/io/apicurio/registry/storage/impl/sql/PostgresqlStorageTest.java

[Yoni-Weisberg]

Hi @EricWittmann, I've opened a PR: #5411