java 解析mysql 的binlog 日志文件

最新推荐文章于 2024-09-04 18:00:11 发布

不忘初心_jzy

最新推荐文章于 2024-09-04 18:00:11 发布

阅读量8.4k

点赞数 1

分类专栏： java 文章标签： mysql binglog 解析

java 专栏收录该内容

24 篇文章 1 订阅

订阅专栏

原文链接：https://ask.hellobi.com/blog/cimen/9133

Maven 配置

<dependency>
    <groupId>com.github.shyiko</groupId>
    <artifactId>mysql-binlog-connector-java</artifactId>
    <version>0.13.0</version>
</dependency>

Java文件

import com.github.shyiko.mysql.binlog.BinaryLogFileReader;
import com.github.shyiko.mysql.binlog.event.Event;
import com.github.shyiko.mysql.binlog.event.deserialization.ChecksumType;
import com.github.shyiko.mysql.binlog.event.deserialization.EventDeserializer;

import java.io.File;
import java.io.IOException;
class Sample {
    public static void main(String[] args) throws IOException {
        String filePath="D:\\DATA\\mysql-bin.000987";
        File binlogFile = new File(filePath);
        EventDeserializer eventDeserializer = new EventDeserializer();
        eventDeserializer.setChecksumType(ChecksumType.CRC32);
        BinaryLogFileReader reader = new BinaryLogFileReader(binlogFile, eventDeserializer);
        try {
            for (Event event; (event = reader.readEvent()) != null; ) {
                System.out.println(event.toString());
            }
        } finally {
            reader.close();
        }


    }
}