Getting very strange results when setting up telegraf to send to multiple databases.
It seems that if 2 services are writing at the exact same time they will cross write information to both databases. Sometimes only including “some” of the fields, sometimes including all the fields of the other measurements. This will result in a measurement having a bunch of empty or weirdly populated columns when you do queries.
I’ve setup my outputs to look like this… writing everything to 1 database and namespacing measurements seems to work fine but we would prefer to have some services write to different databases.
[[outputs.influxdb]]
urls = ["https://xxxx.influxcloud.net:8086"]
database = "xxxx"
username = "xxxx"
password = "xxxx"
[outputs.influxdb.tagpass]
sometag1 = ["tag1val"]
[[outputs.influxdb]]
urls = ["https://xxxx.influxcloud.net:8086"]
database = "yyyy"
username = "yyyy"
password = "yyyy"
[outputs.influxdb.tagpass]
sometag2 = ["tag2val"]
If services are not writing to telegraf at the same time there is no issue. But it seems like sometimes the data will be merged together and have the needed tag to be accepted into both the databases.