You must install MariaDB, create the Oozie database and MariaDB user, and add the
MariaDB JDBC driver jar file to Oozie.
-
Install and Start MariaDB.
-
Create the Oozie Database and Oozie MariaDB User.
For example, using the MariaDB
mysql
command-line
tool:
$ mysql -u root -p
Enter password:
MariaDB [(none)]> create database oozie default character set utf8;
Query OK, 1 row affected (0.00 sec)
MariaDB [(none)]> grant all privileges on oozie.* to 'oozie'@'localhost' identified by 'oozie';
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> grant all privileges on oozie.* to 'oozie'@'%' identified by 'oozie';
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> exit
Bye
-
Add the MariaDB JDBC Driver JAR to Oozie.
Cloudera recommends that you use the MySQL JDBC driver for MariaDB. Copy or
symbolically link the MySQL JDBC driver JAR to the
/var/lib/oozie/
directory.