Configuring MariaDB for Oozie

You must install MariaDB, create the Oozie database and MariaDB user, and add the MariaDB JDBC driver jar file to Oozie.

  1. Install and Start MariaDB.
  2. 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
  3. 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.