To get more information about encrypting MySQL connections using TLS/SSL in general, please refer to this guide. This extension provides support for encrypting MySQL connections.
= mysql .connectURI= jdbc:mysql:///druid .user= druid .password= diurd Encrypting MySQL connections With the location (host name and port) of the database. Configure your Druid metadata storage extension:Īdd the following parameters to your Druid configuration, replacing.grant the user all the permissions on the database we just created GRANT ALL PRIVILEGES ON druid.* TO 'localhost' create a druid user CREATE USER 'localhost' IDENTIFIED BY 'diurd' Paste the following snippet into the mysql prompt: - create a druid database, make sure to use utf8mb4 as encoding CREATE DATABASE druid DEFAULT CHARACTER SET utf8mb4 on OS X, using Homebrew brew install mysqlĪlternatively, download and follow installation instructions for MySQLĬonnect to MySQL from the machine where it is installed.on Ubuntu/Debian using apt apt-get install mysql-server.Use your favorite package manager to install mysql, e.g.: This should fetch a JAR file named similar to 'mysql-connector-java-x.x.xx.jar'.Ĭopy or symlink this file to extensions/mysql-metadata-storage under the distribution root directory. as libmysql-java on APT for a Debian-based OS
It may be available through your package manager, e.g.It can be fetched from Maven Central at:.It can be downloaded from the MySQL site at:.There are a few ways to obtain this library: This extension uses Oracle's MySQL JDBC driver which is not included in the Druid distribution and must be
Brew install mysql connector for java how to#
Refer to the following section for instructions on how to install this library. The MySQL extension requires the MySQL Connector/J library which is not included in the Druid distribution. To use this Apache Druid extension, make sure to include mysql-metadata-storage as an extension.