- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Migrate cloudera manager database in CDH-6.3.x cluster from MySQL to external postgresql database
Created on 10-01-2021 10:38 PM - edited 09-16-2022 07:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created 10-06-2021 07:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.