Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

HA (High Availability) of the database? (MySQL, MariaDB, PostgreSQL)

HA (High Availability) of the database? (MySQL, MariaDB, PostgreSQL)

Which HA (High Availability) mechanisms does HDP (Ambari, Hive, Ranger, Oozie) support for the database which the services are backed by (MySQL, MariaDB & PostgreSQL)?

I've heard that MySQL HA & PostgreSQL HA are not supported, but not seen anything official.

What about Galera, Percona XtraDB Cluster, MySQL MHA, ... and/or proxy mechanisms such as ProxySQL?

1 REPLY 1
Highlighted

Re: HA (High Availability) of the database? (MySQL, MariaDB, PostgreSQL)

Expert Contributor

Sean, I would suggest using the HA methods prescribed by the RDBMS vendor. If setup according to the DB that Hortonworks supports, then I see no reason why we wouldn't support HA for MySQL, Postgres, or Oracle with their respective services.