No Ping Will Tear Us Apart – Enabling member auto-rejoin in Group Replication

With the release of version 8.0.16 of MySQL, we’ve added some features to the Group Replication (GR) plugin, in order to enhance its high-availability capacities. One of these features was the ability to enable a member that has left the group, under certain circumstances, to automatically rejoin it, without need Continue Reading

Change group_replication_exit_state_action default option to READ_ONLY

In MySQL 8.0.16, the Group Replication plugin variable group_replication_exit_state_action default value has been changed to READ_ONLY. The group_replication_exit_state_action plugin variable was introduced in MySQL 8.0.12 to allow the user to configure how Group Replication behaves when a server instance leaves the group unintentionally. The group_replication_exit_state_action has following two values: ABORT_SERVER: Continue Reading

Rotating binary log master key online

Starting on version 8.0.16, MySQL server introduces a new command that allowsfor the binary log master key rotation, online! When binary log encryption is enabled, the binary log master key can be rotated online by using the following new command: ALTER INSTANCE ROTATE BINLOG MASTER KEY; ALTER INSTANCE ROTATE BINLOG Continue Reading

MySQL 8.0.16 Replication Enhancements

MySQL 8.0.16 has been released last Thursday. In it, you can find some new replication features. Here is a quick summary. Follow-up blog posts will provide details about these features. Large Messages Fragmentation Layer for Group Replication. Tiago Vale’s work, introduces message fragmentation to the Group Communication Framework. Group Replication’s Paxos Continue Reading

Group Replication – Consistent Reads Deep Dive

On previous posts about Group Replication consistency we: introduced consistency levels; explained how to configure the primary failover consistency; presented how to configure transaction consistency levels to achieve the consistency required by your applications. In blog 3. we presented the consistency levels: EVENTUAL, BEFORE, AFTER and BEFORE_AND_AFTER; their scopes: SESSION, Continue Reading

IPv6 support in Group Replication

In 8.0.14, we add to Group Replication (GR) the ability to use IPv6 in all of its network-related configuration parameters. This means that now you can take advantage of this technology and “rock” those billion addresses using MySQL Group Replication. What’s New When you operate a Group Replication group, some Continue Reading

Fail early, fail fast – preventing stale reads on a member that dropped out of the group!

In Group Replication, starting with MySQL 8.0.12, the user is able to specify the behavior for members that enter an error state. The member can either shoot itself on the head or set itself to read-only. But what does that mean in practice? This blog post will give you a Continue Reading

binlog-row-event-max-size system variable in MySQL 8.0.14

As you may have noticed by now, we are continuously improving and enhancing the experience of managing a MySQL server. Furthermore, we have also released tools, such as MySQL shell, that make advanced and distributed setups like creating, deploying, and running clusters of InnoDB instances, seamless to the end user. Continue Reading

Server version in the binary log

Replication topologies, whether master-slave or group replication setups, may be composed of servers using different MySQL versions. In MySQL 8.0.14, each transaction’s immediate and original server versions are now visible in the binary log as session variables. These two new variables, fully managed by the replication infrastructure, are used to Continue Reading

Group Replication now interacts with the Group Communication Engine more efficiently

MySQL 8.0.14 comes with a plethora of new features. Some of the new Group Replication features have user–facing options, some impact user-facing options, and others stay completely under the hood. This post will present one of the under-the-hood changes in MySQL 8.0.14: the way the Group Replication layer interacts with Continue Reading

>