[Enhancement]: Set compatibility for `container-registry.oracle.com/mysql/community-server` for MySQL module

[linghengqian]

Module

MySQL

Proposal

• mysql is not the official Docker Image of MySQL. According to https://dev.mysql.com/doc/refman/9.1/en/docker-mysql-getting-started.html and Change docker image to the official one from oracle repository oracle/graalvm-reachability-metadata#350 , only container-registry.oracle.com/mysql/community-server is the official image of MySQL.
• I think it is necessary to set compatibility of container-registry.oracle.com/mysql/community-server for MySQL module.

[haider2122]

I'd like to work on this. My approach: add container-registry.oracle.com/mysql/community-server as a second compatible image name in assertCompatibleWith() in MySQLContainer. Does this approach look right to maintainers?

[linghengqian]

Perhaps the maintainer doesn't have the time to look into the issues?

[haider2122]

Raised a PR for this: #11767
The fix adds container-registry.oracle.com/mysql/community-server as a second accepted image name in assertCompatibleWith in both the current org.testcontainers.mysql.MySQLContainer and the deprecated org.testcontainers.containers.MySQLContainer. Happy to get any feedback.

[eddumelendez]

I don't think we can add container-registry.oracle.com/mysql/community-server as compatible image if test are failing (testWithOnlyUserReadableCustomIniFile, testMySQLWithCustomIniFile). This due to a different path for configuration. Also, the purpose of DockerImageName.parse("container-registry.oracle.com/mysql/community-server:8").asCompatibleSubstituteFor("mysql") is adding images that developers think are compatible.