Commands I ran:
bin/kafka-console-consumer.sh --zookeeper localhost:2181 --topic topicname --from-beginning
Output:
{"schema":{"type":"struct","fields":[{"type":"struct","fields":[{"type":"int32","optional":false,"field":"id"},{"type":"string","optional":false,"field":"name"},{"type":"string","optional":false,"field":"city"},{"type":"int32","optional":false,"field":"mobile"}],"optional":true,"name":"Cooldb.NextErptest.test.Value","field":"before"},{"type":"struct","fields":[{"type":"int32","optional":false,"field":"id"},{"type":"string","optional":false,"field":"name"},{"type":"string","optional":false,"field":"city"},{"type":"int32","optional":false,"field":"mobile"}],"optional":true,"name":"Cooldb.NextErptest.test.Value","field":"after"},{"type":"struct","fields":[{"type":"string","optional":false,"field":"name"},{"type":"int64","optional":false,"field":"server_id"},{"type":"int64","optional":false,"field":"ts_sec"},{"type":"string","optional":true,"field":"gtid"},{"type":"string","optional":false,"field":"file"},{"type":"int64","optional":false,"field":"pos"},{"type":"int32","optional":false,"field":"row"},{"type":"boolean","optional":true,"field":"snapshot"}],"optional":false,"name":"io.debezium.connector.mysql.Source","field":"source"},{"type":"string","optional":false,"field":"op"},{"type":"int64","optional":true,"field":"ts_ms"}],"optional":false,"name":"Cooldb.NextErptest.test.Envelope","version":1},"payload":{"before":null,"after":{"id":1,"name":"Ram","city":"Ayodhya","mobile":911},"source":{"name":"Cooldb","server_id":0,"ts_sec":0,"gtid":null,"file":"mysql-bin.000024","pos":276,"row":0,"snapshot":true},"op":"c","ts_ms":1476718025727}}
{"schema":{"type":"struct","fields":[{"type":"struct","fields":[{"type":"int32","optional":false,"field":"id"},{"type":"string","optional":false,"field":"name"},{"type":"string","optional":false,"field":"city"},{"type":"int32","optional":false,"field":"mobile"}],"optional":true,"name":"Cooldb.NextErptest.test.Value","field":"before"},{"type":"struct","fields":[{"type":"int32","optional":false,"field":"id"},{"type":"string","optional":false,"field":"name"},{"type":"string","optional":false,"field":"city"},{"type":"int32","optional":false,"field":"mobile"}],"optional":true,"name":"Cooldb.NextErptest.test.Value","field":"after"},{"type":"struct","fields":[{"type":"string","optional":false,"field":"name"},{"type":"int64","optional":false,"field":"server_id"},{"type":"int64","optional":false,"field":"ts_sec"},{"type":"string","optional":true,"field":"gtid"},{"type":"string","optional":false,"field":"file"},{"type":"int64","optional":false,"field":"pos"},{"type":"int32","optional":false,"field":"row"},{"type":"boolean","optional":true,"field":"snapshot"}],"optional":false,"name":"io.debezium.connector.mysql.Source","field":"source"},{"type":"string","optional":false,"field":"op"},{"type":"int64","optional":true,"field":"ts_ms"}],"optional":false,"name":"Cooldb.NextErptest.test.Envelope","version":1},"payload":{"before":null,"after":{"id":2,"name":"Krishna","city":"Mathura","mobile":922},"source":{"name":"Cooldb","server_id":0,"ts_sec":0,"gtid":null,"file":"mysql-bin.000024","pos":276,"row":0,"snapshot":true},"op":"c","ts_ms":1476718025727}}
{"schema":{"type":"struct","fields":[{"type":"struct","fields":[{"type":"int32","optional":false,"field":"id"},{"type":"string","optional":false,"field":"name"},{"type":"string","optional":false,"field":"city"},{"type":"int32","optional":false,"field":"mobile"}],"optional":true,"name":"Cooldb.NextErptest.test.Value","field":"before"},{"type":"struct","fields":[{"type":"int32","optional":false,"field":"id"},{"type":"string","optional":false,"field":"name"},{"type":"string","optional":false,"field":"city"},{"type":"int32","optional":false,"field":"mobile"}],"optional":true,"name":"Cooldb.NextErptest.test.Value","field":"after"},{"type":"struct","fields":[{"type":"string","optional":false,"field":"name"},{"type":"int64","optional":false,"field":"server_id"},{"type":"int64","optional":false,"field":"ts_sec"},{"type":"string","optional":true,"field":"gtid"},{"type":"string","optional":false,"field":"file"},{"type":"int64","optional":false,"field":"pos"},{"type":"int32","optional":false,"field":"row"},{"type":"boolean","optional":true,"field":"snapshot"}],"optional":false,"name":"io.debezium.connector.mysql.Source","field":"source"},{"type":"string","optional":false,"field":"op"},{"type":"int64","optional":true,"field":"ts_ms"}],"optional":false,"name":"Cooldb.NextErptest.test.Envelope","version":1},"payload":{"before":null,"after":{"id":3,"name":"Paras","city":"Hyderabad","mobile":933},"source":{"name":"Cooldb","server_id":0,"ts_sec":0,"gtid":null,"file":"mysql-bin.000024","pos":276,"row":0,"snapshot":true},"op":"c","ts_ms":1476718025727}}
{"schema":{"type":"struct","fields":[{"type":"struct","fields":[{"type":"int32","optional":false,"field":"id"},{"type":"string","optional":false,"field":"name"},{"type":"string","optional":false,"field":"city"},{"type":"int32","optional":false,"field":"mobile"}],"optional":true,"name":"Cooldb.NextErptest.test.Value","field":"before"},{"type":"struct","fields":[{"type":"int32","optional":false,"field":"id"},{"type":"string","optional":false,"field":"name"},{"type":"string","optional":false,"field":"city"},{"type":"int32","optional":false,"field":"mobile"}],"optional":true,"name":"Cooldb.NextErptest.test.Value","field":"after"},{"type":"struct","fields":[{"type":"string","optional":false,"field":"name"},{"type":"int64","optional":false,"field":"server_id"},{"type":"int64","optional":false,"field":"ts_sec"},{"type":"string","optional":true,"field":"gtid"},{"type":"string","optional":false,"field":"file"},{"type":"int64","optional":false,"field":"pos"},{"type":"int32","optional":false,"field":"row"},{"type":"boolean","optional":true,"field":"snapshot"}],"optional":false,"name":"io.debezium.connector.mysql.Source","field":"source"},{"type":"string","optional":false,"field":"op"},{"type":"int64","optional":true,"field":"ts_ms"}],"optional":false,"name":"Cooldb.NextErptest.test.Envelope","version":1},"payload":{"before":null,"after":{"id":4,"name":"Divya B","city":"Chennai","mobile":944},"source":{"name":"Cooldb","server_id":0,"ts_sec":0,"gtid":null,"file":"mysql-bin.000024","pos":276,"row":0,"snapshot":true},"op":"c","ts_ms":1476718025727}}
{"schema":{"type":"struct","fields":[{"type":"struct","fields":[{"type":"int32","optional":false,"field":"id"},{"type":"string","optional":false,"field":"name"},{"type":"string","optional":false,"field":"city"},{"type":"int32","optional":false,"field":"mobile"}],"optional":true,"name":"Cooldb.NextErptest.test.Value","field":"before"},{"type":"struct","fields":[{"type":"int32","optional":false,"field":"id"},{"type":"string","optional":false,"field":"name"},{"type":"string","optional":false,"field":"city"},{"type":"int32","optional":false,"field":"mobile"}],"optional":true,"name":"Cooldb.NextErptest.test.Value","field":"after"},{"type":"struct","fields":[{"type":"string","optional":false,"field":"name"},{"type":"int64","optional":false,"field":"server_id"},{"type":"int64","optional":false,"field":"ts_sec"},{"type":"string","optional":true,"field":"gtid"},{"type":"string","optional":false,"field":"file"},{"type":"int64","optional":false,"field":"pos"},{"type":"int32","optional":false,"field":"row"},{"type":"boolean","optional":true,"field":"snapshot"}],"optional":false,"name":"io.debezium.connector.mysql.Source","field":"source"},{"type":"string","optional":false,"field":"op"},{"type":"int64","optional":true,"field":"ts_ms"}],"optional":false,"name":"Cooldb.NextErptest.test.Envelope","version":1},"payload":{"before":null,"after":{"id":5,"name":"Deepak","city":"Jaipur","mobile":955},"source":{"name":"Cooldb","server_id":0,"ts_sec":0,"gtid":null,"file":"mysql-bin.000024","pos":276,"row":0,"snapshot":true},"op":"c","ts_ms":1476718025727}}
{"schema":{"type":"struct","fields":[{"type":"struct","fields":[{"type":"int32","optional":false,"field":"id"},{"type":"string","optional":false,"field":"name"},{"type":"string","optional":false,"field":"city"},{"type":"int32","optional":false,"field":"mobile"}],"optional":true,"name":"Cooldb.NextErptest.test.Value","field":"before"},{"type":"struct","fields":[{"type":"int32","optional":false,"field":"id"},{"type":"string","optional":false,"field":"name"},{"type":"string","optional":false,"field":"city"},{"type":"int32","optional":false,"field":"mobile"}],"optional":true,"name":"Cooldb.NextErptest.test.Value","field":"after"},{"type":"struct","fields":[{"type":"string","optional":false,"field":"name"},{"type":"int64","optional":false,"field":"server_id"},{"type":"int64","optional":false,"field":"ts_sec"},{"type":"string","optional":true,"field":"gtid"},{"type":"string","optional":false,"field":"file"},{"type":"int64","optional":false,"field":"pos"},{"type":"int32","optional":false,"field":"row"},{"type":"boolean","optional":true,"field":"snapshot"}],"optional":false,"name":"io.debezium.connector.mysql.Source","field":"source"},{"type":"string","optional":false,"field":"op"},{"type":"int64","optional":true,"field":"ts_ms"}],"optional":false,"name":"Cooldb.NextErptest.test.Envelope","version":1},"payload":{"before":null,"after":{"id":6,"name":"Raju","city":"Mumbai","mobile":956},"source":{"name":"Cooldb","server_id":0,"ts_sec":0,"gtid":null,"file":"mysql-bin.000024","pos":276,"row":0,"snapshot":true},"op":"c","ts_ms":1476718025727}}