Silver ⭐️⭐️

Solved

mysql upgrade post OS upgrade to RHEL 8

5 replies
2121 views
Translate All

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.

Cloudera

upadhyayk04Answer

Gold ⭐️⭐️⭐️

Hello @hshaikh

I see your current CM version is compatible with MySQL 8.4 and 8.0, so you should be good in any of the cases

https://supportmatrix.cloudera.com/

You could upgrade the DB first and ensure that CM is running fine with all the services, and then go ahead with the OS upgrade

Let me know if you have any queries

Please help our community grow. If you found any of the suggestions/solutions provided helped you with solving your issue or answering your question, please take a moment to login and click "Accept as Solution" on one or more of them that helped.

DianaTorres

Community Manager

@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.

Translate

Regards, Diana Torres, Senior Community Moderator

upadhyayk04

Gold ⭐️⭐️⭐️

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.html

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

Translate

hshaikhAuthor

Silver ⭐️⭐️

@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.

Translate

upadhyayk04Answer

Gold ⭐️⭐️⭐️

Hello @hshaikh

I see your current CM version is compatible with MySQL 8.4 and 8.0, so you should be good in any of the cases

https://supportmatrix.cloudera.com/

You could upgrade the DB first and ensure that CM is running fine with all the services, and then go ahead with the OS upgrade

Let me know if you have any queries

Please help our community grow. If you found any of the suggestions/solutions provided helped you with solving your issue or answering your question, please take a moment to login and click "Accept as Solution" on one or more of them that helped.

Translate

VidyaSargur

Community Manager

@hshaikh, Did the response assist in resolving your query? If it did, kindly mark the relevant reply as the solution to help others find the answer more easily in the future.

Translate

Regards, Vidya Sargur, Community Manager Was your question answered? Make sure to mark the answer as the accepted solution. If you find a reply useful, say thanks by clicking on the thumbs up button.

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.