官网：https://maxwells-daemon.io/quickstart/
Maxwell安装
下载maxwell-1.25.0.tar.gz(注意：高版本的可能需要高版本的jdk)
解压
配置mysql
binlog_format = ROW server_id = 1 log-bin=/usr/local/mysql/arch/mysql-bin
注意maxwell所在的目录是可以访问到该log-bin文件的,简单的办法是加在一个用户组下
重启mysql,查看log-bin所在位置：show variables like ‘%log_bin%’;
创建Maxwell用户
mysql> CREATE USER 'maxwell'@'%' IDENTIFIED BY '!maxwell001'; mysql> CREATE USER 'maxwell'@'localhost' IDENTIFIED BY '!maxwell001'; mysql> CREATE USER 'maxwell'@'hadoop02' IDENTIFIED BY '!maxwell001'; mysql>grant all privileges on *.* to maxwell@'%' identified by '!maxwell001'; mysql>grant all privileges on *.* to maxwell@localhost identified by '!maxwell001'; mysql>grant all privileges on *.* to maxwell@hadoop02 identified by '!maxwell001'; mysql>flush privileges;
Maxwell配置文件
# Maxwell 相关配置 log_level=info client_id=ODS_NEW # Kafka相关配置 producer=kafka kafka.bootstrap.servers=hadoop02:9092 kafka_topic=maxwell # kafka_partition_hash=nurmur3 kafka_key_format=hash kafka.compression.type=snappy kafka.retries=100 kafka.acks=all producer_partition_by=primary_key # mysql相关配置 host=hadoop02 port=3306 user=maxwell password = !maxwell001 jdbc_options=zeroDateTimeBehavior=convertToNull&connectTimeout=600000 replica_server_id=202 # 配白名单 filter=exclude:*.*,include: test.*
创建kafka topic，并且启动消费
bin/kafka-topics.sh --create --zookeeper hadoop02:2181/kafka --partitions 3 --replication-factor 1 --topic maxwell kafka-console-consumer.sh --bootstrap-server hadoop02:9092 --topic maxwell --from-beginning
启动：bin/maxwell --conf=driver.properties --daemon
–client_id=ODS_NEW，如果不是后台启动，出现的下面的启动项，证明安装成功
[hadoop@hadoop02 maxwell-1.25.0]$ bin/maxwell --conf=driver.properties --client_id=ODS_NEW Using kafka version: 1.0.0 14:55:44,389 WARN MaxwellMetrics - Metrics will not be exposed: metricsReportingType not configured. 14:55:44,758 INFO ProducerConfig - ProducerConfig values: acks = all batch.size = 16384 bootstrap.servers = [hadoop02:9092] buffer.memory = 33554432 client.id = compression.type = snappy connections.max.idle.ms = 540000 enable.idempotence = false interceptor.classes = null key.serializer = class org.apache.kafka.common.serialization.StringSerializer linger.ms = 0 max.block.ms = 60000 max.in.flight.requests.per.connection = 5 max.request.size = 1048576 metadata.max.age.ms = 300000 metric.reporters = [] metrics.num.samples = 2 metrics.recording.level = INFO metrics.sample.window.ms = 30000 partitioner.class = class org.apache.kafka.clients.producer.internals.DefaultPartitioner receive.buffer.bytes = 32768 reconnect.backoff.max.ms = 1000 reconnect.backoff.ms = 50 request.timeout.ms = 30000 retries = 100 retry.backoff.ms = 100 sasl.jaas.config = null sasl.kerberos.kinit.cmd = /usr/bin/kinit sasl.kerberos.min.time.before.relogin = 60000 sasl.kerberos.service.name = null sasl.kerberos.ticket.renew.jitter = 0.05 sasl.kerberos.ticket.renew.window.factor = 0.8 sasl.mechanism = GSSAPI security.protocol = PLAINTEXT send.buffer.bytes = 131072 ssl.cipher.suites = null ssl.enabled.protocols = [TLSv1.2, TLSv1.1, TLSv1] ssl.endpoint.identification.algorithm = null ssl.key.password = null ssl.keymanager.algorithm = SunX509 ssl.keystore.location = null ssl.keystore.password = null ssl.keystore.type = JKS ssl.protocol = TLS ssl.provider = null ssl.secure.random.implementation = null ssl.trustmanager.algorithm = PKIX ssl.truststore.location = null ssl.truststore.password = null ssl.truststore.type = JKS transaction.timeout.ms = 60000 transactional.id = null value.serializer = class org.apache.kafka.common.serialization.StringSerializer 14:55:44,803 INFO AppInfoParser - Kafka version : 1.0.0 14:55:44,803 INFO AppInfoParser - Kafka commitId : aaa7af6d4a11b29d 14:55:44,821 INFO Maxwell - Maxwell v1.25.0 is booting (MaxwellKafkaProducer), starting at Position[BinlogPosition[mysql-bin.000001:99110], lastHeartbeat=1647500121094] 14:55:44,938 INFO MysqlSavedSchema - Restoring schema id 1 (last modified at Position[BinlogPosition[mysql-bin.000001:5360], lastHeartbeat=0]) 14:55:45,050 INFO BinlogConnectorReplicator - Setting initial binlog pos to: mysql-bin.000001:99110 14:55:45,140 INFO BinaryLogClient - Connected to hadoop02:16609 at mysql-bin.000001/99110 (sid:202, cid:260) 14:55:45,140 INFO BinlogConnectorLifecycleListener - Binlog connected.
启动成功,Mysql中会出现以下数据库和表
Kafka消费端打印出的日志
这样就可以对接flink或者spark，进行处理
