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.

Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website

  • Hello Support,
    I am currently using Core 3.7.4 and it is running well for us. We are using Maria DB instead of MySQL and everything has been fine with the JSON statements as Maria DB is an equivalent database to MySQL. But I am a bit wary about the items in the recent core upgrades, primarily:

    Version 3.7.5
    Make upgrade on MySQL more robust as to abort if MySQL is not 5.7.8 or higher

    and also:

    Version 3.7.6
    If using a MySQL database Mango will only start on versions with JSON support which is 5.7.8 and above to ensure all upgrades and installation will work properly once the correct version is used

    Can you tell me if the use of our Maria DB 10.3.22 will cause our Mango service to fail because it is not strictly MySQL 5.7.8 after the upgrades?

    Cheers

    Brian


  • @bg said in Recent Core Upgrades:

    Maria DB 10.3.22

    A quick google provides us with this:

    What is JSON and why use it?

    JSON is fast becoming the standard format for data interchange and for unstructured data, and MariaDB Platform (in fact, all MariaDB versions 10.2 and later) include a range of JSON supporting functions. There are a few good reasons why a JSON datatype hasn’t been implemented, but one is that there are just not many advantages to that, as JSON is a text-based format. Here I’ll describe JSON and the use cases for it, as well as the MariaDB JSON functions and their uses. We’ll also look at some other MariaDB features that are useful for JSON processing..

    src: https://mariadb.com/resources/blog/json-with-mariadb-10-2/

    The JSON alias was added in MariaDB 10.2.7. This was done to make it possible to use JSON columns in statement based replication from MySQL to MariaDB and to make it possible for MariaDB to read mysqldumps from MySQL.
    https://mariadb.com/kb/en/json-data-type/

    You should be jammy - just remember to backup your mango directory pre-upgrade.

    Fox


  • Just a little further information on this. The Upgrade does a simple test by creating and dropping a table with a single column of type JSON to ensure Mango can upgrade, if that works it proceeds with the upgrade.

    Here is the SQL we use to test:

    CREATE TABLE mangoUpgrade28 (test JSON)engine=InnoDB; 
    DROP TABLE mangoUpgrade28;
    

  • Thanks guys for checking. I wasn't sure if the new core upgrade was checking the database name and version.

    Cheers

    Brian