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.
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