NetXMS Support Forum

Please login or register.

Login with username, password and session length

Author Topic: Timescale DB  (Read 260 times)

gmonk63

  • Full Member
  • ***
  • Posts: 124
    • View Profile
Timescale DB
« on: July 04, 2019, 07:51:28 pm »

If I want to migrate from Mysql to Timescale is there any way to import the data from mysql ?  By the way awesome choice :)  I always thought timeseries databases where better suited for NMS's   


Thanks
Logged

Tursiops

  • Sr. Member
  • ****
  • Posts: 423
    • View Profile
Re: Timescale DB
« Reply #1 on: July 05, 2019, 01:27:59 am »

The NetXMS database schema is different for TimescaleDB (even from Postgres -> TimescaleDB), so you'd have to use nxdbmgr for the migration. It's meant to support migration to TimescaleDB from 2.2.14 onwards (haven't tried it yet, we're still running load tests and comparisons between TimescaleDB and Postgres, feeding 50-60GB of live data into each system per day to compare performance).
One thing to note on TimescaleDB use, from what I can tell NetXMS configures the Hypertables with a 1 week chunk interval by default. Depending on your data ingestion rate, you may want to change that before you go live (e.g. for our test, I changed it to 1 day).
Logged

paul

  • Full Member
  • ***
  • Posts: 102
    • View Profile
Re: Timescale DB
« Reply #2 on: July 07, 2019, 03:25:46 am »

Out of curiosity - which version of Timescale are being considered being used - Open Source, community or Enterprise?
Logged

Tursiops

  • Sr. Member
  • ****
  • Posts: 423
    • View Profile
Re: Timescale DB
« Reply #3 on: July 07, 2019, 07:26:20 am »

We went with the packages for the community edition. Enterprise is not something we're considering at our end at this stage, but other NetXMS users might?
Logged

gmonk63

  • Full Member
  • ***
  • Posts: 124
    • View Profile
Re: Timescale DB
« Reply #4 on: July 09, 2019, 12:39:01 am »

Great  ;)  Thanks for the info
Logged