mysql5.7 增强半同步

最新推荐文章于 2025-05-08 10:59:59 发布

zw_hard

最新推荐文章于 2025-05-08 10:59:59 发布

阅读量1.7k

点赞数

分类专栏： mysql复制

mysql复制专栏收录该内容

8 篇文章

订阅专栏

MySQL 5.7.4 版本通过引入独立线程 ack_receive 来接收半同步复制的确认信号，有效提升了整体 TPS。此前版本中，binlogdump 进程同时负责发送 binlog 和接收确认，而新版本则分离了这两项任务。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mysql5.7.4的文档里有一句话：

http://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-4.html

Replication: Implemented separate threads for sending and receiving semisynchronous replication acknowledgement signals, so that event streams and ACK streams can be sent and received simultaneously. This should reduce many common delays and thus improve performance with semisynchronous replication in a number of settings.

这句话不太起眼，实际上威力不小，解释一下：
在5.7.4版本的semi sync 框架中，独立出一个线程叫ack_receive ，专门用于接收slave的反馈信息。
这样master上有两个进程独立工作，一个发送binlog到slave，另一个接收slave的反馈。而之前版本，master只有一个进程binlog dump，既负责发送binlog给slave，又负责接收slave反馈。

可以用pstack观察一下mysqld进程：

Thread 52 (Thread 0x7f339d64d700 (LWP 4860)):
#0 0x000000382ac0b98e in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1 0x0000000000eead0a in MYSQL_BIN_LOG::wait_for_update_bin_log(THD*, timespec const*) ()
#2 0x0000000000f0a6fe in Binlog_sender::send_binlog(st_io_cache*, unsigned long long) ()
#3 0x0000000000f0a987 in Binlog_sender::run() ()
#4 0x0000000000f04b81 in mysql_binlog_send(THD*, char*, unsigned long long, Gtid_set*, unsigned int) ()
#5 0x0000000000f076e7 in com_binlog_dump(THD*, char*, unsigned long) ()
#6 0x0000000000d233d6 in dispatch_command(THD*, COM_DATA const*, enum_server_command) ()
#7 0x0000000000d24904 in do_command(THD*) ()
#8 0x0000000000df5b14 in handle_connection ()
#9 0x0000000000f6ff04 in pfs_spawn_thread ()
#10 0x000000382ac079d1 in start_thread () from /lib64/libpthread.so.0
#11 0x000000382a8e8b6d in clone () from /lib64/libc.so.6

Thread 55 (Thread 0x7f336b5fe700 (LWP 4298)):
#0 0x000000382a8e15e3 in select () from /lib64/libc.so.6
#1 0x00007f339c8859fe in Ack_receiver::run() () from /usr/lib64/mysql/plugin/semisync_master.so
#2 0x00007f339c885dc9 in ack_receive_handler () from /usr/lib64/mysql/plugin/semisync_master.so
#3 0x0000000000f6ff04 in pfs_spawn_thread ()
#4 0x000000382ac079d1 in start_thread () from /lib64/libpthread.so.0
#5 0x000000382a8e8b6d in clone () from /lib64/libc.so.6

很明显，我们看到了新的东西：ack_receive，它来自semisync_master.so插件。

实际测试了下，有了这个东西后，半同步架构下的整体TPS有了不小的提升。

转载自： http://blog.51cto.com/weikle/1792233