External MysqlDB support for Kestra in EKS

surya9teja commented 2 months ago

Issue description

As the title implies, Is it possible to use MysqlDb as the backend database for Kestra. If yes, How can I configure the values.yaml file in helm chart to point out to my external db?

paulgrainger85 commented 2 months ago

Hi, yes you need to make 2 changes to the default helm values:

Disable the PG pod https://github.com/kestra-io/helm-charts/blob/a0fee7fab41fd0c37b4116afa91bfff6d23999fa/charts/kestra/values.yaml#L190

Add the following configuration to the values

configuration:
datasources:
mysql:
  url: jdbc:mysql://mysql-host:mysql-port/db_name
  driverClassName: com.mysql.cj.jdbc.Driver 
  dialect: MYSQL
  username: mysql_user
  password: mysql_pass

If you wish to source the above from a secret, you can see some examples in the values.yaml file https://github.com/kestra-io/helm-charts/blob/a0fee7fab41fd0c37b4116afa91bfff6d23999fa/charts/kestra/values.yaml#L43

Ben8t commented 2 months ago

Thanks Paul !!! @surya9teja if you have more questions please ask in channel help in Slack

kestra-io / helm-charts

External MysqlDB support for Kestra in EKS #53

Issue description