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

Webuzo News

Fixed: Addition of mysql extension in PHP 7.3 extra.ini which caused PHP startup error to be displayed

There was a bug in all the recent MySQL and MariaDB packages that MySQL extension was getting added in PHP 7.3 binary after installing MySQL on server, which caused the following PHP startup error to be displayed:PHP Warning: PHP Startup: Unable to load dynamic library ‘mysql.so’ (tried: /usr/local/apps/php73/ext/mysql.so (/usr/local/apps/php73/ext/mysql.so: cannot 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

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

Group Replication – Consistency Levels

The MySQL Group Replication (GR) feature is a multi-primary update anywhere or single-primary replication plugin for MySQL with built-in conflict detection and resolution, automatic distributed recovery, and group membership. Its goal it is to make high-availability (HA) simple with off-the-shelf hardware, not only to new applications but also existing ones Continue Reading

Binary log encryption at rest

Starting in version 8.0.14, MySQL server can encrypt all new binary and relay log files on disk. In order to do so, you just need to enable the new binlog_encryption option (and also ensure that you have a keyring). Once enabling the option in a client session, the server will Continue Reading

>