MySQL Advanced Settings

Overview

In most cases, the advanced settings aren't required. However, Matillion CDC does provide additional configuration items when setting up your pipelines. Please take a moment to understand what these advanced settings are and what they achieve before incorporating them into your pipeline.

If you are unclear about a particular setting, please reach out to Matillion for support.

MySQL Advanced Settings

Pipeline advanced settings can be added at the end of the Add Pipeline journey via the Matillion Data Loader UI.

snapshot.mode

The snapshot.mode setting allows control over the snapshot stage of the CDC process when your pipeline begins. Its valid values are listed below:

• initial: Enables taking a snapshot only when no offsets have been noted for the logical server name.
• schema_only: Enables snapshots of captured table schemas, but not data. Schema-only snapshots are commonly used when only wanting to capture changes happening after the snapshot occurs.