Add Mysql 8.3 - Githubissues

bitpoke / mysql-operator

Asynchronous MySQL Replication on Kubernetes using Percona Server and Openark's Orchestrator.

https://www.bitpoke.io/docs/mysql-operator/getting-started/

Apache License 2.0

1.03k stars 275 forks source link

Add Mysql 8.3 #920

Open marie-oxeva opened 5 months ago

marie-oxeva commented 5 months ago

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 commented 5 months ago

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 commented 2 months ago

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.