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

Migrate cloudera manager database in CDH-6.3.x cluster from MySQL to external postgresql database

New Contributor

We want to migrate cloudera manager and various cloudera service database in CDH-6.3.x cluster from MySQL to External postgresql database. 
Need help with the steps to perform the same. 

1 REPLY 1

Cloudera Employee

Hi @cloudera-a ,

 

Since the CM server ships with embedded PostgreSQL DB, our docs point to migrating from PSQL to MySQL or even Oracle, but not the other way around.

 

For instance, here's our doc to migrate from a PostgreSQL Database Server to a MySQL/Oracle Database Server [0].

 

You could make use of a 3rd party tool to achieve what you're trying to do, but this won't be encouraged by Cloudera, as this could easily lead to an unstable cluster.

 

[0] = Migrate from the Cloudera Manager External PostgreSQL Database Server to a MySQL/Oracle Database Ser...

; ;