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.
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.
Create a new user:
CREATE USER 'ddw_user'@'%' IDENTIFIED BY '<password>';
Grant the permissions to the user:
GRANT SELECT, SHOW VIEW, EXECUTE ON *.* TO 'ddw_user'@'%';
Downloading the JDBC driver
Make sure you download the appropriate JDBC driver for MySQL on the machine from where you will run the collector.