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 (for on-premise runs only)

RAM

8 GB

CPU

2 Ghz processor

Software (for on-premise runs only)

Docker

Click here to get Docker.

JDBC Driver

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

data.world specific objects (for both cloud and on-premise runs)

Dataset

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

If you are using Catalog Toolkit , follow these instructions to prepare the datasets for collectors.



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

Important

This task is only required for on-premise run of collectors.

In this section: