question Re: MySQL 5.7 Support? in Support Questions

MySQL 5.7 Support?

Matthew_Sharp — Fri, 16 Sep 2022 09:51:38 GMT

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?

Re: MySQL 5.7 Support?

nsabharwal — Tue, 08 Dec 2015 03:35:21 GMT

@Matthew Sharp

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

5.6 is the latest.

@jeff

Re: MySQL 5.7 Support?

jstraub — Tue, 08 Dec 2015 03:52:23 GMT

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.

Re: MySQL 5.7 Support?

deepesh1 — Tue, 08 Dec 2015 03:59:16 GMT

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.

Re: MySQL 5.7 Support?

nsabharwal — Tue, 08 Dec 2015 04:05:53 GMT

@Jonas Straub @Matthew Sharp

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

Re: MySQL 5.7 Support?

jstraub — Tue, 08 Dec 2015 04:18:27 GMT

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

Re: MySQL 5.7 Support?

bdurai — Tue, 08 Dec 2015 09:45:25 GMT

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

Re: MySQL 5.7 Support?

orlandoteixeira — Tue, 08 Dec 2015 20:54:38 GMT

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.

Re: MySQL 5.7 Support?

EddyWhite — Tue, 11 Jul 2017 07:30:32 GMT

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?