I am installing a new HDP 2.3 cluster and Hive and several other services will be using mysql as seen in the customize services section.
Will the ambari setup install mysql? or do i have to install mysql on each server before continuing with the installation?
@Ahmad Debbas Yes, the automated install will install mysql as part of the installation. Please see this doc for more information on what databases are installed as part of the ambari installation: http://docs.hortonworks.com/HDPDocuments/Ambari-220.127.116.11/bk_Installing_HDP_AMB/content/_database_requ...
To be more specific, as shown in the doc, by default the Ambari automated installation will install a Postgres DB for Ambari, a mysql DB for Hive, and a Derby DB for Oozie. If you want to back Ambari with mysql, the information provided above by Sri is helpful. If you want to go with the default installation DB's, after installation you can configure Ranger or Oozie with mysql as the DB.
Postgres is delivered with HDP as the derby database if you want to use Oracle,MariaDB,MySQL or MS SQL then you have to manually install them. This is to response to your question or doubt in an earlier post. That said Derby databases are not recommended for UAT or production
Having diffrenet databases for different components
Gives you a big management overhead if you intend to script and automate some processes, my 20 cents advise start allover with MariaDB [ opensource spinoff of MySQL] or MySQL db some licensing to factor in for all components inproduction etc
Yes. Ambari will download the mysql. For example if you are installing HIVE service and going to select mysql database for hive then ambari will download mysql package for HIVE service. Same for other services.
You have to install DDL before setting up the Ambari
To set up MySQL for use with Ambari:
yum install mysql-connector-java
zypper install mysql-connector-java
.jaris in the Java share directory.
# mysql -u root -p
CREATE USER '<AMBARIUSER>'@'%' IDENTIFIED BY '<AMBARIPASSWORD>';
GRANT ALL PRIVILEGES ON *.* TO '<AMBARIUSER>'@'%';
CREATE USER '<AMBARIUSER>'@'localhost' IDENTIFIED BY '<AMBARIPASSWORD>';
GRANT ALL PRIVILEGES ON *.* TO '<AMBARIUSER>'@'localhost';
CREATE USER '<AMBARIUSER>'@'<AMBARISERVERFQDN>' IDENTIFIED BY '<AMBARIPASSWORD>';
GRANT ALL PRIVILEGES ON *.* TO '<AMBARIUSER>'@'<AMBARISERVERFQDN>';
<AMBARIUSER>is the Ambari user name,
<AMBARIPASSWORD>is the Ambari user password and
<AMBARISERVERFQDN>is the Fully Qualified Domain Name of the Ambari Server host.
mysql -u <AMBARIUSER> -p
Ambari-DDL-MySQL-CREATE.sql file in the
/var/lib/ambari-server/resources/ directory of the Ambari Server host after you have installed Ambari Server.
Advanced Database Configuration > Option  MySQLand enter the credentials you defined in Step 2. for user name, password and database name.
Please follow as shown in the link https://docs.hortonworks.com/HDPDocuments/Ambari-18.104.22.168/bk_ambari_reference_guide/content/_using_am...