Multiple database support

[salacr]

Hi,
Is there a chance that this will support multiple databases?
On my servers i have multiple databases and to have specific config for each server is sub-optimal.
It will be nice if i could export for example table sizes for each database on my server..

[burningalchemist]

Hi @salacr, please check the documentation, sql_exporter has support for multiple databases for a long time. You can find details in the README and also in the available examples. Let me know if you need any assistance. 👍

[salacr]

Sorry I wasn't clear problem is I have 3db (PostgreSQL) servers there are various databases on each and I would lie to have single configuration for all. Now I must write down specific connections string for each database and as I have like 100 of them (pretty small it's a home lab) it's very tedious also Im quite often dropping/ creating new databases and keeping it in sync is nightmare :-/

[burningalchemist]

Hey @salacr, thank you for clarifying. 👍

Yeah, the database auto-discovery is not implemented or planned for the time being, as it's non-trivial given the database-agnostic direction this utility has. Given this constraint, I'd rather keep it outside of the scope, so the configuration is user's responsibility.

It's possible to render the templated configuration, and then use the /reload endpoint to let sql_exporter utilise the updated config. One of the users previously mentioned operating sql_exporter using reload to dynamically manage query configuration on a large scale with over 500+ databases. Maybe this would work for you.

UPD: Your problem could be also potentially solved with jobs feature and the provided list of targets with .../dbname at the end. This would still require rendering the target list but the config output would be smaller.