Speedgain for Databases

s4dbsReverseDeployment:
  ...
  protocol: HTTP
  publicPort: 80
  ...
  sslCertManual: false # set to true if you want to configure SSL certificates manually ...
  sslCertKey: | # insert key certificate in the line below ...

  sslCertFullchain: | # insert fullchain certificate(s) in the line below ...

#### end-of-section ####

s4dbsReverseDeployment:
  ...
  protocol: HTTPS
  publicPort: 443
  ...
  sslCertManual: false # set to true if you want to configure SSL certificates manually ...
  sslCertKey: | # insert key certificate in the line below
    -----BEGIN PRIVATE KEY-----
    #### key certificate content ####
    -----END PRIVATE KEY-----
  sslCertFullchain: | # insert fullchain certificate(s) in the line below
    -----BEGIN CERTIFICATE-----
    #### key certificate content ####
    -----END CERTIFICATE-----
    -----BEGIN CERTIFICATE-----
    #### key certificate content ####
    -----END CERTIFICATE-----

s4dbsReverseDeployment:
  ...
  protocol: HTTPS
  publicPort: 443
  ...
  sslCertManual: true # set to true if you want to configure SSL certificates manually ...
  sslCertKey: | # insert key certificate in the line below

  sslCertFullchain: | # insert fullchain certificate(s) in the line below

helm install --dry-run s4dbschart . | less

helm install s4dbschart .

helm uninstall s4dbschart
helm install s4dbschart .

# Default values for s4dbs.
# This is a YAML-formatted file.
# Declare variables to be passed into your templates.

# frontendConfigMode should not be changed unless you are advised to by support team
frontendConfigMode: false

### START * not needed if frontendConfigMode set to false ###
# serverHostname is the public available dns / server name - e.g. route in an openshift
serverHostname: localhost ##enter dns name of route here (will be created later) ##

# servicePort is the public service /rest-api port for the frontend to redirect correctly - change to 8080 (port of reverse proxy) if not using a route or ingress up front s4dbs
servicePort: 80

# serverProtokol depends on your configmap for reverse proxy / nginx
serverProtokol: http

# grafanaPort is the public grafana port for the frontend to redirect correctly - change to 8080/grafana (port of reverse proxy) if not using a route or ingress up front s4dbs
grafanaPort: 80/grafana

### END * not needed if frontendConfigMode set to false ###

# pdb is the overall repository (aka pdb) configuration
pdb:
  pdbDbName: speedgain
  pdbHost: s4dbs-postgres-service
  pdbPort: 5432
  pdbUser: postgres

# s4dbsCollectorDeployment defines collector image and varas
s4dbsCollectorDeployment:
  image: docker.io/itgainis/s4dbs_collector:2.2.0
  replicas: 1
  spgLogLevel: INFO
  requests_memory: "2Gi"
  requests_cpu: "0.5"
  limits_memory: "8Gi"
  limits_cpu: "4"

# s4dbsPostgresDeployment defines timescale image and varas
s4dbsPostgresDeployment:
  image: docker.io/itgainis/s4dbs_timescaledb:2.2.0
  persistentVolumeClaimName: s4dbs-postgres-pv-claim
  persistentVolumeClaimSize: 100G
  storageClassName: something            # change to map you storage provider, like managed-csi on AZURE or thin on OpenShift
  postgres_initdb_args: ""               # set for example to "--wal-segsize=XYZ" if you changed WAL segment size in your S4DBs V1.8.2 PDB - important for migration to V2.0.0
  postgres_options: max_connections=200  # override with your custom configuration parameters
  requests_memory: "1Gi"
  requests_cpu: "1"
  limits_memory: "16Gi"
  limits_cpu: "8"
  fs_group: -1                # defines the fsGroup within the SecurityContext config of the s4dbs_postgres pod. Set it to -1 to disable securityContext settings. Set it to a positive value to set the fsGroup ID.

# s4dbsServiceDeployment defines service image and varas
s4dbsServiceDeployment:
  image: docker.io/itgainis/s4dbs_service:2.2.0
  port: 8080
  requests_memory: "256Mi"
  requests_cpu: "0.5"
  limits_memory: "4Gi"
  limits_cpu: "2"

# s4dbsServiceDeployment defines service image and varas
s4dbsMcpDeployment:
  image: docker.io/itgainis/s4dbs_mcp:2.2.0
  port: 8000
  s4dbsUrl: http://s4dbs-service-service:8080/Speedgain_for_Databases_Service/speedgain
  s4dbsUser: "admin"
  requests_memory: "256Mi"
  requests_cpu: "0.5"
  limits_memory: "4Gi"
  limits_cpu: "2"

# s4dbsGrafanaDeployment defines grafana image and varas
s4dbsGrafanaDeployment:
  image: docker.io/itgainis/s4dbs_grafana:2.2.0
  port: 3000
  anonymousLogin: false
  requests_memory: "256Mi"
  requests_cpu: "0.5"
  limits_memory: "2Gi"
  limits_cpu: "2"

# s4dbsFrontendDeployment defines frontend image and varas
s4dbsFrontendDeployment:
  image: docker.io/itgainis/s4dbs_frontend:2.2.0
  port: 8080
  requests_memory: "128Mi"
  requests_cpu: "0.5"
  limits_memory: "2Gi"
  limits_cpu: "1"

# s4dbsReverseDeployment defines reverse proxy image and varas
s4dbsReverseDeployment:
  enabled: true #set to false if you want to use own reverse proxy / ingress nginx
  external_traffic_service_type: LoadBalancer # set to Load Balancer, ClusterIP or NodePort to specify remote access type
  image: docker.io/nginx:1.29.7-alpine
  port: 8080
  protocol: HTTP #Controls if HTTP or SSL/HTTPS communication is to use. Basically: set this to HTTPS if publicPort is 443. Using SSL/HTTPS without setting protocol to HTTPS will cause probes to fail!
  publicPort: 80 #Recommendation is port 80 for HTTP or 443 for HTTPS communication.
  requests_memory: "256Mi"
  requests_cpu: "0.5"
  limits_memory: "2Gi"
  limits_cpu: "1"
  sslCertManual: false # set to true if you want to configure SSL certificates manually instead inserting them below. See https://speedgain.info/_kubernetes_installation.html#_setup_ssl_encryption for the commandline instruction.
  sslCertKey: | # insert key certificate in the line below - Necessary for SSL/HTTPS communication!

  sslCertFullchain: | # insert fullchain certificate(s) in the line below - Necessary for SSL/HTTPS communication!