Oozie MySQL Integration Configuration

Follow the following steps to integrate Oozie-3.3.2 with MySQL database:

1. Copy MySQL driver - mysql-connector-java-5.1.22-bin.jar into -

${OOZIE_HOME}/libext

${OOZIE_HOME}/distro/target/oozie-3.3.2-distro/oozie-3.3.2/libtools

${OOZIE_HOME}/distro/target/oozie-3.3.2-distro/oozie-3.3.2/lib

2. Prepare oozie.war file using the command -

${OOZIE_HOME}/distro/target/oozie-3.3.2-distro/oozie-3.3.2/bin/oozie-setup.sh prepare-war -jars -extjs ${OOZIE_HOME}/webapp/src/main/webapp/ext-2.2/ext-2.2.zip

3. Copy the oozie.war file into tomcat server -

$cp distro/target/oozie-3.3.2-distro/oozie-3.3.2/oozie-server/webapps/oozie.war webapp/src/main/webapp/oozie.war

4. Create schema - oozie in MySQL database.

5. Update oozie-site.xml in ${OOZIE_HOME}/distro/target/oozie-3.3.2-distro/oozie-3.3.2/conf/oozie-site.xml with relevant details as shown below -

6. Execute the following command -

${OOZIE_HOME}/distro/target/oozie-3.3.2-distro/oozie-3.3.2/bin/ooziedb.sh create -run DB Connection

Output should be -

------------------------------------------------------------

setting CATALINA_OPTS="$CATALINA_OPTS -Xmx1024m"

setting OOZIE_LOG=${OOZIE_HOME}/logs

setting OOZIE_LOG4J_FILE=oozie-log4j.properties

setting OOZIE_LOG4J_RELOAD=10

setting OOZIE_HTTP_PORT=11000

Validate DB Connection

DONE

Check DB schema does not exist

DONE

Check OOZIE_SYS table does not exist

DONE

Create SQL schema

DONE

Create OOZIE_SYS table

DONE

Oozie DB has been created for Oozie version '3.3.2'

------------------------------------------------------------

Following tables get created in oozie schema -

1.BUNDLE_ACTIONS

2.BUNDLE_JOBS

3.COORD_ACTIONS

4.COORD_JOBS

5.OOZIE_SYS

6.OPENJPA_SEQUENCE_TABLE

7.SLA_EVENTS

8.VALIDATE_CONN
9.WF_ACTIONS

10.WF_JOBS