kafka-connect-mongodb

• You can use this connector for Kafka9 by using kafka9-connect-mongodb branch.

The MongoDB sink connector for Kafka Connect provides a simple, continuous link from a Kafka topic or set of topics to MongoDB collection or collections.

The connector consumes Kafka messages, renames message fields, selects specific fields and upserts them to the MongoDB collection.

The connector supports messages in both JSON and Avro formats, with or without a schema, and multiple topic partitions.

Connector Configurations:

Parameter	Description	Example
db.host	host name of the database	"localhost"
db.port	port number of the database	"27017"
db.name	name of the database	"myDataBase"
db.collections	name of the collection	"myCollection
write.batch.enabled	use batch writing when a task is getting more records than write.batch.size	"true"/"false"
write.batch.size	the batch size when using batch writing	"200"
connect.use_schema	true if the data in the topic contains schema	"true"/"false"
record.fields.rename	rename fields name from the data in the topic	"field1=>newField1, field2=>newField2"
record.keys	keys in the db to update by	"key1,key2"
record.fields	specific fields from the record to insert the db	"field1,field2"
record.timestamp.name	specific fields from the record to insert the db	"updateDate"

Quick Start

In the following example we will produce json data to a Kafka topic without schema, and insert it to a test collection in our MongoDB database with the connector in distributed mode.

Pre start

• Download Kafka 0.9.0.0 or later.
• Create new database in your MongoDB named "testdb" and in that database, create new collection named "testcollection".

Start Kafka

• Start Zookeeper:

   $./bin/zookeeper-server-start.sh config/zookeeper.properties
  

• Start Kafka broker:

  	$./bin/kafka-server-start.sh config/server.properties
  

• Create a test topic:

  $./bin/kafka-topics.sh --create --zookeeper localhost:2181 --replication-factor 1 --partitions 5 --topic testTopic
  

Start Kafka Connect worker

• Copy the jar file of the connector to your workspace folder:

  $cp /your-jar-location/kafka-connect-mongodb-assembly-1.0.jar /tmp/
  

• Add the jar to the classpath:

  $export CLASSPATH=/tmp/kafka-connect-mongodb-assembly-1.0.jar
  

• Copy the worker configuration file to your workspace directory:

  $cp config/connect-distributed.properties /tmp/
  

• Modify the properties file to:

  bootstrap.servers=localhost:9092
  
  group.id=testGroup
  
  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
  
  internal.key.converter=org.apache.kafka.connect.json.JsonConverter
  internal.value.converter=org.apache.kafka.connect.json.JsonConverter
  internal.key.converter.schemas.enable=false
  internal.value.converter.schemas.enable=false
  
  offset.storage.topic=connectoffsets
  
  offset.flush.interval.ms=10000
  config.storage.topic=connectconfigs
  

  Notice that if your topic has high throughput, you may suffer from timeouts and rebalance issues, due to fetching too much records at once, which MongoDB isn't able to deal with.
  In order to deal with it, you can set the maximum number of fetched records by setting the consumer.max.partition.fetch.bytes parameter in your worker configs, where the parameter's value is a number that is low enough not to trigger the timeout, but high enough for not suffering from effectively synchronous message processing.
  Tuning will be required in that case.

• Create topics for connector offsets and configs:

  $./bin/kafka-topics.sh --create --zookeeper localhost:2181 --replication-factor 5 --partitions 5 --topic connectoffsets
  $./bin/kafka-topics.sh --create --zookeeper localhost:2181 --replication-factor 5 --partitions 1 --topic connectconfigs
  

• Run the worker:

  $./bin/connect-distributed.sh /tmp/connect-distributed.properties
  

Register the MongoDB connector:

• Create a json configurations file (mongo_connector_configs.json):

  {
         "name":"mongo-connector-testTopic",
         "config" :{
                 "connector.class":"com.startapp.data.MongoSinkConnector",
                 "tasks.max":"5",
                 "db.host":"localhost",
                 "db.port":"27017",
                 "db.name":"testdb",
                 "db.collections":"testcollection",
                 "write.batch.enabled":"true",
                 "write.batch.size":"200",
                 "connect.use_schema":"false",
                 "topics":"testTopic"
         }
  }
  

• Register the connector:

  $curl -X POST -H "Content-Type: application/json" --data @/tmp/mongo_connector_configs.json http://localhost:8083/connectors
  

Check it out

• Run Kafka producer:

  $./bin/kafka-console-producer.sh --broker-list localhost:9092 --topic testTopic
  

• Produce some data:

  {"field1":"value1", "field2":"value2", "field3":"value3"}
  

• Make sure the data inserted to the collection.

Using upsert, modifying field names and inserting only specific fields

• Unregister the connector:

  curl -i -X DELETE "http://localhost:8083/connectors/mongo-connector-testTopic"
  

• Modify connectors configurations (mongo_connector_configs.json):

  {
         "name":"mongo-connector-testTopic",
         "config" :{
                 "connector.class":"com.startapp.data.MongoSinkConnector",
                 "tasks.max":"5",
                 "db.host":"localhost",
                 "db.port":"27017",
                 "db.name":"testdb",
                 "db.collections":"testcollection",
                 "write.batch.enabled":"true",
                 "write.batch.size":"200",
                 "connect.use_schema":"false",
                 "record.fields.rename":"field1=>mykey1, "field2=>testField2",
                 "record.keys":"myKey1",
                 "record.fields":"myKey1,testField2,field3",
                 "topics":"testTopic"
         }
  }
  

• Create index on myKey1 in mongo:

  db.testcollection.createIndex( { myKey1: 1} )
  

• Register the connector:

  $curl -X POST -H "Content-Type: application/json" --data @/tmp/mongo_connector_configs.json http://localhost:8083/connectors
  

• Run Kafka producer:

  $./bin/kafka-console-producer.sh --broker-list localhost:9092 --topic testTopic
  

• Produce some data:

  {"field1":"a", "field2":"b", "field3":"c"}
  {"field1":"d", "field2":"e", "field3":"f"}
  {"field1":"a", "field2":"e", "field3":"f"}
  

• Make sure the data in the collection looks like this:

  {"myKey1":"d", "testField2":"e", "field3":"f"}
  {"myKey1":"a", "testField2":"e", "field3":"f"}
  

Add InsertedTime field to the record in the DB

• Unregister the connector

• Modify connectors configurations (mongo_connector_configs.json) by adding "record.timestamp.name":"updateDate" to the configs

• Register the connector:

• Run Kafka producer:

• Produce some data:

  {"field1":"a", "field2":"b", "field3":"c"}
  {"field1":"d", "field2":"e", "field3":"f"}
  {"field1":"a", "field2":"e", "field3":"f"}
  

• Make sure the data in the collection looks like this:

  {"myKey1":"d", "testField2":"e", "field3":"f", "updateDate" : 1485788932525}
  {"myKey1":"a", "testField2":"e", "field3":"f", "updateDate" : 1485789932528}