数据库版本5.7.23,环境是双主(两边配置参数相同,除了自增参数),配置参数如下:
gtid-mode=on
enforce-gtid-consistency=on
log_bin=on
auto_increment_increment = 2
auto_increment_offset = 1
master_info_repository=table
relay_log_info_repository=table
relay_log_recovery=on
slave_preserve_commit_order=on
slave_parallel_type=logical_clock
mysql> show variables like 'slave_parallel%';
+------------------------+---------------+
| Variable_name | Value |
+------------------------+---------------+
| slave_parallel_type | LOGICAL_CLOCK |
| slave_parallel_workers | 2 |
+------------------------+---------------+
同步也没有任何错误,但是show processlist时候发现线程不对。
mysql> show processlist;
+----+-------------+---------------------+------+------------------+------+---------------------------------------------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------------+---------------------+------+------------------+------+---------------------------------------------------------------+------------------+
| 1 | system user | | NULL | Connect | 825 | Slave has read all relay log; waiting for more updates | NULL |
| 2 | system user | | NULL | Connect | 2264 | Waiting for master to send event | NULL |
| 4 | liu | 192.168.80.30:43477 | NULL | Binlog Dump GTID | 2214 | Master has sent all binlog to slave; waiting for more updates | NULL |
| 8 | root | localhost | NULL | Query | 0 | starting | show processlist |
+----+-------------+---------------------+------+------------------+------+---------------------------------------------------------------+------------------+
墨值悬赏

评论
