环境：Springboot2.7.12 + MySQL8
1 环境准备master: 192.168.2.129
slave: 192.168.2.130
使用Docker安装MySQL ， 这里Docker安装省略 ， 网上一堆教程 。
Docker安装完成后，安装MySQL 。
安装MySQL
步骤1：
[root@node150 kafka]# mkdir -p /root/software/mysql/conf /root/software/mysql/data [root@node150 kafka]# chmod -R 777 /root/software/mysql/步骤2：
进入/root/software/mysql/conf 创建my.cnf 内容如下：
[client] #socket = /usr/mysql/mysqld.sock default-character-set = utf8mb4 [mysqld] #pid-file= /var/run/mysqld/mysqld.pid #socket= /var/run/mysqld/mysqld.sock #datadir= /var/lib/mysql #socket = /usr/mysql/mysqld.sock #pid-file = /usr/mysql/mysqld.piddatadir = /var/lib/mysql character_set_server = utf8mb4 collation_server = utf8mb4_bin secure-file-priv= NULL # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 # Custom config should go here !includedir /etc/mysql/conf.d/步骤3：
docker run --name mysql8 --restart=always --privileged=true -v /root/software/mysql/conf/my.cnf:/etc/mysql/my.cnf -v /root/software/mysql/data:/var/lib/mysql -v /etc/localtime:/etc/localtime:ro -p 3306:3306 -e MYSQL_ROOT_PASSword=123123 -d mysql --lower_case_table_names=1完成分别在129，130上完成上面操作 。
2 主从配置129.168.2.129作为master节点，修改my.cnf配置，追加下面配置：
binlog_format=MIXEDlog-bin=mysql-binserver-id=1129.168.2.130作为slave节点，修改my.cnf配置 ， 追加下面配置：
log-bin=mysql-binserver-id=2修改完配置后分别重启mysql
3 配置从节点3.1 查看master状态mysql> show master status; +------------------+----------+--------------+------------------+-------------------+ | File| Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set | +------------------+----------+--------------+------------------+-------------------+ | mysql-bin.000001 |156 |||| +------------------+----------+--------------+------------------+-------------------+ 1 row in set (0.00 sec)这里的File，Position列再配置从节点时需要用到 。
3.2 配置从节点CHANGE MASTER TO MASTER_HOST='192.168.2.129',MASTER_PORT=3306,MASTER_USER='root',MASTER_PASSWORD='123123',master_log_file='mysql-bin.000003',master_log_pos=156,master_connect_retry=60,GET_MASTER_PUBLIC_KEY=1;执行上面的命令如果报错如下：
This operation cannot be performed with a running slave io thread; run STOP SLAVE IO_THREAD FOR CHANNEL '' first.这时需要执行stop slave
注意：上面的mysql-bin.000003 是首次配置的，如果master节点重启了，这个文件会递增变为mysql-bin.000004，这时我们的从节点会自动连上这mysql-bin.000004
查看从节点状态：
mysql> show slave statusG *************************** 1. row ***************************Slave_IO_State: WAIting for source to send eventMaster_Host: 192.168.2.129Master_User: rootMaster_Port: 3306Connect_Retry: 60Master_Log_File: mysql-bin.000005Read_Master_Log_Pos: 156Relay_Log_File: 85acaa370429-relay-bin.000014Relay_Log_Pos: 371# 该文件会自动与master节点同步Relay_Master_Log_File: mysql-bin.000005# 主要看这里的两个Running是否为YesSlave_IO_Running: YesSlave_SQL_Running: YesReplicate_Do_DB:Replicate_Ignore_DB:Replicate_Do_Table:Replicate_Ignore_Table:Replicate_Wild_Do_Table:Replicate_Wild_Ignore_Table:Last_Errno: 0Last_Error:Skip_Counter: 0Exec_Master_Log_Pos: 156Relay_Log_Space: 755Until_Condition: NoneUntil_Log_File:Until_Log_Pos: 0Master_SSL_Allowed: NoMaster_SSL_CA_File:Master_SSL_CA_Path:Master_SSL_Cert:Master_SSL_Cipher:Master_SSL_Key:Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: NoLast_IO_Errno: 0Last_IO_Error:Last_SQL_Errno: 0Last_SQL_Error:Replicate_Ignore_Server_Ids:Master_Server_Id: 1Master_UUID: 71bb9106-a9a9-11ed-9031-0242ac110002Master_Info_File: mysql.slave_master_infoSQL_Delay: 0SQL_Remaining_Delay: NULLSlave_SQL_Running_State: Replica has read all relay log; waiting for more updatesMaster_Retry_Count: 86400Master_Bind:Last_IO_Error_Timestamp:Last_SQL_Error_Timestamp:Master_SSL_Crl:Master_SSL_Crlpath:Retrieved_Gtid_Set:Executed_Gtid_Set:Auto_Position: 0Replicate_Rewrite_DB:Channel_Name:Master_TLS_Version:Master_public_key_path:Get_master_public_key: 1.NETwork_Namespace:1 row in set, 1 warning (0.00 sec)3.3 测试在主节点上执行创建数据库，建表等操作都会自动同步到slave节点上 。
4 创建Canaldocker run --name canal -p 11111:11111 -v /opt/canal/conf:/home/admin/canal-server/conf -v /opt/canal/logs:/home/admin/canal-server/logs -d canal/canal-server5 Springboot整合Canal添加依赖
<dependencies><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-data-redis</artifactId></dependency><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></dependencies>