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
9.WF_ACTIONS
10.WF_JOBS
