MySQL 5.7 Support?

[#1]

I was reviewing the HWX documentation around supported databases and was trying to find out if MySQL 5.7 is supported. The database matrix shows '5.x' and the minimum requirements documentation for HDP 2.3 calls out 5.6. I am assuming that means 5.6 is the latest, but wanted to know if others are using 5.7 or have heard anything on when that may be added?

[#2]

@Matthew Sharp

Based on the latest docs http://docs.hortonworks.com/HDPDocuments/Ambari-2.1.2.1/bk_Installing_HDP_AMB/content/_database_requ...

5.6 is the latest.

@jeff

[#3]

@Jonas Straub @Matthew Sharp

5.7 works but I don't think that its official supported.

[#4]

Thats true, I was talking about compatibility not support. Let me ping our colleagues from support and see what they say 🙂

[#5]

I think I have used MySQL 5.7 for a couple of my test clusters (at least for ambari), I cant remember any issues though. @jeff might know more

Make sure 5.7 is supported by your OS, some RedHat versions ship an older MySql version and have problems with the newest ones.

[#6]

I can tell you that for our System Testing we certify MySQL 5.6 which is what the documents as pointed out by @Neeraj Sabharwal say.

[#7]

I have found issues when you are using the latest MySQL 5.7 with Ranger. To work around, you need to do the following in /etc/my.cnf

show_compatibility_56 = on

explicit_defaults_for_timestamp

[#8 · Accepted solution]

So the official support answer, as per the doc listed above is NO. We support 5.6, but not 5.7. It has issues with at least Ranger, and has not been tested at all. I would think the heavier the cluster is used the more you would find it non-compatible with. Please use the supported version.

[#9]

I know this is an old post. However, I did send out a support inquiry as to WHEN 5.7 will be supported and got the response that it was being tested for Ambari v2.5. That was very early this year. There are various vulnerabilities identified by Oracle related to not running higher than 5.7.11. In particular, the vulnerabilities cover: MySQL Server 5.6.29 and earlier, 5.7.11 and earlier. There are no workarounds or alternatives for this issue...Not good.

I am referring to Oracle Support Note 2120034.1 for the preferred solution. This issue was identified by our security team in May 2016. So, my question is this. WHEN will 5.7.11+ be supported?