Reply
Explorer
Posts: 14
Registered: ‎03-15-2016

Can I move Management services to use an external db but keep Hive Metastore on the embedded db ?

Hello

 

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 ?

 

Thank you

 

Guy

Posts: 343
Topics: 11
Kudos: 51
Solutions: 29
Registered: ‎09-02-2016

Re: Can I move Management services to use an external db but keep Hive Metastore on the embedded db

@ni4ni

 

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

Explorer
Posts: 14
Registered: ‎03-15-2016

Re: Can I move Management services to use an external db but keep Hive Metastore on the embedded db

[ Edited ]

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

 

Thanks

 

Guy

Explorer
Posts: 20
Registered: ‎05-02-2017

Re: Can I move Management services to use an external db but keep Hive Metastore on the embedded db

@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  

Highlighted
Explorer
Posts: 14
Registered: ‎03-15-2016

Re: Can I move Management services to use an external db but keep Hive Metastore on the embedded db

Hi


I was actually using Oracle, not MySQL but I guess the path is the same. I put the jdbc driver in/usr/share/java and renamed it to oracle-connector-java.jar


Guy
Announcements