Reply
Explorer
Posts: 26
Registered: ‎07-09-2015

High Availability for Oracle Metastore Database for Cloudera Manager & CDH Services

We are planning to setup Cloudera 6.1.x Hadoop cluster spanning across two data centers. We are following "Cloudera Enterprise Reference Architecture for Bare Metal Deployments" and planned services distribution as mentioned in "Appendix A: Spanning Multiple Data Centers" section.

 

We also plan to have a node configured as both Edge Node & Cloudera Management Node. We will be using Oracle 12c as Metastore Database for Cloudera Manager & CDH Services and plan to install it on this Cloudera Management Node. We will also have additional Edge node on other data center.

 

How can we achieve High Availability for Oracle Metastore Database and not being a single point of failure?

 

 

Posts: 1,004
Kudos: 31
Solutions: 20
Registered: ‎05-27-2014

Re: High Availability for Oracle Metastore Database for Cloudera Manager & CDH Services

Hi @Anishsk10 ,

 

Please take a look at this doc:

https://www.cloudera.com/documentation/enterprise/6/latest/topics/admin_ha_hivemetastore.html

 

As the doc points out, please install each instance of the metastore on a separate cluster host, to maximize high availability. Also, Hive metastore HA requires a database that is also highly available, so make sure that your Oracle database is installed with replication in active-active mode. Refer to Oracle documentation to configure it correctly.

 

Thanks and hope this helps,

Li

Li Wang, Technical Resolution Manager


Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

Learn more about the Cloudera Community:

Terms of Service

Community Guidelines

How to use the forum

Highlighted
Explorer
Posts: 26
Registered: ‎07-09-2015

Re: High Availability for Oracle Metastore Database for Cloudera Manager & CDH Services

Hi LI Wang,

Thanks for the reply.

In the event of current Management Node failure having one of the instance of Metastore Database, is it possible to start another instance of Cloudera Manager on a separate cluster host using the configurations other instance of database?