Skip to content

Latest commit

 

History

History
44 lines (33 loc) · 1.64 KB

File metadata and controls

44 lines (33 loc) · 1.64 KB

mysql

Standalone MySQL 8.x for FleetDM using the official mysql Docker Hub image. Single-pod StatefulSet, no Group Replication.

Why not Oracle's MySQL Operator?

The Oracle MySQL Operator only provisions InnoDBCluster resources, which always enable Group Replication — even on a single-node cluster. Group Replication's "external plugin" check forbids ALTER TABLE ... DROP PRIMARY KEY without a simultaneous ADD PRIMARY KEY, but Fleet's migration 20231107130934_AlterWindowsProfilesUseUuid.go does exactly that as two separate statements.

Enabling sql_generate_invisible_primary_key=ON doesn't help — it also requires that a DROP PRIMARY KEY always be paired with an ADD PRIMARY KEY in the same statement. There is no operator-level switch to disable this check.

Oracle does not publish a standalone (non-clustered) MySQL Helm chart, so this minimal chart wraps the official mysql:8.4 Docker image to get the same upstream provenance without the Group Replication plumbing.

Install standalone

helm install mysql charts/mysql --namespace database \
  --set credentials.existingSecret=mysql-credentials

The Secret must already exist with keys mysql-root-password and mysql-password (the project's bootstrap chart creates it).

Notable values

Key Default
image.tag 8.4.6
database fleet
user fleet
persistence.size 8Gi
service.port 3306

See values.yaml for the full schema.