Skip to main content

Preparing to run the MySQL collector

Setting up pre-requisites for running the collector

Make sure that the machine from where you are running the collector meets the following hardware and software requirements.

Table 1.

Item

Requirement

Hardware

RAM

8 GB

CPU

2 Ghz processor

Software

Docker

Click here to get Docker.

Java Runtime Environment

OpenJDK 17 is supported and available here.

JDBC Driver

The computer must have the appropriate JDBC driver on its file system.

data.world specific objects

Dataset

You must have a ddw-catalogs (or other) dataset set up to hold your catalog files when you are done running the collector.



Preparing MySQL

Creating a user in MySQL for running the collector

Run the following SQL statements to set up a new user with appropriate permissions to harvest from MySQL.

  1. Create a new user:

    CREATE USER 'ddw_user'@'%' IDENTIFIED BY '<password>';
  2. Grant the permissions to the user:

    GRANT SELECT, SHOW VIEW, EXECUTE ON *.* TO 'ddw_user'@'%';

Downloading the JDBC driver