Ambari Reference Guide
Also available as:
PDF
loading table of contents...

Using Ambari with MySQL

To set up MySQL for use with Ambari:

  1. On the Ambari Server host, install the connector.

    1. Install the connector

      RHEL/CentOS/Oracle Linux

      yum install mysql-connector-java

      SLES

      zypper install mysql-connector-java

      Debian/Ubuntu

      apt-get install libmysql-java

    2. Confirm that .jar is in the Java share directory.

      ls /usr/share/java/mysql-connector-java.jar

    3. Make sure the .jar file has the appropriate permissions - 644.

  2. Create a user for Ambari and grant it permissions.

    • For example, using the MySQL database admin utility:

      # 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>';

      FLUSH PRIVILEGES;

    • Where <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.

  3. Load the Ambari Server database schema.

    • You must pre-load the Ambari database schema into your MySQL database using the schema script.

      mysql -u <AMBARIUSER> -p

      CREATE DATABASE <AMBARIDATABASE>;

      USE <AMBARIDATABASE>;

      SOURCE Ambari-DDL-MySQL-CREATE.sql;

    • Where <AMBARIUSER> is the Ambari user name and <AMBARIDATABASE> is the Ambari database name.

      Find the 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.

  4. When setting up the Ambari Server, select Advanced Database Configuration > Option [3] MySQL and enter the credentials you defined in Step 2. for user name, password and database name.