MySQL High Availability

News from the MySQL High Availability Team

Skip to content
  • About

Restrict MySQL replication to row based events

January 14, 2020MySQL Replication, ReplicationPedro Gomes

In a follow-up to the work presented on MySQL 8.0.18  where we introduced privilege checks for slave applier threads, in this post we present a new feature to further increase your ability to securely replicate your data: you can now restrict replication streams to row based events only.…

One comment so far

MySQL 8.0.19 Replication Enhancements

January 13, 2020Group Replication, High Availability, MySQL Replication, ReplicationMySQL, ReplicationLuis Soares

Here comes another MySQL release, and together with it, a set of new replication features. As usual, we would like to summarize them. And, also as usual, follow up blogs will provide further details.

  • Configure Replication Applier to Require Row-based Replication only.
…
Leave a comment

Group Replication delivery message service

October 18, 2019Group ReplicationMySQL Group ReplicationAníbal Pinto

In the process of enhancing MySQL replication with new features for our users, we also improve the internals. A lot of work goes also to modernize the codebase and make it easier to maintain and obviously extend as well.

In MySQL 8.0.18,…

One comment so far

Automatic member fencing with OFFLINE_MODE in Group Replication

October 17, 2019Group Replication, High Availability, ReplicationMySQL, MySQL Group ReplicationNuno Carvalho

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.…

Leave a comment

Support for TLS 1.3 in Group Replication

October 16, 2019Group Communication System, High Availability, Security, XComTiago J.

In MySQL 8.0.18, we enhanced the Group Communication System (GCS) layer used by Group Replication (GR) with the ability to use and configure member-to-member connections using TLS v1.3. Therefore, you can secure further your system’s communication with the latest security algorithms.…

Leave a comment

Replication with restricted privileges

October 15, 2019Configuration, Replication, SecurityPedro Figueiredo

Up until MySQL 8.0.18, the slave executes replicated transactions without checking privileges. It does so to be able to apply everything that its upstream server (the master) tells it to. In practice this means that the slave fully trusts its master.…

View all 2 comments

MySQL 8.0.18 Replication Enhancements

October 14, 2019Group Communication System, Group Replication, MySQL, MySQL Replication, Replication, XComMySQLLuis Soares

The latest MySQL 8.0 release is out. That is MySQL 8.0.18.  We have some new replication enhancements and some work done on replication internals in this release that we would like to highlight and celebrate with our users. Here is a quick summary.…

View all 2 comments

Improved handling of different member versions in Group Replication

July 26, 2019Group Replication, High Availability, MySQL Replication, Replicationjaideep.karande

For optimal compatibility and performance, all members of a group should run the same version of MySQL Server and therefore of Group Replication. However, in some situations, it may be required to that a group contains servers running different versions. For example, during a rolling upgrade.…

Leave a comment

Binary Log Encryption: Encryption of Temporary Capture Files

July 25, 2019High AvailabilityLuis Soares

In MySQL 8.0.14 we introduced binary log encryption at rest. When enabled, this feature makes sure that binary log files  generated by the server are encrypted as soon as they hit persistent storage.

As of MySQL 8.0.17 transient files created by the server for capturing the changes that end up in the binary log stream are also encrypted.…

Leave a comment

mysqlbinlog: support for protocol compression

July 23, 2019Binary Log, MySQL, ReplicationLuis Soares

We are happy to share with you that the mysqlbinlog tool has been enhanced. Starting on 8.0.17, the user can instruct the mysqlbinlog tool to negotiate, with the server that it connects to, whether to use protocol compression or not.

Since MySQL 5.6,…

Leave a comment

Posts navigation

← Older posts
Newer posts →

Recent Posts

  • Automatic Asynchronous Replication Connection Failover
  • MySQL 8.0.22 Replication Enhancements
  • New MySQL NDB Cluster 8.0.22 out now
  • More Robust Network Partition Handling in Group Replication
  • START GROUP_REPLICATION can now take recovery credentials as parameters

Recent Comments

  • João Gramacho on “Look: I/O thread is waiting for disk space!”
  • dan on “Look: I/O thread is waiting for disk space!”
  • João Gramacho on How to manually decrypt an encrypted binary log file
  • StephaneG on How to manually decrypt an encrypted binary log file
  • dennis.sehalic on Group Replication – Consistent Reads Deep Dive

Archives

Categories

Meta

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Subscribe via Email

Enter your email address to receive notifications of new posts by email.

Proudly powered by WordPress