You Can Now Use Binary Log Checksums with Group Replication

栏目: IT技术 · 发布时间: 4年前

内容简介:Group Replication enables you to create fault-tolerant systems with redundancy by replicating the system state to a set of servers. Even if some of the servers subsequently fail, as long it is not all or a majority, the system is still available.This blog

Group Replication enables you to create fault-tolerant systems with redundancy by replicating the system state to a set of servers. Even if some of the servers subsequently fail, as long it is not all or a majority, the system is still available.

This blog post will focus on the fact that after 8.0.21 you can use Group Replication with binary log event checksums turned on. Therefore, you do not have to explicitly set binlog-checksum=NONE before starting Group Replication.

The fact that Group Replication supports binary log checksums makes archiving/backing up the binary logs more resilient when it comes to validity and integrity checking. When they are pulled from the archive to be used at a later point in time, checksums will be checked when these are replayed. Furthermore, during distributed recovery, donors shall have checksums in their binary logs, so these will also be double checked at that stage. This is a good thing.

From MySQL 8.0.21, the extra configuration

--binlog-checksum=NONE

is no more required.

Note that binary log event checksums are generated when writing to the binary log. In Group Replication, coordination between servers (i.e., replication and agreement) happens before writing transactions out to the binary log and as such checksums are generated after being replicated. Consequently, the relay log for the group_replication_applier channel shall contain transactions that have events without checksums.

Conclusion

Following our tradition of steady improvements, we are once again making Group Replication simpler to use by using the server default values.

685 total views,  570 views today


以上就是本文的全部内容,希望本文的内容对大家的学习或者工作能带来一定的帮助,也希望大家多多支持 码农网

查看所有标签

猜你喜欢:

本站部分资源来源于网络,本站转载出于传递更多信息之目的,版权归原作者或者来源机构所有,如转载稿涉及版权问题,请联系我们

Beginning PHP and MySQL 5

Beginning PHP and MySQL 5

W. Jason Gilmore / Apress / 2006-01-23 / USD 44.99

Beginning PHP and MySQL 5: From Novice to Professional, Second Edition offers comprehensive information about two of the most prominent open source technologies on the planet: the PHP scripting langua......一起来看看 《Beginning PHP and MySQL 5》 这本书的介绍吧!

XML 在线格式化
XML 在线格式化

在线 XML 格式化压缩工具

RGB HSV 转换
RGB HSV 转换

RGB HSV 互转工具

RGB CMYK 转换工具
RGB CMYK 转换工具

RGB CMYK 互转工具