MySQL Enterprise High Availability
MySQL Enterprise Edition
- Oracle MySQL Cloud Service
- Oracle Enterprise Manager
- MySQL Enterprise Monitor
- MySQL Enterprise Backup
- MySQL Enterprise HA
- MySQL Enterprise Scalability
- MySQL Enterprise Authentication
- MySQL Enterprise TDE
- MySQL Enterprise Encryption
- MySQL Enterprise Firewall
- MySQL Enterprise Audit
- White Papers
- Contact MySQL Sales
- Buy Now
MySQL has always been famous for its very flexible Master/Slave replication. However, MySQL users have been looking for a high availability solution built into the MySQL Server. Unlike other products, MySQL Group Replication delivers native, built-in HA for your MySQL databases:
- Core part of the standard MySQL Server
- Leverages proven MySQL features: InnoDB, GTIDs, binary logs, multi-threaded slave execution, multi-source replication, Performance Schema
- Supported on all MySQL platforms
Group Replication provides native high availability with built-in group membership management, data consistency guarantees, conflict detection and handling, node failure detection and database failover related operations, all without the need for manual intervention or custom tooling.
MySQL Group Replication delivers native, built-in HA for your MySQL databases
High Availability with MySQL Group Replication
Group Replication implements both a single-primary mode with automatic leader election and a multi-master update everywhere mode. By using a powerful new group communication system, which provides an in-house implementation of the popular Paxos algorithm, the group automatically coordinates on data replication, consistency, and membership. This provides all of the built-in mechanisms necessary for making your MySQL databases highly available.
With Group Replication, a set of servers coordinate together to form a group. The group membership is dynamic and servers can leave, either voluntarily or involuntarily, and join at any time. The group will automatically reconfigure itself as needed and ensure that any joining member is synchronized with the group. This makes it easy to quickly scale your total database capacity up and down as needed.
Group Replication implements a distributed failure detector to find and report servers that have failed or are no longer participating in the group and the remaining members in the group coordinate to reconfigure the membership.
Group Replication builds on an in-house implementation of the popular Paxos distributed algorithm to provide distributed coordination between servers. In order for a group to continue to function, it requires a majority of the members to be online and for them to form an agreement on every change. This allows your MySQL databases to safely continue to operate without manual intervention when failures occur, without the risk of data loss or data corruption.
If a server joins the group, it will automatically bring itself up to date by synchronizing its state from an existing member. In the event that a server leaves the group, for instance it was taken down for maintenance, the remaining servers will see that it has left and will reconfigure the group automatically. When that server later rejoins the group, it will automatically re-synchronize with the group again.
Performance Schema tables provide clear and detailed information and statistics on individual members and for the group as a whole.