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.
How long when use derby database for store data that the mango connect equipment?
-
If I choose the derby database ,how long how long when use derby database for store data that the mango connect equipment? if I choose mysql or postpresql, how to setting in mango in windows version.
-
Hi Edmond,
I don't really understand your question but I think I know what you are getting at and there is no set rule about how large to let a derby database get. It should be noted that the default database being used in Mango 2.4.2 is H2 which is much better than derby. I would say if your database is going to larger than a few GB then I would recommend going to MySQL. In general for most production implementations of Mango I would recomend using MySQL over derby.
Hope that helps.
Joel. -
Hi Joel:
if I choose mysql or postpresql, how to setting mango in windows version. have any step by step?
-
PostgresSQL is not an option for Mango. To configure mango for MySQL you do that in the /classes/env.properties file.
You need to create a blank database and user with full permissions to the database.
-
Yes .Thank JoelHaggars.
You are right. When I use bleow command .the covert db is ok.
grant all privileges on db.* To 'username'@'localhost' identified by 'password';