I have sensors on robots, they give me datas over time, it’s pretty clear i should use InfluxDB for that.
The files i receive however, contain a lot of informations / fields i need to store, that are not based on time.
station ip, station name, installation name, serial number, description, location, …
If i put all these informations as Fields, there will be a lot of repetition and a tremendous loss of space on disk.
If i put all these informations as Tags, i will have a very extended index, and the temendous loss will be on RAM.
So what should i do ?
What i plan to do :
Use influxDB for time based data, and another DBMS (MySQL or something) for the informations about the stations.
I would put 1 tag in influxDB, such as “Station_name” or “Station_id” , and use it to create my table in MySQL, then somehow i will do the link between MySQL and influxDB. Probably in my application before i display the datas.
This could work, but feels wrong. Is there a better solution ? Because that’s the only thing i can think of…