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.…
Tweet Share
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.
… Tweet Share
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.…
Tweet Share
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.…
Tweet Share
MySQL Group Replication allows you to create an highly-available replication group of servers with minimum effort. It provides automated mechanisms to detect and respond to failures in the members of the group. The response depends on the characteristics of each failure and it is configurable.…
Tweet Share
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.…
Tweet Share
In this blog post I would like to give an overview of the most common failover scenarios and operations when using MySQL Group Replication 8.0.19 (aka GR) and Percona XtraDB Cluster 8 (PXC) (which is based on Galera), and explain how each technology handles each situation. I have created a three-node cluster with Group Replication using a single Primary and a three-node PXC, both with default settings. I am also going to use ProxySQL to interface with both clusters.
In both clusters, the name of the nodes are mysql1,
mysql2, and mysql3. In Group
Replication the Primary node is where the writes go if we are
using single primary configuration. In PXC, I will use the same
term as well and will call the node Primary where I am sending
the writes. Just to note, in PXC there is no concept of primary
node, …
In this two-part blog series, I wanted to cover some failover scenarios with Group Replication. In part one, I will discuss an interesting behavior and performance degradation I discovered while writing these posts. In part two, I will show several failover scenarios and demonstrate how Group Replication handles each situation.
The test environment is very basic, a three-node Group
Replication (mysql1,mysql2,myslq3) on MySQL 8.0.19 with default
settings. mysql2 is the Primary node.
In this scenario, I was testing a partial network failure when a node gets separated from the primary, but other nodes still can see it.
You would think mysql3 is going to lose quorum and
exit the cluster, but no. Inside the cluster, all the nodes are
in constant communication with each other, not just …
Understanding MySQL 8.0 Group Replication Limitations to build an highly reliable MySQL Infrastructure Operations Introduction – Redundant and fault-tolerant database systems
Most of our customers are 24*7 internet properties and their applications ( i.e. entire business operations) rely heavily on availability of respective database systems nodes, These systems going unavailable cause serious impact on reputation, customer experience and revenue. To ensure business continuity under foreseeable and unforeseeable man-made or natural disasters, the database system has to be designed and built with fault tolerance and disaster recovery capabilities, in other words the component can be removed and the system should continue to operate as expected. High availability refers to the characteristics of a system that allow the system to sustain continuous operation in the event of hardware and software failures due to natural or man …
[Read more]In the process of enhancing MySQL replication with new features for our users, we also improve the internals. A lot of work goes also to modernize the codebase and make it easier to maintain and obviously extend as well.
In MySQL 8.0.18,…
Tweet Share
