The MySQL source is a Change Data Capture connector that leverages MySQL's Binary Log. This connector will perform an initial snapshot of the data. Then, it will stream every
DELETE operation and push the events into a Meroxa stream.
Before creating a source connector:
- Setup - Setup your MySQL instance and acquire the credentials needed to talk to Meroxa.
- Add Resource - Add a MySQL resource to your Meroxa Resource.
The input of MySQL is a table name.
Then, to configure MySQL as a source:
Using the Dashboard, perform these steps to add a new source to a pipeline:
- Create a new pipeline.
- Add a source connector:
- Name your new connector and select your MySQL resource:
- Select "Create" and Done 🚀.
First, you must create a new pipeline.
Then, using the CLI, you can run the following command to add a new source to a pipeline:
meroxa connector create to-mysql-connector \ --from my-mysql \ --input Users \ --pipeline my-pipeline
The command above creates a new source connector called
to-mysql-connector, sets the source to a resource named
my-mysql, and configures the input.