Skip to content

Advanced Database Configuration

This page provides details of how to provide advanced database configuration during deployment

The kdb Insights Database contains the Service Gateway, Resource Coordinator and Aggregator that are included in the base kdb Insights Enterprise deployment. These components are configured using a values file.

Configuration

In a kdb Insights Enterprise deployment, 2 versions of the Service Gateway (SG) are available:

  • Main query path - intended for critical business applications.

  • Query Environment (QE) - this acts as sandboxes providing non-production query paths for ad-hoc data exploration and analysis. This avoids using the main query path, thereby preventing any negative impact on mission-critical production workloads.

Configuration for the main query version lives under a service-gateway key in your values file, while the QE version is under a qe-gateway key. Both versions have the same configuration but use different default values for their respective workloads.

service-gateway:
  # See 'Resource Coordinator' section below for details
  resource-coordinator: {}
  # See 'Aggregator' section below for details
  aggregator: {}
  # See 'Service Gateway' section below for details
  sg-gateway: {}

qe-gateway:
  # See 'Resource Coordinator' section below for details
  resource-coordinator: {}
  # See 'Aggregator' section below for details
  aggregator: {}
  # See 'Service Gateway' section below for details
  sg-gateway: {}

Service Gateway

The following options are available under the sg-gateway configuration for both the service-gateway and qe-gateway versions of configuration.

Example configuration option

service-gateway:
  sg-gateway:
    env:
      KXI_LOG_LEVELS: "default:trace"

Resource Coordinator

The following options are available under the resource-coordinator configuration for both the service-gateway and qe-gateway versions of configuration.

Example configuration option

service-gateway:
  resource-coordinator:
    env:
      KXI_LOG_LEVELS: "default:trace"

This service also supports metrics.

Aggregator

The following options are available under the aggregator configuration for both the service-gateway and qe-gateway versions of configuration.

Example configuration option

service-gateway:
  aggregator:
    env:
      KXI_LOG_LEVELS: "default:trace"

This service also supports metrics