Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

Hive Metastore HA --- MySQL Replication for Failover Protection

Contributor

We are helping client to set up Hive Metastore HA following: http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.2.8/bk_hadoop-ha/content/ha-hive-use-and-failove... It refers to a whitepaper "MySQL Replication for Failover Protection" that I can only find in old HDP 1.3 doc: http://private-repo-1.hortonworks.com/HDPDocuments/HDP1/HDP-1.3.3/bk_reference/content/reference_cha...Is it still applicable? --- we may have better instruction somewhere? Your help is greatly appreciated!

1 ACCEPTED SOLUTION

@rxu@hortonworks.com

It will Active-Passive setup

Very useful link

For Active-Active - You need mysql cluster and not good idea for Hive metastore because you have to create tables in special way for clustering

Autofailover

Mysql Cluster

View solution in original post

3 REPLIES 3

@rxu@hortonworks.com

It will Active-Passive setup

Very useful link

For Active-Active - You need mysql cluster and not good idea for Hive metastore because you have to create tables in special way for clustering

Autofailover

Mysql Cluster

New Contributor

Hi Neeraj,

MySQL Active Active is not recommended? Can you explain in detail?

I've done the set up in active active mode. Just curious to know the reasons.

New Contributor

Hey Manikandan ,

i think the problem is the GTID https://community.hortonworks.com/articles/48797/is-mysql-global-transaction-id-gtid-replication-co.... . Correct me if I'm wrong. If you have Active Active MySQL it will use GTID because its required by mysqlfailover.