According to the DataMiner Installation Guide, when we choose to MySQL the installer installs version 5.5. However, the latest MySQL version is 8.0.
What is the latest version supported by DataMiner 10.1.0 ?
Is it recommended to upgrade to a newer version?
Around 2 years ago, I have tried running DataMiner on MySQL 5.7 but noticed some issues regarding DELT. Internally we only test version 5.5 so I would not recommend upgrading to an untested version.
I briefly tested running my local DMA on a default MySQL 8 today and noticed DELT exporting an element failed with:
The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
After disabling the secure-file-priv setting in the my.ini file & restarting the MySQL service DELT works again. Note disabling this brings security risks!
secure-file-priv=""
I also saw my alarms/param values are gone after restarting an element in alarm so it looks like parameters are not correctly stored in MySQL 8. Looking in the tables I saw the info/alarm tables are empty while they clearly shouldn't be so I think we can confidently say MySQL 8 is not supported.