question Re: Ambari installation prerequisite packages in Support Questions

Ambari installation prerequisite packages

bvishal — Wed, 23 Dec 2020 07:18:02 GMT

Hi eveyone,

Ambari :- 2.7.4.0

HDP :- 3.1.4.0

I want to know whether postgresql in addition to MYSQL ( I will be using MYSQL in advanced database configuration while setting up Ambari server as my choice ) is needed for Ambari ( 2.7.4 ) installation or not. If it is needed should I install it on both Ambari Server host and also Ambari Agent hosts or only Ambari Server host. On which hosts is it required?

Please help!

@KuldeepK @jsensharma @MattWho @Shelton

Re: Ambari installation prerequisite packages

youngick — Fri, 25 Dec 2020 00:32:46 GMT

Ambari installation requires either MySQL or postgresql. In general, you only need to install MySQL on the Ambari server host.

https://docs.cloudera.com/HDPDocuments/Ambari-2.7.5.0/administering-ambari/content/amb_using_ambari_with_mysql_or_mariadb.html

Re: Ambari installation prerequisite packages

Shelton — Sun, 03 Jan 2021 21:45:18 GMT

@bvishal

You don't really need to mix 2 different databases [Postresql and MySQL]. You can use MySQL or MariaDB free version of MYSQL in the advanced database configuration for you cluster. MySQL has the typical SQL syntax Postgresql is another world !

You don't need to install MySQL on the ambari agent hosts because that will mean if you have 20 nodes you will be running 20 MySQL/MariaDB databases.

Usually, you install the MySQL/MariaDB on the Ambari host and you create apart from Ambari database, hive,oozie, ranger,RangerKMS etc.

If you are deploying using Ambari then the ambari-agents are deployed automatically and configured by Ambari.

Was your question answered? If so make sure to mark the answer as the accepted solution.
If you find a reply useful, kudos this answer by hitting the thumbs up button.

Re: Ambari installation prerequisite packages

bvishal — Mon, 04 Jan 2021 08:21:17 GMT

Thanks @Shelton for your detailed answer!