by Juan Arruti | Apr 21, 2025 | Cloud, MySQL, Percona Software
When using the Percona Operator for MySQL based on Percona XtraDB Cluster (PXC), it’s common to encounter scenarios where cluster nodes request a full State Snapshot Transfer (SST) when rejoining the cluster. One typical scenario where a State Snapshot Transfer...
by Fernando Laudares Camargos | Nov 14, 2024 | Cloud, Insight for DBAs, MySQL, Percona Software
Even though I used a dedicated Kubernetes cluster to host my test database, I had this belief that by not explicitly allocating (or requesting, in Kubernetes vocabulary) CPU resources to my Percona XtraDB Cluster (PXC) pods or yet making just a small request,...
by Edwin Wang | May 20, 2024 | MySQL, Percona Software
If you were to ask me the question, “Would it be possible to set up a replicate filter within the Percona XtraDB Cluster?” my immediate response would be to question you right back. Why would you even want the cluster nodes to have different data when you’re using a...
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 | Jan 11, 2022 | MySQL, Percona Software
In April 2021, I wrote an article about Online DDL and Group Replication. At that time we were dealing with MySQL 8.0.23 and also opened a bug report which did not have the right answer to the case presented. Anyhow, in that article I have shown how an online DDL was...
by Sergey Pronin | Jun 23, 2021 | Cloud, MySQL, Open Source, Percona Software
GitOps workflow was introduced by WeaveWorks as a way to implement Continuous Deployment for cloud-native applications. This technique quickly found its way into devops and developer’s hearts as it greatly simplifies the application delivery pipeline: the change...
by Przemysław Malkowski | Apr 28, 2021 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Multi-writer replication has been a challenge in the MySQL ecosystem for years before truly dedicated solutions were introduced – first Galera (and so Percona XtradDB Cluster (PXC)) replication (around 2011), and then Group Replication (first GA in 2016). Now,...
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 cluster...
by Sergey Pronin | Apr 20, 2021 | Cloud, MySQL, Percona Software
Percona Kubernetes Operators support various options for storage: Persistent Volume (PV), hostPath, ephemeral storage, etc. In most of the cases, PVs are used, which are provisioned by the Operator through Storage Classes and Persistent Volume Claims. Storage Classes...
by Sergey Pronin | Apr 1, 2021 | Cloud, MySQL, Open Source, Percona Software
It is no secret that compute and storage costs are the main drivers of cloud bills. Migration of data from the legacy data center to the cloud looks appealing at first as it significantly reduces capital expense (CapEx) and keeps operational expenses (OpEx) under...
by Tomislav Plavcic | Aug 11, 2020 | Cloud, MySQL, Percona Software
In Percona Operator for MySQL based on Percona XtraDB Cluster versions prior to 1.5.0, there were two methods for upgrading PXC clusters, and both of these use built-in StatefulSet update strategies. The first one is manual (OnDelete update strategy) and the second...
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 Tibor Korocz | Apr 21, 2020 | Insight for DBAs, MySQL, Percona Software
by Borys Belinsky | Mar 19, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
Percona is happy to announce the experimental release of Percona XtraDB Cluster 8.0. This is a major step for tuning Percona XtraDB Cluster to be more cloud- and user-friendly. This is the second experimental release that combines the updated and feature-rich Galera...
by Daniel Guzmán Burgos | Jan 21, 2020 | Cloud, MySQL, Percona Software, ProxySQL
Being that Amazon is one of the most-used cloud vendors, it is only natural that one may ask “How can Kubernetes be used in AWS?”. And the answer is – not that different than with other cloud vendors. What one needs is two things (and this applies...
by Kenn Takara | Oct 4, 2019 | Insight for DBAs, MySQL, Percona Software
Starting with the experimental release of Percona XtraDB Cluster 8.0, we have made changes to the SST process to make the process more robust and easier to use. mysqldump and rsync are no longer supported SST methods. Support for mysqldump was deprecated starting with...
by Kenn Takara | Oct 3, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
The problem In PXC 5.6 and 5.7, when using xtrabackup-v2 as the SST method, the DBA must create a user with the appropriate privileges for use by Percona XtraBackup (PXB). The username and password of this backup user are specified in the wsrep_sst_auth variable. This...
by Borys Belinsky | Oct 1, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona is happy to announce the first experimental binary of Percona XtraDB Cluster 8.0 on October 1, 2019. This is a major step for tuning Percona XtraDB Cluster to be more cloud- and user-friendly. This release combines the updated and feature-rich Galera 4, with...
by Borys Belinsky | Sep 18, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona is happy to announce the release of Percona XtraDB Cluster 5.7.27-31.39 on September 18, 2019. Binaries are available from the downloads section or from our software repositories. Percona XtraDB Cluster 5.7.27-31.39 is now the current release, based on the...
by Borys Belinsky | Sep 17, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona is glad to announce the release of Percona XtraDB Cluster 5.6.45-28.36 on September 17, 2019. Binaries are available from the downloads section or from our software repositories. Percona XtraDB Cluster 5.6.45-28.36 is now the current release, based on the...
