Migrate MySql Databases (metastore, hue, cm, etc...) used in CDH 5.16 to another MySql DB

[#1]

Hi All, I need to migrate existing MySql DBs used for metastore, cmserver, amon, rman, oozie, hue and sentry to another MySql DB instance (MySql version 5.5). We are using CDH 5.16 and it contains 300TB data. Migration need to be done smoothly with less interruption to production workload. Appreciate if you can share the instructions/ related documents to do this. 

Thank you

[#2 · Accepted solution]

@chandanar This thread will give you some useful information around this topic. 

https://community.cloudera.com/t5/Support-Questions/Cloudera-cluster-impact-of-Mysql-RDS-5-6-to-5-7-...

Also the doc for reference : https://docs.cloudera.com/documentation/enterprise/5-16-x/topics/cm_ag_migrate_postgres_db_to_oracle...

The thing is you have to make DB backup and while restoring the DB you have to make sure that respective db.properties file is rightly pointing to new DB to work smoothly. 

[#3]

Thank you very much @GangWar I'll follow the instructions in shared docs.