Setting up a new Influxdb at work. This will be my first installation of the software and first venture into databases. The machine will be running influxdb, grafana and node red. All of these will be deployed using Docker. Also will be used for some excel work, mainly for organizing data into reports. Everything will be hosted on one machine and only that machine will be using the data. Below is probably as demanding as the database will get.
200 Field values/bucket
Updating once every 10 seconds.
Data stored for 2 years
Cardinality should be pretty slim as this will all be done through the modbus plugin.
For Querying I am probably looking at around 20-25/s max.
Looking at the hardware sizing It looks like I am thinking a 6-8 core xeon (W-1270p or similiar). I am thinking tis would be a little overkill. Probably will start with 16gb of ram as upgrading to 32 later on is easy enough. For storage, I am still trying to determine the exact space we need but was thinking something along of the lines 3x1tb in raid 5 would be a good starting point.
Is this a good starting point? This will be my first venture into databases and would prefer not to cause my self headaches by accidently under sizing the workstation.