Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

MySQL HA for Cloudera CDP Provate Cloud Base Databases

avatar
Explorer

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

1 ACCEPTED SOLUTION

avatar
Super Collaborator

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.

View solution in original post

1 REPLY 1

avatar
Super Collaborator

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.