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:

NameDescriptionDefault value

Database Host Name

IP address or hostname of your database server. Make sure this instance is the primary instance or writer node.

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

Last updated