MySQL Metadata Store

This extension uses Oracle’s MySQL JDBC driver which is not included in the Druid distribution and must be installed separately. There are a few ways to obtain this library:

It can be downloaded from the MySQL site at: https://dev.mysql.com/downloads/connector/j/
It can be fetched from Maven Central at:

This should fetch a JAR file named similar to ‘mysql-connector-java-x.x.xx.jar’.

Install MySQL

Use your favorite package manager to install mysql, e.g.:

on Ubuntu/Debian using apt apt-get install mysql-server
on OS X, using Homebrew brew install mysql

Alternatively, download and follow installation instructions for MySQL Community Server here:

Connect to MySQL from the machine where it is installed.

Configure your Druid metadata storage extension:

Add the following parameters to your Druid configuration, replacing <host> with the location (host name and port) of the database.

This extension provides support for encrypting MySQL connections. To get more information about encrypting MySQL connections using TLS/SSL in general, please refer to this guide.

The MySQL extension provides an implementation of an which can be used to ingest data into Druid from a MySQL database.