Artie Transfer
Search
⌃K
Comment on page

MySQL

In this section, we will go over how to gather your credentials and prepare your MySQL to start providing CDC logs.

Finding your MySQL settings

This is necessary so that we are able to run a Debezium deployment to read from your MySQL server's binlogs and publish them onto Kafka. To see additional configuration properties, please click here to see Debezium's documentation.
We will need the following:
Name
Description
Default value
Database Host Name
IP address or hostname of your database server.
No default
Database Port
Port for where your server is running.
3306
Database Username
Username for authentication into your database.
No default
Database Password
Password for authentication into your database.
No default
Database Name
The name of the database that you want to capture changes for.
No default.

Supported types

  • BOOLEAN / BOOL
  • BIT(1)
  • TINYINT
  • SMALLINT[(M)]
  • MEDIUMINT[(M)]
  • INT, INTEGER[(M)]
  • BIGINT[(M)]
  • REAL[(M, D)]
  • FLOAT[(P)]
  • FLOAT(M, D)
  • NUMERIC[(M[,D])]
  • DECIMAL[M[,D])]
  • DOUBLE[(M, D)]
  • CHAR(M)
  • VARCHAR(M)
  • TINYTEXT
  • TEXT
  • MEDIUMTEXT
  • LONGTEXT
  • JSON
  • ENUM
  • SET
  • YEAR[(2|4)]
  • TIMESTAMP[(M)]
  • DATE
  • TIME[(M)]
  • DATETIME, DATETIME(M)

Running it yourself

These considerations are automatically handled for you if Artie Transfer is running a Debezium connector for you.
We are also actively working on reducing the amount of considerations required to support every possible configuration.
Last modified 5mo ago