Tag: Group Replication

Replication

More P_S Instrumentation for Group Replication

In order to improve observability and manageability of MySQL Group Replication (GR), we enhanced its instrumentation in MySQL 8.0.4. With these goals in mind, we have extended the usage of Performance Schema (P_S) from this plugin to the included Group Communication System (GCS) module as well as its submodule eXtended Communications (XCom) which are responsible for all …

Replication

Hostname support in Group Replication whitelist

Introduction Since the release of Group Replication, one of its main security features is IP Address Whitelisting. This allows us to control whoever can send requests to enter in a group. On MySQL version 8.0.4, we added a new possibility that it was lacking since the beginning: the ability to configure IP Address Whitelisting with hostnames. …

Replication

Understanding – Group Replication and InnoDB Cluster – Select All From MySQL

  mysql–js> cluster.addInstance(‘admin@gr128:3306’); A new instance will be added to the InnoDB cluster. Depending on the amount of data on the cluster this might take from a few seconds to several hours. Please provide the password for ‘admin@gr128:3306’: Adding instance to the cluster … The instance ‘admin@gr128:3306’ was successfully added to the cluster. mysql–js> cluster.addInstance(‘admin@gr129:3306’); …

Replication

More Write Set in MySQL: Group Replication Certification

This is the third post in the series on Write Set in MySQL.  In the first post, we explore how Write Set allows to get better parallel replication in MySQL 8.0.  In the second post, we saw how the MySQL 8.0 improvement is an extension of the work done in MySQL 5.7 to avoid replication …