MySQL 8.0.20 Replication Enhancements

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

内容简介:We have justAlright, this time it is a small list – but compelling! Have fun trying out these new replication features in MySQL 8.0.20 and send us feedback either by commenting on this blog post or by

We have just released MySQL 8.0.20 . And it has some interesting replication enhancements. In particular one big and exciting feature: binary log compression. Here is the list of things in this release:

  • Binary Log Compression ( WL#3549 ) . This work done by Luís Soares implements binary log compression, making use of the popular compression algorithm ZSTD. Compression is done per transaction. Compressed transactions remain compressed when they are replicated between servers. This means that storing on disk and moving the contents of the binary log around through the network shall consume less storage space and network bandwidth respectively.
  • Controlling Primary Key Checks on Secondaries ( WL#13239 ). This work done by Pedro Gomes enables the user or operator to control whether the applier threads are allowed to: (a) create or alter tables in such a way that would leave them with no primary key; (b) apply CREATE TABLE or ALTER TABLE without holding the privileges to alter @@session.sql_require_primary_key. This means that a DBA operating a secondary, that is deployed on a different responsibility domain than that of the primary, can adjust the primary key policies on that secondary server independently of the settings on the upstream primary server.

Alright, this time it is a small list – but compelling! Have fun trying out these new replication features in MySQL 8.0.20 and send us feedback either by commenting on this blog post or by submitting a feature request or even a bug . Enjoy!

88 total views,  84 views today


以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持 码农网

查看所有标签

猜你喜欢:

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

Python语言程序设计

Python语言程序设计

[美]梁勇(Lang Y. D.) / 李娜 / 机械工业出版社 / 2015-4 / 79.00元

本书采用“问题驱动”、“基础先行”和“实例和实践相结合”的方式,讲述如何使用Python语言进行程序设计。本书首先介绍Python程序设计的基本概念,接着介绍面向对象程序设计方法,最后介绍算法与数据结构方面的内容。为了帮助学生更好地掌握相关知识,本书每章都包括以下模块:学习目标,引言,关键点,检查点,问题,本章总结,测试题,编程题,注意、提示和警告。 本书可以作为高等院校计算机及相关专业Py......一起来看看 《Python语言程序设计》 这本书的介绍吧!

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

HTML 编码/解码

URL 编码/解码
URL 编码/解码

URL 编码/解码

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

在线 XML 格式化压缩工具