canal微服务搭建

安装辅助jar包

创建canal微服务工程，通过连接canal服务器，监控mysql的binlog，当mysql分类数据发生改变时，我们同步数据库数据到redis中，这样做到mysql和redis数据同步

在 canal\spring-boot-starter-canal-master 中有一个工程 starter-canal ，它主要提供了SpringBoot环境下 canal 的支持，我们需要先安装该工程，在 starter-canal 目录下执行
mvninstall

百度网盘拿：链接：https://pan.baidu.com/s/1r3akIU-IS2s-INs6K_vBaA
提取码：1111
–来自百度网盘超级会员V2的分享

如下图：

canal微服务工程搭建

1.引入依赖

 <dependencies>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-actuator</artifactId>
    </dependency>
    <dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-test</artifactId>
        <scope>test</scope>
    </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.cloud</groupId>
            <artifactId>spring-cloud-starter-netflix-eureka-client</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.cloud</groupId>
            <artifactId>spring-cloud-starter-openfeign</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.cloud</groupId>
            <artifactId>spring-cloud-starter-netflix-hystrix</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.cloud</groupId>
            <artifactId>spring-cloud-starter-config</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.retry</groupId>
            <artifactId>spring-retry</artifactId>
        </dependency>
        <!--canal依赖-->
        <dependency>
            <groupId>com.xpand</groupId>
            <artifactId>starter-canal</artifactId>
            <version>0.0.1-SNAPSHOT</version>
        </dependency>
    
        <!-- redis 使用-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-redis</artifactId>
        </dependency>
    </dependencies>

配置文件：

server:
  port: 9007
logging:
  #file: demo.log
  pattern:
    console: "%d - %msg%n"
  level:
    org.springframework.web: debug
    com.lxs: debug
spring:
  redis:
    host: 192.168.45.132
    port: 6379
#canal配置
canal:
  client:
    instances:
# exmaple
      example:
        host: 192.168.45.132
        port: 11111

bootstrap.yml

spring:
application:
name: canal-service

启动器

@SpringBootApplication(exclude = DataSourceAutoConfiguration.class)
@EnableEurekaClient
@EnableCanalClient
@EnableFeignClients
@EnableCircuitBreaker
public class CanalApplication {
public static void main(String[] args) {
SpringApplication.run(CanalApplication.class,args);
}
}

监听创建

创建一个CanalDataEventListener类，实现对表增删改操作的监听，代码如下：

// 事件监听的注解 监听数据库的变化
@CanalEventListener
public class MyEventListener {
//当数据被添加的时候触发
// CanalEntry.EventType eventType 监听到的操作的类型 INSERT UPDATE ,DELETE
,CREATE INDEX ,GRAND
// CanalEntry.RowData rowData 被修改的数据()
@InsertListenPoint
public void onEvent(CanalEntry.EventType eventType, CanalEntry.RowData
rowData) {
//do something...
System.out.println("添加数据监听。。。。");
List<CanalEntry.Column> afterColumnsList =
rowData.getAfterColumnsList();
for (CanalEntry.Column column : afterColumnsList) {
System.out.println(column.getName()+":"+column.getValue());
}
}
//当数据被更新的时候触发
@UpdateListenPoint
public void onEvent1(CanalEntry.RowData rowData) {
//do something...
System.out.println("修改数据监听。。。。");
List<CanalEntry.Column> afterColumnsList =
rowData.getAfterColumnsList();
for (CanalEntry.Column column : afterColumnsList) {
System.out.println(column.getName()+":"+column.getValue());
}
}
// 当数据被删除的时候触发
@DeleteListenPoint
public void onEvent3(CanalEntry.EventType eventType, CanalEntry.RowData
rowData) {
//do something...
System.out.println("删除数据监听。。。。");
// List<CanalEntry.Column> afterColumnsList =
rowData.getAfterColumnsList();
List<CanalEntry.Column> afterColumnsList =
rowData.getBeforeColumnsList();
for (CanalEntry.Column column : afterColumnsList) {
System.out.println(column.getName()+":"+column.getValue());
}
}
//自定义事件的触发
// destination = "example" 指定某一个目的地 一定要和配置文件中的目录保持一致
//schema = "canal-test" 要监听的数据库实例
//table = {"t_user", "test_table"}, 要监听的表
// eventType = CanalEntry.EventType.UPDATE 要监听的类型
@ListenPoint(destination = "example", schema = "legou", table =
{"category_"}, eventType =
{CanalEntry.EventType.UPDATE,CanalEntry.EventType.INSERT,CanalEntry.EventType.DE
LETE})
public void onEvent4(CanalEntry.EventType eventType, CanalEntry.RowData
rowData) {
//do something...
System.out.println("只监听分类。。。。");
List<CanalEntry.Column> afterColumnsList =
rowData.getAfterColumnsList();
for (CanalEntry.Column column : afterColumnsList) {
System.out.println(column.getName()+":"+column.getValue());
}
}
}

测试

启动canal微服务，然后修改任意数据库的表数据，canal微服务后台输出如下：