Hi, I am trying to setup Hortonworks Data Platform. I would want to setup Hive in high availability mode (both metastore and as well as HiveServer2). Along with that, Hortonworks recommendation is to backup the RDBMS behind Hive service.
Can anyone please let me know what is the best practice around this? As, by default, Hive uses MySQL, please advise me on the best way to achieve high availability for all the Hive components. Many Thanks