search

atlassian / data-center-helm-charts

Helm charts for Atlassian's Data Center products
https://atlassian.github.io/data-center-helm-charts/
Apache License 2.0
155 stars 135 forks source link

[Suggestion] - Configure Database Connection Pool via values.yml #863

Open nagarajuvemula789 opened 2 months ago

nagarajuvemula789 commented 2 months ago

Suggestion

Background

To provide better flexibility and configurability for Jira Data Center deployments on Kubernetes, it would be beneficial to allow users to specify database connection pool sizes directly from the values.yml file.

Proposed Change

I suggest updating the dbconfig.xml template within the Helm chart to dynamically populate the <pool-min-size> and <pool-max-size> values using the values provided in values.yml.

Changes in values.yml

Add the following entries in values.yml:

database: connectionPool: minSize: 20 # Minimum pool size maxSize: 100 # Maximum pool size maxIdle: 50 # (Optional) Maximum idle connections maxWait: 30000 # (Optional) Maximum wait time in ms

Product

Jira

Code of Conduct

bianchi2 commented 2 months ago

@nagarajuvemula789 while your suggestion makes sense, there's a way to override the default database settings:

jira:
  additionalEnvironmentVariables:
  - name: ATL_DB_POOLMAXSIZE
    value: "200"

and so on... You will find the complete list of available env vars at https://atlassian.github.io/data-center-helm-charts/containers/JIRA/#optional-database-settings