Add Mysql 8.3

[marie-oxeva]

Hello,

Is it possible to add the Mysql 8.3 version?

We are limited with two Mysql versions since 2 years. I'd like to take this opportunity to say that version 8.0 has since been patched (https://github.com/bitpoke/mysql-operator/blob/master/pkg/util/constants/constants.go).

Regards,
Marie

[odoucet]

8.3 is not possible easily because MySQL is launched with option --skip-host-cache that was removed in 8.3

We can at least launch a MySQL 8.2 with current bitpoke operator with the tricks explained here : https://hub.docker.com/r/oxeva/mysql-operator-sidecar-8.2/

• launch percona server 8.2, and tell bitpoke it's version 8.0
• override sidecontainer for 8.0 version to use a 8.2-compatible image.

[drivebyer]

In my test case, MySQL prompted an error:

[ERROR] [MY-000068] [Server] unknown option '--skip-host-cache'.

We can update this variable's name according to the MySQL minor version. When the MySQL version is 8.3, we should set it to host_cache_size=0, as stated in the release note.