NuoCA Integration with InfluxDB

{question}

How can I access the data?

{question}

 

{answer}

An optional output destination for NuoMon.* data can be InfluxDB. The output plugin InfluxDB will filter out any non-NuoMon.* time-series values.

To use the output plugin,  Add

- InfluxDB:
url: http://localhost:8086?db=nuoca
compress: true
user: auth_user
password: auth_passwd

The URL is the only required field.  Set 'compress' to 'true' to enable compression of data before sending to the URL endpoint. For basic authentication, set 'user' and 'password'.

To test:

  • install and run the InfluxDB docker container.
docker run --name=influxdb -p 8086:8086 influxdb:alpine
  • create a database for testing purposes
docker exec -i influxdb influx --execute "CREATE DATABASE nuoca WITH DURATION 365d REPLICATION 1 SHARD DURATION 1d NAME nuocarp"
  • start NuoCA with the configuration, change domain credentials as appropriate.
---
NUOCA_LOGFILE: /var/log/nuodb/nuoca.log
INPUT_PLUGINS:
- NuoMon:
  description : Collection from internal nuomonitor tool
broker: localhost:48004
domain_username: domain
domain_password: bird
database_regex_pattern: '^(?!nuodb_system|\\.).*'
host_uuid_shortname: True
domain_metrics_host: localhost
OUTPUT_PLUGINS:
- InfluxDB:
url: http://localhost:8086/write?db=nuoca
  • You can verify that you have data in the database, with
docker exec -it influxdb influx
Connected to http://localhost:8086 version 1.3.7
InfluxDB shell version: 1.3.7
> use nuoca
Using database nuodb
> show measurements
name: measurements
name
----
ActiveTime
ActualVersion
AdminReceived
AdminSent
ArchiveBandwidthThrottleTime
ArchiveBufferedBytes
ArchiveDirectoryTime
ArchiveFsyncTime
ArchiveQueue
ArchiveReadTime
ArchiveSyncThrottleTime
ArchiveWriteTime
AtomProcessingThreadBacklog
BroadcastTime
BytesBuffered
BytesReceived
BytesSent
...

To query the database from within influx shell command, you can run SQL like queries.

> select * from Milliseconds order by time desc limit 2;
name: Milliseconds
time db host nodeid nodetype normvalue pid raw region value
---- -- ---- ------ -------- --------- --- --- ------ -----
1514989501000000000 unknown localhost 2 Transaction 0.125 4527 10000 DEFAULT_REGION 1
1514989500000000000 unknown localhost 1 Storage 0.125 13375 10000 DEFAULT_REGION 1

 {answer}

Have more questions? Submit a request

Comments