mysql upgrade post OS upgrade to RHEL 8

[#1]

Hi Team,

We are on CDP 7.1.9 SP1 and on OS version RHEL 7. As RHEL 7 is EOL we are planning to upgrade to RHEL 8 and also mysql 5.7 to 8.  Since it is production environment we are little bit concerned how complex it would be. Our CM services and mysql database of cm and application are residing on the same node.

Kindly suggest apart from taking mysqldump backups and exporting the database/table what else we need to take care of post OS upgrade to rhel 8, I mean I am aware of re-installing el8 cm packages but for mysql we have to install from rpms of el8 so finding it little tricky.

[#2]

@hshaikh Welcome to the Cloudera Community!

To help you get the best possible solution, I have tagged our CDP experts @venkatsambath @abdulpasithali @upadhyayk04  who may be able to assist you further. 

Please keep us updated on your post, and we hope you find a satisfactory solution to your query.

[#3]

Hello @hshaikh 

Thank you for reaching out to the Cloudera Community

For upgrading the OS to a new major version please refer the below document from Cloudera

https://docs.cloudera.com/cdp-private-cloud-upgrade/latest/upgrade-cdp/topics/ug_major_os_upgrade.ht...

The above document will cover all the pre-reqs and backup part.

Regarding mysql upgrades I think you are already aware about the steps

Let me know if you have any further queries

[#4]

@upadhyayk04  thanks for the quick reply. I just have one doubt, hope you can help.

We are on mysql 5.7 version and on CM 7.11.3 base version, So should I first upgrade the mysql 5.7 to 8 and then proceed with OS upgrade to RHEL 8. If I can't then it won't be an inplace upgrade, I have to freshly install mysql 8 and then dump the back up databases. Is this a feasible way.