mysql-operator icon indicating copy to clipboard operation
mysql-operator copied to clipboard

How to configure Secret to ensure DATABASE will be created with a specific CHARACTER SET and COLLATE?

Open ferdinandosimonetti opened this issue 3 years ago • 0 comments

Hello, I've used this Secret to create a MySQLCluster with pre-created *keycloak database.

apiVersion: v1 data: DATABASE: a2V5Y2xvYWs= PASSWORD: a2V5Y2xvYWs= ROOT_PASSWORD: bW9vbmV5 USER: a2V5Y2xvYWs= kind: Secret metadata: name: keycloak-db-secret namespace: mooney-utils type: Opaque

The MySQL instance and the database have been created fine, but with utf8mb4 character set... that Keycloak 15.x does not support. I ended up creating an "empty" MySQL instance, and creating the keycloak database on my own with the right character set, I wonder if there's a way to specify it from within the Secret (or inside the MySQLCluster resource).

ferdinandosimonetti avatar Sep 02 '21 15:09 ferdinandosimonetti