Use multiples InfluxDB backends is recomended?
Posted: Wed Jul 27, 2022 4:56 pm
Hello everyone,
We are testing diferents ways to implementate our influxDB infraestructure on WinCCOA 3.17P12.
In our case, we have a complete production circle, and it means, really diferent data collections, not at all interconnected.
So, our question here is, is better store all the data in the same data base (backend), with diferents measurements (archive groups), or directly, create a diferent database (backends) for each production environment?
In terms of robustness, we prefer to separate each production environments data, in diferents databases (backends). But, in terms of performance, we are not sure if this is the correct way.
Testing to use a database for each production environment, we saw that when you active 25+ backends, the NGA manager crashes. (InfluxDB in localhost with each backend in 'in-proc' execution type)
Does it means that, use multiple backends is a bad practices? Is posible that, for each plugin process that winccoa creates, the performance is afected?
InfluxDB is completly new for us, and we are not sure how we have to use it in winccoa, to have the best performance and data robustness.
Thanks in advance!
We are testing diferents ways to implementate our influxDB infraestructure on WinCCOA 3.17P12.
In our case, we have a complete production circle, and it means, really diferent data collections, not at all interconnected.
So, our question here is, is better store all the data in the same data base (backend), with diferents measurements (archive groups), or directly, create a diferent database (backends) for each production environment?
In terms of robustness, we prefer to separate each production environments data, in diferents databases (backends). But, in terms of performance, we are not sure if this is the correct way.
Testing to use a database for each production environment, we saw that when you active 25+ backends, the NGA manager crashes. (InfluxDB in localhost with each backend in 'in-proc' execution type)
Does it means that, use multiple backends is a bad practices? Is posible that, for each plugin process that winccoa creates, the performance is afected?
InfluxDB is completly new for us, and we are not sure how we have to use it in winccoa, to have the best performance and data robustness.
Thanks in advance!