Group Replication: coping with unreliable failure detection

Failure detection is a cornerstone of distributed systems as it determines which components are working properly or not, allowing it to tackle both network and host instabilities and failures. Like many other distributed systems, Group Replication (GR) requires a majority of correctly operating group members to work properly.…

Setting up MySQL Group Replication with MySQL Docker images

MySQL Group Replication (GR) is a MySQL Server plugin that enables you to create elastic, highly-available, fault-tolerant replication topologies. Groups can operate in a
single-primary mode with automatic primary election, where only one server accepts updates at a time. Alternatively, groups can be deployed in multi-primary mode, where all servers can accept updates, even if they are issued concurrently.…

Protecting your data – Part II: Preventing unwanted data changes on Group Replication members by asynchronous replication channels

Further to our earlier blog post about Fail-safe enhancements to Group Replication, where we discussed enhancements against data modification in members which are not ONLINE, we now present here additional changes to protect data from being accidentally modified by asynchronous replication channels.…

Getting started with MySQL Cluster 7.6 using MySQL Cluster Manager 1.4.6

MySQL_Cluster_Manager

MySQL Cluster 7.6 is GA!
If you’re eager to give the recently announced MySQL Cluster 7.6 GA a spin, I’ll walk you through a quick and simple way to get started using MySQL Cluster Manager 1.4.6.

Bootstrap and go!

  1. Download and install MCM and MySQL Cluster
  2. Bootstrap a cluster with MCM

    $ mcmd –bootstrap
  3. Connect to the database, and have at it

    $ mysql -h 127.0.0.1 -P 3306 -u root

That simple.…

MySQL Cluster Manager 1.4.6 released!

MySQL_Cluster_Manager
MySQL Cluster Manager 1.4.6 is now available for download from My Oracle Support.

Overview
In MCM 1.4.6, the list backups command has been extended with a new –agent option for listing agent backups created with the backup agents command.


The output can be filtered with the –backupid option:


The backupids for agent backups reflect the Unix Epoch times at which the backups were taken.…