Support Questions
Find answers, ask questions, and share your expertise

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

New Contributor

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

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


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 solution in original post

2 REPLIES 2

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


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.

New Contributor

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

 

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.