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.

Hive Metastore HA --- MySQL Replication for Failover Protection

Solved Go to solution
Highlighted

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

Accepted Solutions

Re: Hive Metastore HA --- MySQL Replication for Failover Protection

@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

3 REPLIES 3

Re: Hive Metastore HA --- MySQL Replication for Failover Protection

@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

Re: Hive Metastore HA --- MySQL Replication for Failover Protection

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.

Re: Hive Metastore HA --- MySQL Replication for Failover Protection

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.

Don't have an account?
Coming from Hortonworks? Activate your account here