Configure MySQL

This page outlines the configuration values for the MySQL deployed via Axual Governance Helm chart.

About MySQL

MySQL is an open-source relational database management system. MySQL is used by the Platform Manager and the Keycloak to store their data. We have defined two aliases to handle the two different databases required to Axual Governance.

platform-manager-mysql
keycloak-mysql

MySQL Configuration

Since we are using the Bitnami MySQL helm charts, we suggest looking at the MySQL public documentation to have a complete list of configurations.

MySQL Deployment name

The deployment name will affect the names that MySQL will give to the resources like pods, secrets, etc.

An example that will use the release-name and the name to generate service names is like the following

values.yaml

platform-manager-mysql:
  ## @param nameOverride String to partially override common.names.fullname template (will maintain the release name)
  ##
  nameOverride: "platform-manager-mysql"
  ## @param fullnameOverride String to fully override common.names.fullname template
  ##
  fullnameOverride: ""

In this example instead, it will use the full-name to generate service names.

values.yaml

keycloak-mysql:
  ## @param nameOverride String to partially override common.names.fullname template (will maintain the release name)
  ##
  nameOverride: ""
  ## @param fullnameOverride String to fully override common.names.fullname template
  ##
  fullnameOverride: "keycloak-mysql"

MySQL Repository Configuration

Initially, you can override the registry, tag, and pullPolicy for the MySQL pod.

By default, these values come from the Axual Governance charts.

You can also override the imagePullSecrets; if not specify the MySQL pod will use the global.imagePullSecrets

values.yaml

platform-manager-mysql:
  ## @param global.imageRegistry Global Docker image registry
  ## @param global.imagePullSecrets Global Docker registry secret names as an array
  ##
  global:
    imageRegistry: ""
    imagePullSecrets:
      - name: axualdockercred

keycloak-mysql:
  ## @param global.imageRegistry Global Docker image registry
  ## @param global.imagePullSecrets Global Docker registry secret names as an array
  ##
  global:
    imageRegistry: ""
    imagePullSecrets:
      - name: axualdockercred

MySQL Database Configuration

You can configure MySQL to initialize a database during startup, like the following

values.yaml

platform-manager-mysql:
  ## MySQL Authentication parameters
  ##
  auth:
    ## @param auth.rootPassword Password for the `root` user. Ignored if existing secret is provided
    ## ref: https://github.com/bitnami/containers/tree/main/bitnami/mysql#setting-the-root-password-on-first-run
    ##
    rootPassword: "verysecret"
    ## @param auth.createDatabase Whether to create the .Values.auth.database or not
    ## ref: https://github.com/bitnami/containers/tree/main/bitnami/mysql#creating-a-database-on-first-run
    ##
    createDatabase: true
    ## @param auth.database Name for a custom database to create
    ## ref: https://github.com/bitnami/containers/tree/main/bitnami/mysql#creating-a-database-on-first-run
    ##
    database: "selfservice-db"
    ## @param auth.username Name for a custom user to create
    ## ref: https://github.com/bitnami/containers/tree/main/bitnami/mysql#creating-a-database-user-on-first-run
    ##
    username: "fluxmaster"
    ## @param auth.password Password for the new user. Ignored if existing secret is provided
    ##
    password: "notsecret"

keycloak-mysql:
  ## MySQL Authentication parameters
  ##
  auth:
    ## @param auth.rootPassword Password for the `root` user. Ignored if existing secret is provided
    ## ref: https://github.com/bitnami/containers/tree/main/bitnami/mysql#setting-the-root-password-on-first-run
    ##
    rootPassword: "verysecret"
    ## @param auth.createDatabase Whether to create the .Values.auth.database or not
    ## ref: https://github.com/bitnami/containers/tree/main/bitnami/mysql#creating-a-database-on-first-run
    ##
    createDatabase: true
    ## @param auth.database Name for a custom database to create
    ## ref: https://github.com/bitnami/containers/tree/main/bitnami/mysql#creating-a-database-on-first-run
    ##
    database: "keycloak-db"
    ## @param auth.username Name for a custom user to create
    ## ref: https://github.com/bitnami/containers/tree/main/bitnami/mysql#creating-a-database-user-on-first-run
    ##
    username: "keycloak"
    ## @param auth.password Password for the new user. Ignored if existing secret is provided
    ##
    password: "notsecret"