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 communication involved in the dissemination of transactions to other MySQL instances.…
10 Older Entries »
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.…
Faster failure detection
orchestrator uses a holistic approach
for failure detection: it reads state not only
from the failed server (e.g. master) but also from its replicas.
orchestrator now detects failure faster than before:
- A detection cycle has been eliminated, leading to quicker resolution of a failure. On our setup, where we poll servers …
NOTE: Due to new package dependency,
Ubuntu/Debian users should use
apt upgrade, or
percona-xtradb-cluster-57 to upgrade.
Percona XtraDB Cluster 5.7.20-29.24 is now the current release, based on the following:
MySQL Cluster Manager 1.4.5 is now available for download from My Oracle Support.
MCM 1.4.5 contains further stability and usability improvements of MySQL Cluster Manager.
The 1.4.5 release bundles MySQL Cluster 7.5.9. However, since MySQL Cluster 7.5.7, system tables contain sufficient information for MCM to properly support rolling reconfigurations when ndb_cluster_connection_pool is enabled for mysqlds.…
Percona XtraDB Cluster 5.6.38-26.23 is now the current release, based on the following:
- Percona Server for MySQL 5.6.38
- Galera/Codership WSREP API Release 5.6.38
- Galera Replication library 3.21
All Percona software is open-source and free. …[Read more]
In this blog post, I’d like to show some relationships of “Group Replication” and “InnoDB Cluster“. My hope is that I will be able to draw meaningful correlations and attempt to simplify our way of thinking about these setups. The MySQL development team released the first GA release of Group Replication in MySQL 5.7.17, which turns… Read More »
High availability for MySQL has become increasingly relevant given the ever increasing rate of adoption and implementation. It’s no secret to anyone in the community that the popularity of MySQL has become noteworthy. I still remember my start with MySQL in the early 5.0 days and people told me that I may not want to consider wasting my time training on a database that didn’t have a large industry adoption, but look at where we are now! One of my favorite pages to cite when trying to exhibit this fact is the db-engines.com ranking trend page where we can see that MySQL is right up there and contending with enterprise products such as Microsoft SQL Server and Oracle.
MySQL has gone from being part of the ever famous LAMP stack for users looking to set up their first website to seeing adoption from major technical players such as …[Read more]
Lire cet article en français There are 3 pillars for a database architecture: Monitoring Backup / Restore process High Availability This blog post is about database High Availability; more precisely about one of the best combo of the moment : MySQL 5.7 Group Replication : the only native HA solution for MySQL, it’s a Single/Multi-master update everywhere […]
In this blog, we will answer questions from our webinar on Percona XtraDB Cluster 101.
Recently (7 Dec 2017) I presented a webinar about Percona XtraDB Cluster 101. Firstly, thanks to all the attendees: we had a great webinar with quite some interesting questions and feedback.
Through this blog, I’ll answer most of the questions that were raised during the webinar.
Q. How does the need for the acknowledgment from other nodes affect the speed of writes?
A. There are two parts to replication: delivering a transaction (including acknowledgment) and applying the transaction. …[Read more]
10 Older Entries »