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.
Converting to MySQL point value concern
-
Hi folks, thanks for your help with this. If i'm using MySQL, can I still use the NoSQL module as well?
Just finding that whilst doing a convert of the H2 database. Mango then proceeded to spend 5 hours migrating all of the point values to my MySQL instance. I'm happy with NoSQL, just not the occasional errors/notices I got with H2.
Just I cannot tell if mango is using the NoSQL database or if it's putting everything in MySQL by default.Thanks!
Fox
-
Yes, you can use NoSQL with MySQL. You probably had started your system without the NoSQL module and then migrated to it. The migration process does not delete the pointValues table so when you converted to MySQL there must have been a bunch of old data in the pointValues table.
-
Strange, since the NoSQL module is installed and enabled...
So are you saying I should do the H2 to Mysql convert separately, then shut down and move the nosql data in place then boot up again to avoid the painful delayed import process? -
You do not need to touch your NoSQL database in the conversion process. This instance ran without NoSQL and your pointValues table in your SQL data must have gotten data written to it. So, if you've already migrated that into the NoSQL database using the tools on the /mango_no_sql.shtm page then you can safely delete all the values from the pointValues SQL table as you are not using it if NoSQL is installed and running. In /sqlConsole.shtm,
delete from pointValues;will delete any values in the SQL database's pointValues table. That should speed that up. -
Right gotcha, thanks gentlemen!
