Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here. Want to know more about what has changed? Check out the Community News blog.

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

Highlighted

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

Explorer

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?

 

 

2 REPLIES 2

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

Community Manager

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

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

Explorer
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?