Ignition 7.8 with mysql 5.7?

Ignition
1

MySQL 5.7 is available, does anybody already run some test with ignition 7.8 ?
mysql-connector-java-XXXX-bin.jar installed with next ignition release will support mysql 5.7 ?

MySQL Connector/J 5.1.37 is suitable for mysql 5.5, 5.6 and 5.7
https://dev.mysql.com/doc/relnotes/connector-j/en/news-5-1-37.html

2

I don’t believe we bundled 5.1.37 with 7.8. However, it’s straight-forward to install different versions yourself through the Gateway via the Database > Drivers page.

3

I’m in testing phase with this now. MySQL 5.7.9 worked as expected with 7.75, just updated to 7.8.0 in my test environment and looks good so far.

My pain was updating mysql from 5.5 to 5.7

I’ll update on how it all goes when we go live.

4

7.8 Is running quite well with MySQL 5.7.9

Biggest issue was Tuning MySQL.

Couple pointers:

Don’t use BIT Variables in MySQL. Ignition prior to 7.8 read them fine. 7.8 does not decipher BITs.
MySQL performance is very slow with Latin1 Character Sets. Use UTF8. UTF8 is the default for MySQL 5.7.9 and was Default Latin1 for 5.5. Lots of issues just migrating due to this as well.

Hope that helps. Good luck.

5

Trying it out now. However, its been a while with the ports and the connections.