Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

MySQL 5.7 Support?

Solved Go to solution
Highlighted

MySQL 5.7 Support?

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: MySQL 5.7 Support?

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.

View solution in original post

8 REPLIES 8
Highlighted

Re: MySQL 5.7 Support?

Highlighted

Re: MySQL 5.7 Support?

@Jonas Straub @Matthew Sharp

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

Highlighted

Re: MySQL 5.7 Support?

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

Highlighted

Re: MySQL 5.7 Support?

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.

Highlighted

Re: MySQL 5.7 Support?

Master Collaborator

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?

Contributor

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

Highlighted

Re: MySQL 5.7 Support?

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.

View solution in original post

Highlighted

Re: MySQL 5.7 Support?

Explorer

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?

Don't have an account?
Coming from Hortonworks? Activate your account here