MySQL HA for Cloudera CDP Provate Cloud Base Databases

[#1]

Hi,

we would like to activate HA for Cloudera CDP MySQL databases (hive, ranger, etc..).
We have seen that there are several ways to achieve all this, mysql replication active-slave or active-active, mysql + DRDB, mysql Innodb Cluster, etc..
Our goal is to achieve automatic failover of mysql, with functionality similar to those of a cluster with an active node and a standy node.

From your experience, is there a recommended architecture for creating HA for a Mysql server compatible with Cloudera services? I read that some solutions could not be compatibile with Hive metastore for example.

Thanks in advance.
Ivo

[#2 · Accepted solution]

Cloudera's official statement on this subject can be found here. 

Cloudera supports various RDBMS options, each of which have multiple possible strategies to implement HA. Cloudera cannot reasonably test and certify on each strategy for each RDBMS. Cloudera expects HA solutions for RDBMS to be transparent to Cloudera software, and therefore are not supported and debugged by Cloudera. It is the responsibility of the customer to provision, configure, and manage the RDBMS HA deployment, so that Cloudera software behaves as it would when interfacing with a single, non-HA service.