title: Sync data between MySQL Databases with Kafka Connect
body: <p>I'm trying to sync data between several MySQL databases with Confluent which base on Kafka Connect. I used "bulk" for mode in source connector config, since the primary key type is varchar, so I couldn't use incrementing mode. It works fine, but I got two problems:</p>
  
  <ol>
  <li>It seems that it couldn't sync deleting, when data was deleted in source databases, nothing happened to the sink databases. The data is still present in the sink databases.</li>
  <li>It takes quite a while to sync data. In my case, it takes about 2~4 minutes to sync a table with 3~4k rows. I can understand that using bulk mode may make it take more time to sync the data, but isn't that too long?</li>
  </ol>
  
  <p>Here is my source connector config:</p>
  
  <pre><code>name=test-source
  connector.class=io.confluent.connect.jdbc.JdbcSourceConnector
  tasks.max=1
  connection.url=jdbc:mysql://xxx.xxx.xxx:3306/xxx?useUnicode=true&amp;characterEncoding=utf8
  connection.user=user
  connection.password=password
  mode=bulk
  table.whitelist=a_table
  </code></pre>
  
  <p>And this is my sink connector config:</p>
  
  <pre><code>name=test-sink
  connector.class=io.confluent.connect.jdbc.JdbcSinkConnector
  tasks.max=1 topics=a_table
  connection.url=jdbc:mysql://xxx.xxx.xxx.xxx:3306/xxx?useUnicode=true&amp;characterEncoding=utf8
  connection.user=user
  connection.password=password
  insert.mode=upsert
  pk.mode=record_value
  pk.fields=mypk
  auto.evolve=true
  </code></pre>
  
  <p>Any suggestion would be appreciate. Thank you.</p>