Migration from sql server to influxdb

[AB_9394087]

Hello,

My customer is today running THX 9.3.7 with SQL BDD.

The project has turned to a large amount of machine data storage and analysis.

We are, so, thinking about a move to a InfluxDB system.

Several questions are coming to us:

- Is the move to influxDB able to solve our performances issues? How to verify that it could be the good solution?

- In order to do this move, are there some existing procedure, REX, advises?

Best regards,

[Rocko · Accepted solution]

Existing procedures are documented this article https://www.ptc.com/en/support/article/CS323473 and in the Help Center: https://support.ptc.com/help/thingworx/platform/r9.6/en/#page/ThingWorx/Help/Composer/DataStorage/PersistenceProviders/PersistenceProviders.html#

Also read https://community.ptc.com/t5/IoT-Tips/15-FAQs-on-ThingWorx-with-InfluxDB/ta-p/818396 including the comments to get a better understanding of where InfluxDB can help.

No one can say if this solves your performance problems without knowing where those problems come from, but in general Influx can handle larger, time-series data well - better than a trad SQL DB. It will also give you a performance boost as it will take load off the SQL DB.

After you have verified your issues are with the DB, you can try with a test instance running e.g. Influx OSS to verify the system's behaviour after moving some data over there.

[AB_9394087]

Thank you for your feedback and for all this information.