CDC工具可选择Oracle GoldenGate或者Zendesk开源的Maxwell,MySQL->GoldenGate或Maxwell->Kafka->Logstash->Elasticsearch
如果用商业软件,数据源端安装OracleGoldenGate for MySQL,目标端安装OracleGoldenGate for Big Data.
而用开源软件Maxwell配置会更简单些,只需编辑文件config.properties
host=localhost
user=root
password=xxxxxxx
kafka_topic=test_topic
启动Zookeeper
bin/zookeeper-server-start.sh -daemon config/zookeeper.properties
启动Kafka
bin/kafka-server-start.sh config/server.properties
启动Maxwell
bin/maxwell --user='root' --password='xxxxxxx' --host='localhost&#