I’m working on a deployment where, for purposes of initial sizing we are estimating 10,000 devices reporting once a second time stream data. Each device has a unique ID and we are retaining all 1 second data for 1 month, then rollups 1 / minute for 6 months. Generally I’m planning on 1 database and each series includes a tag which is the device unique identifier. With this amount of data does 1 database make sense (with the tag on unique id), or should I plan for a seperate database per device?
A secondary question, would a single telegraf instance typically be used to batch all these requests or should I look into multiple instances of this as well?
Thank you for any advice.