by Yoann La Cancellera | Mar 28, 2024 | Insight for DBAs, Insight for Developers, MySQL
Any Galera documentation about limitations will state that tables must have primary keys. They state that DELETEs are unsupported and other DMLs could have unwanted side-effects such as inconsistent ordering: rows can appear in different order on different nodes in... by Yoann La Cancellera | Jun 28, 2023 | Insight for DBAs, MySQL, Percona Software
Recently, I was working on a very unfortunate case that revolved around diverging clusters, data loss, missing important log errors, and forcing commands on Percona XtraDB Cluster (PXC). Even though PXC tries its best to explain what happens in the error log, I... by Anil Joshi | Nov 25, 2022 | Cloud, Insight for DBAs, MySQL
In this blog post, I will try to cover a few dump and data-loading utilities offered by MySQL Shell. What is MySQL Shell? It is a robust client and code editor for MySQL. In addition to having APIs for dealing with MySQL, MySQL Shell offers scripting capabilities for... by Arunjith Aravindan | Sep 15, 2022 | Cloud, MySQL, Percona Software
This article outlines the basic configurations for setting up and deploying Percona XtraDB Cluster 8.0 (PXC) on Amazon EC2, as well as what is new in the setup compared to Percona XtraDB Cluster 5.7. What is Percona XtraDB Cluster an ideal fit for? Percona XtraDB... by Evgeniy Patlan | Aug 11, 2022 | MySQL, Percona Software
Percona XtraDB Cluster (PXC) is a database clustering solution for MySQL. It ensures high availability, prevents downtime and data loss, and provides linear scalability for a growing environment.Lately, the number of questions about how to build Percona software has... by Chetan Shivashankar | Jul 25, 2022 | Cloud, MySQL, Percona Software
Introduction/FAQ Question: I need to run a production-grade open source MySQL DB.Answer: Percona to the rescue! Percona XtraDB Cluster (PXC) is an open source enterprise MySQL solution that helps you to ensure data availability for your applications while improving... by Fernando Laudares Camargos | Jul 21, 2022 | Insight for DBAs, MySQL, Percona Software
When we run a SELECT in a replica server and it returns a different result to the one we would have obtained had we queried the source server instead, due to changes in the dataset that have not yet been replicated or synchronized to the replica, we get what is known... by Marco Tusa | Dec 9, 2021 | Insight for DBAs, MySQL, Percona Software
Percona XtraDB Cluster 8.0.25 (PXC) has introduced a new option to perform online schema modifications: NBO (Non-Blocking Operation).When using PXC, the cluster relies on the wsrep_OSU_method parameter to define the Online Schema Upgrade (OSU) method the node uses to... by David Ducos | Dec 1, 2021 | Insight for DBAs, MySQL, Percona Software
Working on a real case scenario in a five node Percona XtraDB Cluster (PXC), we were forced to use wsrep_sync_wait = 1, because the app does reads-after-write and we send reads to all the nodes. We had the idea to leave some nodes in DESYNC mode to reduce the flow... by Przemysław Malkowski | Jul 12, 2021 | Insight for DBAs, MySQL, Percona Software
The ProblemState Snapshot Transfer can be a very long and expensive process, depending on the size of your Percona XtraDB Cluster (PXC)/Galera cluster, as well as network and disk bandwidth. There are situations where it is needed though, like after long enough node... by Lenz Grimmer | Jun 1, 2021 | MySQL, Open Source, Percona Software
After Oracle released MySQL version 8.0.24 on April 20, 2021, our engineering team got started right away with merging our enhancements to prepare the corresponding 8.0.24 version of Percona Server for MySQL.However, Oracle released MySQL version 8.0.25 shortly... by Marco Tusa | May 4, 2021 | Insight for DBAs, MySQL, Percona Software
AKA Cluster Error Voting… What is Cluster Error Voting (CEV)? “Cluster Error Voting is a new feature implemented by Alexey Yurchenko, and it is a protocol for nodes to decide how the cluster will react to problems in replication. When one or several nodes... by Fernando Laudares Camargos | Apr 23, 2021 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Apologies for the silly title, but the issue is a real one, even though it is not a new thing. Schema upgrades are not an ordinary operation in Galera. For the subject at hand, the bottom line is: under the default Total Order Isolation (TOI) method, “the... by Sergey Pronin | Feb 24, 2021 | Cloud, Monitoring, MySQL, Percona Software
Point-In-Time Recovery (PITR) for MySQL databases is an important feature that is essential and covers common use cases, like a recovery to the latest possible transaction or roll-back the database to a specific date before some bad query was executed. Percona... by Fernando Laudares Camargos | Nov 17, 2020 | Cloud, MySQL, Open Source, Percona Software
Kubernetes has been a big trend for a while now, particularly well-suited for microservices. Running your main databases on Kubernetes is probably NOT what you are looking for. However, there’s a niche market for them. My colleague Stephen Thorn did a great job... by David Busby | Oct 30, 2020 | Insight for DBAs, MySQL, Percona Software
Galera replication technology, a key component of Percona XtraDB Cluster, suffered from a remote code execution vulnerability. Percona has been working with the vendor since early September on this issue and has made releases available to address the problem.... by Stephen Thorn | Oct 8, 2020 | Cloud, MongoDB, MySQL, Percona Software
As a Solutions Engineer at Percona, one of my responsibilities is to support our customers as they investigate new and emerging technologies. This affords me the opportunity to speak to many current and new customers who partner with Percona. The topic of Kubernetes... by Sri Sakthivel | Oct 6, 2020 | MySQL, Open Source, Percona Software
Schema changes are the big challenges in Galera replication. So, it is recommended to understand the schema changes operation for everyone who uses the Percona XtraDB Cluster (PXB)/Galera clusters. In this blog, I am going to explain the operation and impact of the... by Sveta Smirnova | Jul 28, 2020 | MySQL, Percona Software
I got this question on the “How to Avoid Pitfalls in Schema Upgrade with Percona XtraDB Cluster (PXC)” webinar and wanted to answer it in a separate post. Will RSU have an effect on GTID consistency if replication PXC cluster to another cluster? Answer for... by Dmitriy Kostiuk | Jul 23, 2020 | Cloud, MongoDB, Monitoring, MySQL, Percona Software
The content of this article is outdated. See the official Percona Operator for MongoDB and Percona XtraDB Cluster Operator documentation for more up to date information.Percona Monitoring and Management (PMM) provides an excellent solution to...