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

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

chandanar — Fri, 16 Sep 2022 14:40:25 GMT

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

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

GangWar — Mon, 08 Feb 2021 19:08:41 GMT

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

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

chandanar — Tue, 09 Feb 2021 13:06:07 GMT

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