Wednesday, July 24, 2013

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

No comments: