Skip to content

Instantly share code, notes, and snippets.

@erohana
Created August 14, 2021 07:10
Show Gist options
  • Save erohana/4685d6314ba588178fb04ac67a0f3bc0 to your computer and use it in GitHub Desktop.
Save erohana/4685d6314ba588178fb04ac67a0f3bc0 to your computer and use it in GitHub Desktop.
email-message-scheduler Debezium connector
{
"name": "delayed-email-message",
"config": {
"connector.class": "io.debezium.connector.mysql.MySqlConnector",
"tasks.max": "1",
"database.hostname": "mysql",
"database.port": "3306",
"database.user": "root",
"database.password": "rootpass",
"database.server.id": "184054",
"database.server.name": "dbserver1",
"database.whitelist": "emails",
"database.history.kafka.bootstrap.servers": "kafka:9093",
"database.history.kafka.topic": "delayed.emails.history",
"key.converter": "org.apache.kafka.connect.json.JsonConverter",
"value.converter": "org.apache.kafka.connect.json.JsonConverter",
"key.converter.schemas.enable": "false",
"value.converter.schemas.enable": "false",
"table.whitelist": "emails.delayed_messages",
"transforms": "Reroute, filter, unwrap",
"transforms.unwrap.type": "io.debezium.transforms.ExtractNewRecordState",
"transforms.unwrap.drop.tombstones": "true",
"transforms.Reroute.type": "io.debezium.transforms.ByLogicalTableRouter",
"transforms.Reroute.topic.regex": "(.*)(delayed_messages)$",
"transforms.Reroute.topic.replacement": "email.execution",
"transforms.filter.type": "io.debezium.transforms.Filter",
"transforms.filter.language": "jsr223.groovy",
"transforms.filter.topic.regex": "email.execution",
"transforms.filter.condition": "value.op == \"u\" && value.before.is_ready == false && value.after.is_ready == true"
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment