question Re: Hive Metastore HA --- MySQL Replication for Failover Protection in Archives of Support Questions (Read Only)

Hive Metastore HA --- MySQL Replication for Failover Protection

rxu — Tue, 27 Oct 2015 07:06:11 GMT

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-failover.html 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_chap9.htmlIs it still applicable? --- we may have better instruction somewhere? Your help is greatly appreciated!

nsabharwal — Tue, 27 Oct 2015 07:08:46 GMT

@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

manirajv — Thu, 25 Aug 2016 19:25:32 GMT

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.

alex2013 — Wed, 31 Aug 2016 21:43:06 GMT

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