search

free / sql_exporter

Database agnostic SQL exporter for Prometheus
MIT License
541 stars 172 forks source link

Reload config file while the exporter running #56

Open idan27 opened 4 years ago

idan27 commented 4 years ago

Hey, first of all i wanted to say that im using the exporter and he's amazing I wanted to ask you how to reload the config file while the sql_exporter still running on windows machine. I saw the answer that you told to Tangxuye but i tried to do it myself and didnt quite get it. If you can help me that would be amazing ! Thank you

JoostvdB94 commented 3 years ago

I also wanted to create this feature request. In our scenario, the sql exporter is running in a container within Kubernetes. And the connection string is now passed to the application using the command line argument. However, the credentials rotate automatically to meet our high security requirements, causing us to restart the sql exporter every time a new password is generated.

Furthermore, it would be nice if multiple configuration files can be specified that will be merged together. We would like to supply the sql connectionstring using a separate configuration file. This way it is possible to place the sensitive information in the connectionstring under higher protection (using kubernetes secrets or an external secret provider such as Hashicorp Vault)

Unfortunately I have no experience in Go, so changing or testing the code would be a huge challenge.