Hive Metastore HA --- MySQL Replication for Failover Protection

[#1]

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!

[#2 · Accepted solution]

@[email protected]

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]

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.

[#4]

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.