# Ignition 7.8 with mysql 5.7?

**URL:** <https://forum.inductiveautomation.com/t/ignition-7-8-with-mysql-5-7/10661>\
**Category:** Ignition\
**Created:** [October 24, 2015, 11:58am UTC](https://forum.inductiveautomation.com/t/ignition-7-8-with-mysql-5-7/10661 "2015-10-24T11:58:55Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![mazeyrat](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mazeyrat/32/10955_2.png) [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\
**Post date:** [October 24, 2015, 11:58am UTC](https://forum.inductiveautomation.com/t/ignition-7-8-with-mysql-5-7/10661/1 "2015-10-24T11:58:55Z")

</div>

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](https://dev.mysql.com/doc/relnotes/connector-j/en/news-5-1-37.html)

---

<div class="post-metadata">

**Author:** ![PerryAJ](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/perryaj/32/3281_2.png) [@PerryAJ](https://forum.inductiveautomation.com/u/PerryAJ)\
**Post date:** [October 26, 2015, 4:08pm UTC](https://forum.inductiveautomation.com/t/ignition-7-8-with-mysql-5-7/10661/2 "2015-10-26T16:08:36Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![jimmylooo](https://avatars.discourse-cdn.com/v4/letter/j/f9ae1b/32.png) [@jimmylooo](https://forum.inductiveautomation.com/u/jimmylooo)\
**Post date:** [October 30, 2015, 3:39pm UTC](https://forum.inductiveautomation.com/t/ignition-7-8-with-mysql-5-7/10661/3 "2015-10-30T15:39:45Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![jimmylooo](https://avatars.discourse-cdn.com/v4/letter/j/f9ae1b/32.png) [@jimmylooo](https://forum.inductiveautomation.com/u/jimmylooo)\
**Post date:** [November 16, 2015, 6:07pm UTC](https://forum.inductiveautomation.com/t/ignition-7-8-with-mysql-5-7/10661/4 "2015-11-16T18:07:08Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Tobey](https://avatars.discourse-cdn.com/v4/letter/t/34f0e0/32.png) [@Tobey](https://forum.inductiveautomation.com/u/Tobey)\
**Post date:** [February 17, 2016, 9:25pm UTC](https://forum.inductiveautomation.com/t/ignition-7-8-with-mysql-5-7/10661/5 "2016-02-17T21:25:30Z")

</div>

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