Oozie: Using Mysql to store oozie metadata

1. configure oozie-site.xml

 

    <property>
        <name>oozie.db.schema.name</name>
        <value>oozie</value>  
    </property>

    <property>
        <name>oozie.service.JPAService.create.db.schema</name>
        <value>true</value>
    </property>

    <property>
        <name>oozie.service.JPAService.jdbc.driver</name>
        <value>com.mysql.jdbc.Driver</value>
    </property>

    <property>
        <name>oozie.service.JPAService.jdbc.url</name>
        <value>jdbc:mysql://192.168.122.1:3306/${oozie.db.schema.name}</value>
     </property>
    <property>
        <name>oozie.service.JPAService.jdbc.username</name>
        <value>zhaohj</value>   
    </property>

    <property>
        <name>oozie.service.JPAService.jdbc.password</name>
        <value>password</value>  
    </property>

2. create oozie database in mysql and grant privileges to user 'zhaohj'

 

3.copy mysql jdbc driver to   oozie-4.0.1/libext/

4.

#oozie-setup.sh prepare-war

#ooziedb.sh create -sqlfile oozie.sql -run   //produce oozie.sql and create all tables in oozie database