大数据组件-Maxwell常用命令（持续更新完善）

Download

Download binary distro: https://github.com/zendesk/maxwell/releases/download/v1.33.0/maxwell-1.33.0.tar.gz
Sources and bug tracking is available on github: https://github.com/zendesk/maxwell

homebrew:

brew install maxwell

Configure

$ vi my.cnf

[mysqld]
server_id=1
log-bin=master
binlog_format=row

create database maxwell;
CREATE USER 'maxwell'@'%' IDENTIFIED BY 'password';
GRANT ALL ON maxwell.* TO 'maxwell'@'%';
GRANT SELECT, REPLICATION CLIENT, REPLICATION SLAVE ON *.* TO 'maxwell'@'%';

FLUSH PRIVILEGES;

Run Maxwell

xxxx

创建 kafka topic maxwell

kafka-topics.sh  --create --zookeeper localhost:2181 --replication-factor 1 --partitions 1 --topic maxwell
kafka-topics  --create --zookeeper localhost:2181 --replication-factor 1 --partitions 1 --topic maxwell

启动MaxWell

nohup ./bin/maxwell \
--user='maxwell' \
--password='password' \
--host='host_ip' \
--producer=kafka \
--kafka_version=1.0.0 \
--kafka.bootstrap.servers=localhost:9092 \
--kafka_topic=maxwell \
--filter='exclude: *.*, include: zclhdata_test.*' > ./log/maxwell.log &

后台 启动
nohup ./bin/maxwell \
--user='maxwell' \
--password='XZ7rDehq1asU' \
--host='host_ip \
--producer=kafka \
--kafka_version=1.0.0 \
--kafka.bootstrap.servers=localhost:9092 \
--kafka_topic=maxwell \
--filter='exclude: *.*, include: zclhdata_test.*' &


./bin/maxwell --user='maxwell' \
--password='password' \
--host='host_ip \
--producer=stdout