Support Questions
Find answers, ask questions, and share your expertise

Hive Metastore HA --- MySQL Replication for Failover Protection

Solved Go to solution

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
Highlighted

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

View solution in original post

3 REPLIES 3
Highlighted

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

View solution in original post

Highlighted

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.

Highlighted

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?