In the Help files, following note is made wrt using MySQL for central database offload:
For DataMiner versions up to DataMiner 9.6.5, MySQL versions 4.1.1 to 5.7 are supported (using connector version 5.2.7). From DataMiner 9.6.5 onwards, versions up to 8.0 (8.0 not included) are supported (using connector version 6.9.12).
I was wondering if version 8.0 is still not supported in the latest main/feature releases of DataMiner, and if so, why exactly that is?
Reason for asking is that MySQL 5.7 goes end-of-life in 2023
Hi Ruben,
We have tested this to use MySQL as an offload database (and only as offload database) and it's possible to use MySQL 8.0 for this.
To do so you need to change a setting within your MySQL:
SET GLOBAL local_infile=1;
As from MySQL 8.0 this setting has been changed to a default value of 0 causing an issue. By setting this everything should work.
Changes have also been pushed in to the help and should be visible soon.
Ruben
Please see DataMiner supported versions of MySQL server - DataMiner Dojo and see whether this information helps. Looks like we are not supporting version 8.0 as this is breaking features and also it's not fully tested.
Knowing that the MySQL support is coming to end of Life in Q4 2022, is there a value in exploring this compatibility? May be it's time for Cassandra migration.
Thanks.
Surely time for Cassandra 🙂 I’m glad we did it, Srikanth
(and ElasticSearch where possible)
Cassandra isn’t there for Offload though:
the offload use-case supports the 3 types of DB in the link below, not aware of any NoSQL to NoSQL scenario just yet – and not sure that would be required in the short term, as the offload is mainly a way to export from the local DBs of the cluster all the (required) data (mined by dataminer) into an external DB, designed to exchange data with other applications: so historically, when Cassandra was adopted, the MySQL offload was kept to preserve the compatibility of the data exchanged with other applications that might not necessarily be adapted to NoSQL. Where the offload is enabled, there’s a DLL writing data in a format that the destination DB can accept.
Not an answer to your question, but I used to run MySQL 8 with my local DMA and found that DELT was broken. If you need DELT I wouldn’t upgrade