In our last blog post about the Automatic Asynchronous Replication Connection Failover feature which was released in MySQL 8.0.22, we showed you its usage and benefits. We now present here additional changes we added in MySQL 8.0.23 to further enhance this feature by making the receiver aware of the source’s group membership changes.…
Category Archives: High Availability
MySQL NDB Cluster at a Glance
3,592 total views, 2 views today
…MySQL NDB Cluster Backup/Restore Challenge
Hey, dolphins! Ready to test your NDB backup and restore skills?
Q1: You have a large database which takes 3 hours to back up. Insert/update/delete traffic will run during the backup. How do you run a backup so that none of the inserts/updates/deletes which are executed after the start of the backup are reflected in the backup files?…
Automatic Asynchronous Replication Connection Failover
MySQL 8.0.22 introduces Automatic Asynchronous Replication connection failover. This feature makes MySQL asynchronous replication fault-tolerant to source connection failure, by automating the process of re-establishment of a replication connection to another available source. If there are source servers in multiple data centers, the user can also configure the replica to fail over between them, to provide Disaster Recovery from failures of an entire data center.…
MySQL 8.0.22 Replication Enhancements
MySQL 8.0.22 was released roughly a week ago. It includes some nice additions to replication that we would like to call out. Here they are:
- Automatic Asynchronous Replication Connection Failover (WL#12649). This work, by Hemant Dangi, implements a mechanism in asynchronous replication that makes the replica automatically try to re-establish an asynchronous replication connection to another replication source, in case the current connection gets interrupted;
- New terminology for replica related statements (WL#14171).
New MySQL NDB Cluster 8.0.22 out now
MySQL NDB Cluster 8.0.22 is available to download now!
8.0.22 brings a lot of exciting new features and improvements like all our quarterly updates to 8.0.
IPv6 is now supported between all cluster nodes types. It works in dual stack environments and IPv6-only environments.…
More Robust Network Partition Handling in Group Replication
As Group Replication (GR) matures and it is deployed in a myriad of different systems, we begin to witness specific network conditions that we must be able to cope with in order to make Group Replication more tolerant and robust to those failures.…
START GROUP_REPLICATION can now take recovery credentials as parameters
From MySQL 8.0.21 onwards, START GROUP_REPLICATION includes new options which allow a user to specify credentials to be used for distributed recovery. You can now pass credentials when invoking START GROUP_REPLICATION instead of setting them when configuring the group_replication_recovery channel.
START GROUP_REPLICATION command now has the options:
USER: User name.
Group Replication SYSTEM messages in the error log
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.…
Specify Recovery IP Addresses in Group Replication
Group Replication distributed recovery is one of the key features and until now it was restricted to be executed over one mysql connection point automatically defined on mysql system variables port and host.
With group_replication_recovery_endpoints we can specify through which interfaces can group replication recovery take place for a given member so that it controls where recovery traffic flows in the network infrastructure.…