Does MySQL automatically get installed during the Ambari Cluster wizard setup?

[#1]

When I am going through the Ambari cluster setup wizard, and I get to the Hive section, do I need to have installed MySQL prior to running the wizard or will MySQL be installed for me as part of the installation. I had one person tell me I had to install it prior as one of the prereqs before running the Clustser setup wizard, but someone else told me it installs it as part of the wizard.

[#2]

@Rog Fe de Leon

From HDP 2.6.4, due to licensing issues mysql was removed. All the GPL licensed components will be removed from now. If you are using mysql for hive then you should install it by yourself.

"Installing and Configuring MySQL" : https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.4/bk_command-line-installation/content/meet-m...

Source Reference HCC thread: https://community.hortonworks.com/questions/161888/mysql-community-server-package-not-found-on-hdp-u...

.

If you want to know how to setup MySQL database for Hive then you can refer to the following doc: https://docs.hortonworks.com/HDPDocuments/Ambari-2.6.2.2/bk_ambari-administration/content/using_hive...

[#3]

@Rog Fe de Leon

So if you want to MySQL to be installed then you will need to make sure that your Host has the MySQL repository configured properly.

Even Ambari will no longer automatically install GPL licensed MySQL Connector/J. If using Ambari with MySQL, you must first download JDBC drivers and configure Ambari to use them.

https://docs.hortonworks.com/HDPDocuments/Ambari-2.6.1.0/bk_ambari-release-notes/content/ambari_reln...

[#4 · Accepted solution]

Hi @Rog Fe de Leon ,

If you select the new MYSQL database , ambari will install the mysql Packages. but it again depends on the operating systems you use. sometimes if the repo is not available it might fail too.

can you mention whats the operating system you are planning to install hive ?

additionaly some mannual steps you might need to perform too : https://docs.hortonworks.com/HDPDocuments/Ambari-2.6.2.2/bk_ambari-administration/content/using_hive...

[#5]

Thank you for the answers. I will play it safe and just pre install MYSQL. I am using CentOS7