Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.
Migrating NoSQL data store license from one Mango instance to another
-
Hi All,
We would like to transfer the nosql data store module license from a mango instance running on machine (A) to mango running on machine (B) . Machine (A) is does not require speedy statistics and point value results, unlike machine (B) which incorporates the dashboard module and needs faster API query response times. We need to restore data already in the nosql store on (A) back into a sql data store on (A) - so historic data can still be referenced in Mango (and DGLux).
Machine (A) is using mango core 2.5.2
Machine (B) is running mango core 2.7.10Steps
-
read data out of nosql db on (A) and load into PointValues table on (A)
-
count the rows in the h2 embedded pointvalues table on (A). If the row count is the same as the nosql store, disable the nosql module on (A)
-
enable the nosql module on (B)
-
go to portal and associate nosql license with (B) instead of (A), so regular shutdown no longer triggers
-
import data from PointValues table in (B) into new nosql backend structure on (B)
Questions:
Q1. Is there a simpler process?
Q2. For Step 1 above, Is there a guide for migrating from data in nosql back into the embedded H2 pointvalues table?
Have reviewed the database conversion doc here, but it doesn't mention how to move from point values stored in the NoSQL module back into H2 (or another db):
https://help.infiniteautomation.com/support/solutions/articles/14000022650-database-conversions
Q3. For Step 2 above, if we disable the nosql module first, can we still read the data out to migrate into the h2 embedded? This would allow data arriving in the meantime to flow into the pointvalues table. Alternately we could disable the publishers while the migration is taking place, and re-enable and sync when the migration is complete.
Cheers,
Tim -
-
You can transfer the license but there is currently no way to convert a NoSQL database back to a SQL database. This would be a pretty easy feature for us to add so we'll consider that for the future.
