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 or Maria DB for use with Oozie:

Steps

On the Ambari Server host, stage the appropriate MySQL connector for later deployment.
1. Install the connector.
  RHEL/CentOS/Oracle Linux
```
yum install mysql-connector-java* 
```
  SLES
```
zypper install mysql-connector-java*
```
  Debian/Ubuntu
```
apt-get install libmysql-java
```
2. Confirm that mysql-connector-java.jar is in the Java share directory.
```
ls /usr/share/java/mysql-connector-java.jar 
```
3. Make sure the .jar file has the appropriate permissions - 644.
4. 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.