1.mysql 配置
1.1 vi /etc/my.cnf
server-id=101
log-bin=/var/lib/mysql/mysql-bin
binlog-do-db=canal
log-bin=mall-mysql-bin
binlog_cache_size=1M
binlog_format=row
expire_logs_days=7
slave_skip_errors=1062
1.2 重启mysql
service mysqld restart
1.3 登录mysql
mysql -h 127.0.0.1 -u admin -p
1.4 查看binlog是否启用
show variables like '%log_bin%';
1.5.查看日志格式
show variables like '%binlog_format%';
1.6创建用户并且赋权限
CREATE USER canal IDENTIFIED BY 'sjJUB%rX5mq$t9p8';
GRANT SELECT, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'canal'@'%';
FLUSH PRIVILEGES;
2.canal.deployer 配置
2.1 conf/example/instance.properties 配置
canal.instance.master.address=127.0.0.1:3306
canal.instance.master.journal.name=
canal.instance.master.position=
canal.instance.master.timestamp=
canal.instance.master.gtid=
canal.instance.dbUsername=canal
canal.instance.dbPassword=canal
canal.instance.connectionCharset = UTF-8
canal.instance.filter.regex=.*\\..*
2.2 启动
./usr/local/canal/bin/startup.sh
2.3 查看日志
tail -1000f /usr/local/canal/logs/canal/canal.log
3.client 配置
3.1 pom.xml
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>top.javatool</groupId>
<artifactId>canal-spring-boot-starter</artifactId>
<version>1.2.1-RELEASE</version>
</dependency>
3.2 实体类
import lombok.Data;
import lombok.ToString;
import java.util.Date;
@Data
@ToString
public class Student {
private Long id;
private String name;
private String address;
private Date birthdat;
private Integer stock;
}
3.3 监听类
mport com.test.application.entity.Student;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Component;
import top.javatool.canal.client.annotation.CanalTable;
import top.javatool.canal.client.handler.EntryHandler;
@CanalTable("student")
@Component
@Slf4j
public class StudentHandler implements EntryHandler<Student> {
@Override
public void insert(Student item) {
log.info("insert item:{}",item);
}
@Override
public void update(Student before, Student after) {
log.info("update before:{}",before);
log.info("update after:{}",after);
}
@Override
public void delete(Student item) {
log.info("delete item:{}",item);
}
}