Graphite protocol support in InfluxDB

The Graphite Input

A Note On UDP/IP OS Buffer Sizes

If you’re using UDP input and running Linux or FreeBSD, please adjust your UDP buffersize limit, see here for more details.

Configuration

Each Graphite input allows the binding address, target database, and protocol to be set. If the database does not exist, it will be created automatically when the input is initialized. The write-consistency-level can also be set. If any write operations do not meet the configured consistency guarantees, an error will occur and the data will not be indexed. The default consistency-level is ONE.

Each Graphite input also performs internal batching of the points it receives, as batched writes to the database are more efficient. The default batch size is 1000, pending batch factor is 5, with a batch timeout of 1 second. This means the input will write batches of maximum size 1000, but if a batch has not reached 1000 points within 1 second of the first point being added to a batch, it will emit that batch regardless of size. The pending batch factor controls how many batches can be in memory at once, allowing the input to transmit a batch, while still building other batches.

Parsing Metrics

The Graphite plugin allows measurements to be saved using the Graphite line protocol. By default, enabling the Graphite plugin will allow you to collect metrics and store them using the metric name as the measurement. If you send a metric named servers.localhost.cpu.loadavg.10, it will store the full metric name as the measurement with no extracted tags.

While this default setup works, it is not the ideal way to store measurements in InfluxDB since it does not take advantage of tags. It also will not perform optimally with large dataset sizes since queries will be forced to use regexes which is known to not scale well.

To extract tags from metrics, one or more templates must be configured to parse metrics into tags and measurements.

Templates

Templates allow matching parts of a metric name to be used as tag keys in the stored metric. They have a similar format to Graphite metric names. The values in between the separators are used as the tag keys. The location of the tag key that matches the same position as the Graphite metric section is used as the value. If there is no value, the Graphite portion is skipped.

The special value measurement is used to define the measurement name. It can have a trailing * to indicate that the remainder of the metric should be used. If a measurement is not specified, the full metric name is used.

Basic Matching

servers.localhost.cpu.loadavg.10

  • Template: .host.resource.measurement*
  • Output: measurement =loadavg.10 tags =host=localhost resource=cpu

Multiple Measurement & Tags Matching

The measurement can be specified multiple times in a template to provide more control over the measurement name. Tags can also bematched multiple times. Multiple values will be joined together using the Separator config variable. By default, this value is ..

servers.localhost.localdomain.cpu.cpu0.user

  • Template: .host.host.measurement.cpu.measurement
  • Output: measurement = cpu.user tags = host=localhost.localdomain cpu=cpu0

Since . requires queries on measurements to be double-quoted, you may want to set this to _ to simplify querying parsed metrics.

servers.localhost.cpu.cpu0.user

  • Separator: _
  • Template: .host.measurement.cpu.measurement
  • Output: measurement = cpuuser _tags = host=localhost cpu=cpu0

Adding Tags

Additional tags can be added to a metric if they don’t exist on the received metric. You can add additional tags by specifying them after the pattern. Tags have the same format as the line protocol. Multiple tags are separated by commas.

servers.localhost.cpu.loadavg.10

  • Template: .host.resource.measurement* region=us-west,zone=1a
  • Output: measurement = loadavg.10 tags = host=localhost resource=cpu region=us-west zone=1a

Fields

A field key can be specified by using the keyword field. By default if no field keyword is specified then the metric will be written to a field named value.

The field key can also be derived from the second “half” of the input metric-name by specifying field (eg measurement.measurement.field). This cannot be used in conjunction with “measurement*“!

It’s possible to amend measurement metrics with additional fields, e.g:

Input:

  1. sensu.metric.net.server0.eth0.rx_packets 461295119435 1444234982
  2. sensu.metric.net.server0.eth0.tx_bytes 1093086493388480 1444234982
  3. sensu.metric.net.server0.eth0.rx_bytes 1015633926034834 1444234982
  4. sensu.metric.net.server0.eth0.tx_errors 0 1444234982
  5. sensu.metric.net.server0.eth0.rx_errors 0 1444234982
  6. sensu.metric.net.server0.eth0.tx_dropped 0 1444234982
  7. sensu.metric.net.server0.eth0.rx_dropped 0 1444234982

With template:

  1. sensu.metric.* ..measurement.host.interface.field

Becomes database entry:

  1. > select * from net
  2. name: net
  3. ---------
  4. time host interface rx_bytes rx_dropped rx_errors rx_packets tx_bytes tx_dropped tx_errors
  5. 1444234982000000000 server0 eth0 1.015633926034834e+15 0 0 4.61295119435e+11 1.09308649338848e+15 0 0

Multiple Templates

One template may not match all metrics. For example, using multiple plugins with diamond will produce metrics in different formats. If you need to use multiple templates, you’ll need to define a prefix filter that must match before the template can be applied.

Filters

Filters have a similar format to templates but work more like wildcard expressions. When multiple filters would match a metric, the more specific one is chosen. Filters are configured by adding them before the template.

For example,

  1. servers.localhost.cpu.loadavg.10
  2. servers.host123.elasticsearch.cache_hits 100
  3. servers.host456.mysql.tx_count 10
  4. servers.host789.prod.mysql.tx_count 10
  • servers.* would match all values
  • servers.*.mysql would match servers.host456.mysql.tx_count 10
  • servers.localhost.* would match servers.localhost.cpu.loadavg
  • servers...mysql would match servers.host789.prod.mysql.tx_count 10

Default Templates

If no template filters are defined or you want to just have one basic template, you can define a default template. This template will apply to any metric that has not already matched a filter.

  1. dev.http.requests.200
  2. prod.myapp.errors.count
  3. dev.db.queries.count
  • env.app.measurement* would create
    • measurement=requests.200 tags=env=dev,app=http
    • measurement= errors.count tags=env=prod,app=myapp
    • measurement=queries.count tags=env=dev,app=db

Global Tags

If you need to add the same set of tags to all metrics, you can define them globally at the plugin level and not within each template description.

Minimal Config

  1. [[graphite]]
  2. enabled = true
  3. # bind-address = ":2003"
  4. # protocol = "tcp"
  5. # consistency-level = "one"
  6. ### If matching multiple measurement files, this string will be used to join the matched values.
  7. # separator = "."
  8. ### Default tags that will be added to all metrics. These can be overridden at the template level
  9. ### or by tags extracted from metric
  10. # tags = ["region=us-east", "zone=1c"]
  11. ### Each template line requires a template pattern. It can have an optional
  12. ### filter before the template and separated by spaces. It can also have optional extra
  13. ### tags following the template. Multiple tags should be separated by commas and no spaces
  14. ### similar to the line protocol format. The can be only one default template.
  15. # templates = [
  16. # "*.app env.service.resource.measurement",
  17. # # Default template
  18. # "server.*",
  19. #]

Customized Config

  1. [[graphite]]
  2. enabled = true
  3. separator = "_"
  4. tags = ["region=us-east", "zone=1c"]
  5. templates = [
  6. # filter + template
  7. "*.app env.service.resource.measurement",
  8. # filter + template + extra tag
  9. "stats.* .host.measurement* region=us-west,agent=sensu",
  10. # filter + template with field key
  11. "stats.* .host.measurement.field",
  12. # default template. Ignore the first Graphite component "servers"
  13. ".measurement*",
  14. ]

Two Graphite Listeners, UDP & TCP, Config

  1. [[graphite]]
  2. enabled = true
  3. bind-address = ":2003"
  4. protocol = "tcp"
  5. # consistency-level = "one"
  6. [[graphite]]
  7. enabled = true
  8. bind-address = ":2004" # the bind address
  9. protocol = "udp" # protocol to read via
  10. udp-read-buffer = 8388608 # (8*1024*1024) UDP read buffer size

Content from README on GitHub.