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

Solved Go to solution

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

Accepted Solutions

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

@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

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

@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

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

New Contributor

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