Apache Ambari Administration
Also available as:
PDF
loading table of contents...

Using Oozie with MySQL

To set up MySQL for use with Oozie:

Steps

  1. On the Ambari Server host, stage the appropriate MySQL connector for later deployment.

    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 mysql-connector-java.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.

    4. Execute the following command:

      ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar
  2. Create a user for Oozie and grant it permissions.

    • Using the MySQL database admin utility:

      # mysql -u root -p
      CREATE USER '<OOZIEUSER>'@'%' IDENTIFIED BY '<OOZIEPASSWORD>';
      GRANT ALL PRIVILEGES ON *.* TO '<OOZIEUSER>'@'%';
      FLUSH PRIVILEGES;
    • Where <OOZIEUSER> is the Oozie user name and <OOZIEPASSWORD> is the Oozie user password.

  3. Create the Oozie database.

    • The Oozie database must be created prior.

      # mysql -u root -p
      CREATE DATABASE <OOZIEDATABASE>

    • Where <OOZIEDATABASE> is the Oozie database name.