upgrade mysql 5.6.x to mysql 5.6.30/5.6.31

[#1]

We are using HDP2.2. stack and by default mysql 5.6.x has been bundled. The security team assessment report shows that there are vulnerabilities in mysql 5.6 and the remedy of the issue could be upgrade mysql 5.6.30 or above. I am not sure how to upgrade mysql alone in HDP 2.2 and would be good if any one have such experience of upgrading mysql 5.6.x to 5.6.30 or above. Please reply.

[#2 · Accepted solution]

You should take a database dump of the various backend stores like Hive, Oozie, Ranger before the upgrade, see instructions here. This way after upgrade of MySQL if you run into issues you still have your backup database dumps.

[#3]

Thanks Deepesh for your immense response.