Comments (2)
Why not apply the "static label per DSN" in the Prometheus config? Something like this:
scrape_configs:
- job_name: 'somedb'
static_configs:
- targets: [ 'instance1.cluster13.foo.org:9399', 'instance2.cluster13.foo.org:9399' ]
labels:
cluster_identifier: cluster13
- targets: [ 'instance1.cluster14.foo.org:9399', 'instance2.cluster14.foo.org:9399' ]
labels:
cluster_identifier: cluster14
This also works with file_sd_config
, but you have to place the labels
in the targets file, next to the targets themselves (i.e. the part after static_configs
above all goes into the targets file).
Or, if you're using some other form of service discovery (e.g. kubernetes_sd_config
), you can use metric_relabel_configs
to create a cluster_identifier
label out of e.g. the instance name. It's all documented here: https://prometheus.io/docs/prometheus/latest/configuration/configuration/#scrape_config
from sql_exporter.
True, dns_sd_config just gets messy with the regex, and we don't necessarily name the scraper running the same as the cluster_identifier as they aren't running on the same hosts.
That is certainly a valid idea, however we also have other labels we want to add that don't belong in the DNS like customer_name, customer_id, etc... so it still gets super messy trying to do it in the prometheus config (also we want this to be dynamic).
Long term we'll have to replace the service discovery with Consul to be able to do this OOB tagging without having to muck with automating hundreds of duplicative file templates that have to be pulled down at container start to bootstrap the config.
I guess, the min-maxer in me just wants to see the labels created once with the DSN instead of dozens of times per file alongside the DSN in the query target config since you can't have more than one server per config anyways.
from sql_exporter.
Related Issues (20)
- Error creating exporter: yaml: line 27: found unexpected end of stream HOT 1
- Custom timestamps? HOT 1
- ClickHouse version
- windows 注册sql_exporter无法启动
- error from sql_export for mssql
- context deadline exceeded on Large table size
- query="mssql_connections" -> Scan error on column index 0, name "db": unsupported Scan, storing driver.Value type <nil> into type *string` HOT 1
- How to expose timestamp?
- specific time to collect data
- Is this still maintained? HOT 2
- docker-compose:open sql_exporter.yml: no such file or directory HOT 1
- How can I define a metric that shows List of Expensive Queries executed in MSSQL like this query: https://blog.sqlauthority.com/2021/03/17/sql-server-list-expensive-queries-updated-march-2021/ HOT 1
- how can i use this exporter in windows system?
- How to create grafana dashboard after getting prometheus matrics HOT 1
- SQL Exporter does not start as service.
- Is it possible to have more than one data source?
- prepare query failed: Error 1064: Unsupported command(COM_STMT_PREPARE)
- sqlserver query results contain space characters Unable to obtain key containing spaces
- No metrics gathered, from Gatherer #1, invalid URL
- Does the connection string support Windows authentication?
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sql_exporter.