07-16-2017 05:05 AM
I have a CDH 5.11 cluster that was configured to use embedded PostgreSQL.
I want to migrate Cloudera management services to an external Oracle database as a first step, and later also migrate Hive Metastore to that external database.
I migrated Cloudera management services to the new external database and they work just fine, but now Hive Metastore is not available, I guess it's because it was on the same local PostgreSQL that is now down after the migration.
Whenever I try to start it I get this message:
service cloudera-scm-server-db start
CM is using external DB. Failed to start embedded DB service, giving up
I was not planning to migrate Management services and Hive Metastore in one pass, is there a way to move Management services to an external database and keep Hive Metastore working on the old embedded server ?
07-16-2017 09:19 AM
Yes, you can configure different services to different db by setting up configuration
I cannot write the exact configuration property here as I cannot access my cluster now, but you can try switching some properties like
From hive configruation, ConnectionDriverName to to your db (ex: com.mysql.jdbc.diver), changes may required in few more configruations
Similar changes required in CM Services configruation
07-16-2017 11:39 AM - edited 07-16-2017 01:04 PM
Hello and thanks for your reply.
What I want is to leave Hive Metastore on the local PostgreSQL and it does'nt seem to be available anymore after I moved Management services to Oracle.
I get an error message every time I try to start it (see my original post).
07-16-2017 07:43 PM
@ni4ni Mate while configuring External Database for the CM service could you please let me know where did you place the MYSQL jdbc jar ? I am stuck in the middle of Installation
07-16-2017 08:41 PM