This is a Jitsu.Classic documentation. For the lastest version, please visit docs.jitsu.com. Read about differences here.

📜 Configuration

Configuration UI

Jitsu Internals

Jitsu Server

MySQL

Overview

MySQL connector pulls data from the remote database

The source is using Airbyte docker image (@airbyte/source-mysql). Learn more how Airbyte-based sources work

How to connect

For connecting to MySQL you'll need host, port, username, password

Connection Parameters

ParameterDocumentation
host*
string
(required)
Hostname of the database.
port*
integer
(required)
Port of the database.
database*
string
(required)
Name of the database.
username*
string
(required)
Username to use to access the database.
password
string
(not required)
Password associated with the username.
jdbc_url_params
string
(not required)
Additional properties to pass to the jdbc url string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3)
replication_method*
string
(required)
Replication method to use for extracting data from the database. STANDARD replication requires no setup on the DB side but will not be able to represent deletions incrementally. CDC uses the Binlog to detect inserts, updates, and deletes. This needs to be configured on the source database itself.