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


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

查看所有标签

猜你喜欢:

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

Language Implementation Patterns

Language Implementation Patterns

Terence Parr / Pragmatic Bookshelf / 2010-1-10 / USD 34.95

Knowing how to create domain-specific languages (DSLs) can give you a huge productivity boost. Instead of writing code in a general-purpose programming language, you can first build a custom language ......一起来看看 《Language Implementation Patterns》 这本书的介绍吧!

RGB转16进制工具
RGB转16进制工具

RGB HEX 互转工具

HTML 编码/解码
HTML 编码/解码

HTML 编码/解码

HSV CMYK 转换工具
HSV CMYK 转换工具

HSV CMYK互换工具