Community Articles

Find and share helpful community-sourced technical articles.
Announcements
Celebrating as our community reaches 100,000 members! Thank you!
Labels (1)
avatar

Currently Ambari (as of 2.1.2.1) does not support Postgres HA.

2,214 Views
0 Kudos
Comments
avatar

Does Ambari supports MySQL HA, I think Ambari HA is not officially documented or supported currently. But it can be achieved by having two different Ambari Server instances pointing to Active Active DB replication setup for MySQL/Postgres.

avatar

Pardeep, we do not currently support MySQL HA, and it is my understanding going forward that MySQL is going away (from the distros of linux), so you would have to add it manually.

avatar
Contributor

If you want a Postgresql HA for your Ambari and the other components like Ranger, Hive, Oozie, you have to use an external postgresql database, not the embeded.

In front of your Postgresql HA, use a connection pooler like pgbouncer or pgpool, so you will reduce the impact of opening a client connection to the database by keeping sessions open between the connection pooler and the database.