How can I configure telegraf to connect a VMware server and a SQL server and put the collected data to a diferent buckets?
I have the different buckets configured, but I need to put telegraf at the same server (windows) and using the same config file to collect data from different servers (SQL and VMware).
Take a look at metric filtering, specifically the selectors. You can use them to send certain metric names to certain outputs.
In your case, you will want to outputs, one for each bucket, and then have a selector on each of these to send the SQL to one and the VMware data to the other.
Would it be something like below?
[agent]
interval = “10s”
round_interval = true
metric_batch_size = 1000
metric_buffer_limit = 10000
collection_jitter = “0s”
flush_interval = “10s”
flush_jitter = “0s”
precision = “”
hostname = “”
omit_hostname = false
[[outputs.influxdb_v2]]
urls = [“http s://url.local:8086”]
token = “$INFLUX_TOKEN1”
organization = “ORG001”
bucket = “SQL”
[outputs.influxdb.tagpass]
** influxdb_database = [“SQL”]**
[[inputs.sqlserver]]
[inputs.sqlserver.tags]
** influxdb_database = “SQL”**
servers = [
“Server=192.168.10.20;Port=1433;User Id=;Password=;app name=telegraf;log=1;”,
]
database_type = “SQLServer”
include_query =
exclude_query = [“SQLServerAvailabilityReplicaStates”, “SQLServerDatabaseReplicaStates”]
[agent]
interval = “10s”
round_interval = true
metric_batch_size = 1000
metric_buffer_limit = 10000
collection_jitter = “0s”
flush_interval = “10s”
flush_jitter = “0s”
precision = “”
hostname = “”
omit_hostname = false
[[outputs.influxdb_v2]]
urls = [“https://url.local:8086”]
token = “$INFLUX_TOKEN2”
organization = “ORG001”
bucket = “vmware”
[outputs.influxdb.tagpass]
** influxdb_database = [“VMware”]**
[[inputs.vsphere]]
[inputs.vmware.tags]
** influxdb_database = “VMware”**
vcenters = [ “h ttps://vcenter.local” ]
username = “pass@local”
password = “1q2w3e4r5t6t”
vm_metric_include = [
“cpu.demand.average”,
“cpu.idle.summation”,
“cpu.latency.average”,
“cpu.readiness.average”,
“cpu.ready.summation”,
“cpu.run.summation”,
“cpu.usagemhz.average”,
“cpu.used.summation”,
“cpu.wait.summation”,
“mem.active.average”,
“mem.granted.average”,
“mem.latency.average”,
“mem.swapin.average”,
“mem.swapinRate.average”,
“mem.swapout.average”,
“mem.swapoutRate.average”,
“mem.usage.average”,
“mem.vmmemctl.average”,
“net.bytesRx.average”,
“net.bytesTx.average”,
“net.droppedRx.summation”,
“net.droppedTx.summation”,
“net.usage.average”,
“power.power.average”,
“virtualDisk.numberReadAveraged.average”,
“virtualDisk.numberWriteAveraged.average”,
“virtualDisk.read.average”,
“virtualDisk.readOIO.latest”,
“virtualDisk.throughput.usage.average”,
“virtualDisk.totalReadLatency.average”,
“virtualDisk.totalWriteLatency.average”,
“virtualDisk.write.average”,
“virtualDisk.writeOIO.latest”,
“sys.uptime.latest”,
]
host_metric_include = [
“cpu.coreUtilization.average”,
“cpu.costop.summation”,
“cpu.demand.average”,
“cpu.idle.summation”,
“cpu.latency.average”,
“cpu.readiness.average”,
“cpu.ready.summation”,
“cpu.swapwait.summation”,
“cpu.usage.average”,
“cpu.usagemhz.average”,
“cpu.used.summation”,
“cpu.utilization.average”,
“cpu.wait.summation”,
“disk.deviceReadLatency.average”,
“disk.deviceWriteLatency.average”,
“disk.kernelReadLatency.average”,
“disk.kernelWriteLatency.average”,
“disk.numberReadAveraged.average”,
“disk.numberWriteAveraged.average”,
“disk.read.average”,
“disk.totalReadLatency.average”,
“disk.totalWriteLatency.average”,
“disk.write.average”,
“mem.active.average”,
“mem.latency.average”,
“mem.state.latest”,
“mem.swapin.average”,
“mem.swapinRate.average”,
“mem.swapout.average”,
“mem.swapoutRate.average”,
“mem.totalCapacity.average”,
“mem.usage.average”,
“mem.vmmemctl.average”,
“net.bytesRx.average”,
“net.bytesTx.average”,
“net.droppedRx.summation”,
“net.droppedTx.summation”,
“net.errorsRx.summation”,
“net.errorsTx.summation”,
“net.usage.average”,
“power.power.average”,
“storageAdapter.numberReadAveraged.average”,
“storageAdapter.numberWriteAveraged.average”,
“storageAdapter.read.average”,
“storageAdapter.write.average”,
“sys.uptime.latest”,
]
datacenter_metric_include =
datacenter_metric_exclude = [ “*” ]
insecure_skip_verify = false
That does look like one way to approach this.
