Java读取MySql的binlog日志

鸿祯

于 2019-09-05 15:44:06 发布

阅读量7.5k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： MySQL教学

本文链接：https://blog.youkuaiyun.com/zhangningkid/article/details/100559498

在pom.xml中添加jar包

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

读取指定binlog文件里的内容

public class Application {
    public static void main(String[] args) throws IOException {
        File file = new File("E:\\binlog.000005");
        EventDeserializer eventDeserializer = new EventDeserializer();
        eventDeserializer.setCompatibilityMode(
                EventDeserializer.CompatibilityMode.DATE_AND_TIME_AS_LONG,
                EventDeserializer.CompatibilityMode.CHAR_AND_BINARY_AS_BYTE_ARRAY
        );
        BinaryLogFileReader reader = new BinaryLogFileReader(file, eventDeserializer);
        try {
            for (Event event; (event = reader.readEvent()) != null; ) {
                EventData data