【oozie】将oozie的数据库配置为mysql

来源：互联网发布：js判断非负整数编辑：程序博客网时间：2024/05/19 17:05

假设已经将oozie安装好了，oozie内置的默认数据库为derby，现在改为mysql。

1. 在本机的mysql中创建oozie对应的数据库和用户名，密码

$ mysql -u root -p
Enter password: ******
 
mysql> create database oozie;
Query OK, 1 row affected (0.03 sec)
 
mysql>  grant all privileges on oozie.* to 'oozie'@'localhost' identified by 'oozie';
Query OK, 0 rows affected (0.03 sec)
 
mysql>  grant all privileges on oozie.* to 'oozie'@'%' identified by 'oozie';
Query OK, 0 rows affected (0.03 sec)
 
mysql> exit
Bye
 
2. 修改配置文件oozie-site.xml

  ...    <property>        <name>oozie.service.StoreService.jdbc.driver</name>        <value>com.mysql.jdbc.Driver</value>    </property>    <property>        <name>oozie.service.StoreService.jdbc.url</name>        <value>jdbc:mysql://localhost:3306/oozie</value>    </property>    <property>        <name>oozie.service.StoreService.jdbc.username</name>        <value>oozie</value>    </property>    <property>        <name>oozie.service.StoreService.jdbc.password</name>        <value>oozie</value>    </property>    ...

3. 添加mysql的jdbc driver到oozie中

sudo -u oozie /usr/lib/oozie/bin/oozie-setup.sh -jars mysql-connector-java-5.1.6.jar -extjs /tmp/ext-2.2.zip

ext-2.2.zip下载地址：http://archive.cloudera.com/cdh/3/oozie/DG_QuickStart.html（需要自己找一下，你能找到的）