Need to connect mysql database

[manzajohn]

I need to connect to one of my mysql database running as kubernetes pod. Where can i find the configurations for mysql? i see only Postgres configurations in the repository. Any guidance on connecting mysql database will be appreciated

[dewey]

Any connection string that can be parsed by https://github.com/go-sql-driver/mysql would work.

[manzajohn]

So i assume, need to make below changes in config.yaml

connections:
  - 'mysql://user:password@tcp(db.query.consul)/db'

And in deployment.yaml should i change this to mysql specific? any reference for the same?

containers:

• env:
  • name: CONFIG value: /config/config.yml
  • name: PGPASSFILE value: /pgpass/pgpass
  • name: TEMPLATE_START value: '[['
  • name: TEMPLATE_END value: ']]'
  • name: POSTGRES_CONNECTION_DB4 value: postgres://postgres_exporter@postgres/db4?sslmode=disable image: ghcr.io/justwatchcom/sql_exporter:latest

[dewey]

The configuration file is just an incomplete example on what's possible, you'll have to define what you want in there.