Using Oozie with MySQL/MariaDB - Hortonworks Data Platform

Apache Ambari Administration

Also available as:

PDF

Contents

loading table of contents...

Using Oozie with MySQL/MariaDB

To set up MySQL/MariaDB for use with Oozie:

Steps

On the Ambari Server host, stage the appropriate MySQL connector for later deployment.
1. Download the MySQL Connector/JDBC driver from MySQL.
2. On the Ambari Server host run:
```
ambari-server setup --jdbc-db=mysql --jdbc-driver=/path/to/mysql/mysql-connector-java.jar
```
3. Confirm that mysql-connector-java.jar is in the Java share directory.
```
ls /usr/share/java/mysql-connector-java.jar 
```
4. Make sure the .jar file has the appropriate permissions - 644.
5. Execute the following command:
```
ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar
```
Create a user for Oozie and grant it permissions.
- Using the MySQL database admin utility:
```
# mysql -u root -p
```
```
CREATE USER '<OOZIEUSER>'@'%' IDENTIFIED BY '<OOZIEPASSWORD>';
```
```
GRANT ALL PRIVILEGES ON *.* TO '<OOZIEUSER>'@'%';
```
```
FLUSH PRIVILEGES;
```
- Where <OOZIEUSER> is the Oozie user name and <OOZIEPASSWORD> is the Oozie user password.
Create the Oozie database.
- The Oozie database must be created prior.
```
# mysql -u root -p
```
```
CREATE DATABASE <OOZIEDATABASE>
```
- Where <OOZIEDATABASE> is the Oozie database name.