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

Using Oozie with MySQL/MariaDB

To set up MySQL/MariaDB for use with Oozie:

Steps

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

    1. Download the MySQL Connector/JDBC driver from MySQL.

    2. On the Ambari Server host run:

      ambari-server setup --jdbc-db=mysql --jdbc-driver=/path/to/mysql/mysql-connector-java.jar
    3. Confirm that mysql-connector-java.jar is in the Java share directory.

      ls /usr/share/java/mysql-connector-java.jar 
    4. Make sure the .jar file has the appropriate permissions - 644.

    5. 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.