canal 数据同步

配置参考  https://blog.csdn.net/u014386444/article/details/105874639/

1.导包

<dependency>
    <groupId>com.xpand</groupId>
    <artifactId>starter-canal</artifactId>
    <version>0.0.1-SNAPSHOT</version>
</dependency>

2.配置

canal.client.instances.example.host=127.0.0.1
  #canal.client.instances.example.host=111.111.111.111
canal.client.instances.example.port=11111
canal.client.instances.example.batchSize=1000

3.启动类

@SpringBootApplication
@EnableCanalClient
public class CanaTestApplication {

    public static void main(String[] args) {
        SpringApplication.run(CanaTestApplication.class, args);
    }
}

4.业务

@CanalEventListener
@Component
public class MyEventListener {
			//库名				表名
    @ListenPoint(schema = "leadnews_article", table = {"ap_article"})
    public void onEvent4(CanalEntry.EventType eventType, CanalEntry.RowData rowData) {

        List<CanalEntry.Column> list = rowData.getBeforeColumnsList();
        for (CanalEntry.Column column : list) {
            System.out.print(column.getName()+"="+column.getValue()+"\t");
        }
        System.out.println();

        List<CanalEntry.Column> columns = rowData.getAfterColumnsList();
        for (CanalEntry.Column column : columns) {
            System.err.print(column.getName()+"="+column.getValue()+"\t");
        }
        System.out.println();
    }
}