Hello IA,
First of all, my service is running:
Mango Core: 3.6.6, Mango API: 3.6.4, Mango UI: 3.6.7, Platform: Centos 7.4.1708, Java Version: 1.8.0_161
I am trying to get everything in place to perform the latest Mango 3 upgrades. However it is like a line of dominoes. You state that we need to be using MySQL 5.7.8 at a minimum for the JSON data type. Our web server that is running Mango 3 is a Plesk web server which is using MariaDB by default. Up til now this has not been a problem and may not be a problem going forward but I need your advice.
Plesk only supports upto MariaDB 10.3. I checked if this is equivalent to MySQL 5.7.8 for the JSON data type and this is a quote from the MariaDB site:
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.
JSON is an alias for LONGTEXT introduced for compatibility reasons with MySQL's JSON data type. MariaDB implements this as a LONGTEXT rather, as the JSON data type contradicts the SQL standard, and MariaDB's benchmarks indicate that performance is at least equivalent.
In order to ensure that a a valid json document is inserted, the JSON_VALID function can be used as a CHECK constraint. This constraint is automatically included for types using the JSON alias from MariaDB 10.4.3.
Here is the link to their page for further reference: https://mariadb.com/kb/en/library/json-data-type/
In your opinion, will the upgrade work with my configuration of MariaDB 10.3? It sounds to me that it would and the differences are only noted for replication and export/imports.
My second question regarding the Mango 3 upgrade concerns the user email addresses. Our customers sometimes provide the Mango service to their customer. So we may have more than one user name to access a display page. But our customer is the only one I have contact with, so the other users are still referenced by the one customer email contact.
Would it be possible for me to change the "Unique" attribute in the database with out affecting the operation of Mango 3.7.1?
I need to know what to expect before I attempt the upgrade.
Thank you for your time.
Brian