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!
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.
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.