Advancing controller

​

Infrastructure prerequisites

Advancing controller requires the following components to be set up before it can be started:

• FlowX Engine deployment - the Advancing Controller is dependent on the FlowX Engine and must be deployed in the same environment, refer to the FlowX Engine setup guide for more information on how to set up the Engine
• DB instance - the Advancing Controller uses a PostgreSQL or OracleDB as database instance

​

Dependencies

• Database
• Datasource
• FlowX Engine

​

Database configuration

​

Postgres

A basic Postgres configuration for Advancing:

postgresql:
  enabled: true
  postgresqlUsername: "postgres"
  postgresqlPassword: ""
  postgresqlDatabase: "advancing"
  existingSecret: "postgresql-generic"
  postgresqlMaxConnections: 200
  persistence:
    enabled: true
    storageClass: standard-rwo
    size: 20Gi
  resources:
    limits:
      cpu: 1000m
      memory: 1024Mi
    requests:
      memory: 256Mi
      cpu: 100m
  metrics:
    enabled: true
    serviceMonitor:
      enabled: false
    prometheusRule:
      enabled: false
  primary:
    nodeSelector:
      preemptible: "false"

​

Configuration

The following configuration details need to be added using environment variables:

Advancing controller uses a PostgreSQL or an Oracle database as a dependency.

• the user, password, connection link, and database name need to be configured correctly, if these details are not configured correctly, errors will occur at startup
• the datasource is configured automatically via a Liquibase script inside the engine. All updates will include migration scripts.

​

Configuring datasource

The following configuration details need to be added using environment variables:

• SPRING_DATASOURCE_URL - environment variable used to configure a data source URL for a Spring application, it typically contains the JDBC driver name, the server name, port number, and database name
• SPRING_DATASOURCE_USERNAME - environment variable used to set the username for the database connection, this can be used to connect to a database instance
• SPRING_DATASOURCE_PASSWORD - environment variable used to store the password for the database connection, this can be used to secure access to the database and ensure that only authorized users have access to the data
• SPRING_JPA_DATABASE - relevant because it is used to specify the type of database that the Spring application should connect to (accepted values: oracle or postgresql)
• SPRING_JPA_PROPERTIES_HIBERNATE_DEFAULTSCHEMA (❗️only for Oracle DBs) - dpecifies the default schema to use for the database (default value: public)

You will need to make sure that the user, password, connection link and db name are configured correctly, otherwise, you will receive errors at start time.