Skip to main content
chandanar
chandanar
Silver ⭐️
February 8, 2021
Solved

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

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

GangWar
GangWarAnswer
Platinum ⭐️⭐️
February 8, 2021

@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-Upgrade/m-p/310982#M224394

 

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

 

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. 

Cheers! 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.
View in thread

2 replies

GangWar
Platinum ⭐️⭐️
GangWarAnswer
Platinum ⭐️⭐️
February 8, 2021

@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-Upgrade/m-p/310982#M224394

 

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

 

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. 

Translate
Cheers! 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.
    chandanar
    chandanarAuthor
    Silver ⭐️
    February 9, 2021

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

     

    Translate
    Terms & ConditionsAccessibility statement