Fri, 27 Mar 2020 18:51:00 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/xtradb-cluster-failure-scenarios-recover/ Mon, 28 Jan 2019 18:36:26 +0000 https://www.percona.com/blog/?p=55042 Please join Percona’s Senior Technical Manager, Alkin Tezuysal, and Percona’s Percona XtraDB Cluster Lead, Krunal Bauskar as they present their talk, Percona XtraDB Cluster: Failure Scenarios and their Recovery on Wednesday, January 30th, 2019, at 8:00 AM PST (UTC-8) / 11:00 AM EST (UTC-5). View the Recording Percona XtraDB Cluster (a.k.a PXC) is an open […]]]> 55042 https://www.percona.com/blog/qa-percona-xtradb-cluster-proxysql-high-availability/ Thu, 03 May 2018 23:48:06 +0000 https://www.percona.com/blog/?p=49415 On March 22, 2018, we held a webinar on how Percona XtraDB cluster 5.7 (PXC) and ProxySQL can help achieve your database clustering high availability needs. Firstly, thanks to all the attendees for taking time to attend the webinar and we are sure you had a webinar experience. We tried answering some of your high […]]]> 49415 https://www.percona.com/blog/flush-and-lock-handling-in-percona-xtradb-cluster/ Wed, 21 Mar 2018 19:30:24 +0000 https://www.percona.com/blog/?p=48516 In this blog post, we’ll look at how Percona XtraDB Cluster (PXC) executes FLUSH and LOCK handling.IntroductionPercona XtraDB Cluster is a multi-master solution that allows parallel execution of the transactions on multiple nodes at the same point in time. Given this semantics, it is important to understand how Percona XtraDB Cluster executes statements regarding FLUSH and LOCK […]]]> 48516 https://www.percona.com/blog/webinar-mysql-high-availability-clustering-needs/ Tue, 20 Mar 2018 18:16:52 +0000 https://www.percona.com/blog/?p=48859 Please join Percona’s Ramesh Sivaraman (QA Engineer) and Krunal Bauskar (Software Engineer, Percona XtraDB Cluster Lead) as they present Percona XtraDB Cluster 5.7 with ProxySQL for Your MySQL High Availability and Clustering Needs on Thursday, March 22, 2018 at 8:30 am PDT (UTC-7) / 11:30 am EDT (UTC-4). Percona has developed Percona XtraDB Cluster (based […]]]> 48859 https://www.percona.com/blog/no-sst-node-rejoins/ https://www.percona.com/blog/no-sst-node-rejoins/#comments Tue, 13 Feb 2018 23:56:18 +0000 https://www.percona.com/blog/?p=46831 What if we tell you that there is a sure way to get IST not SST for node rejoins? You can guarantee that a new node rejoins using IST. Sound interesting? Keep reading.Normally when a node is taken out of the cluster for a short period of time (for maintenance or shutdown), gcache on other nodes of the cluster help […]]]> https://www.percona.com/blog/no-sst-node-rejoins/feed/ 1 46831 https://www.percona.com/blog/webinar-q-percona-xtradb-cluster-101/ https://www.percona.com/blog/webinar-q-percona-xtradb-cluster-101/#comments Tue, 19 Dec 2017 18:40:44 +0000 https://www.percona.com/blog/?p=46522 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 […]]]> https://www.percona.com/blog/webinar-q-percona-xtradb-cluster-101/feed/ 2 46522 https://www.percona.com/blog/sequence-numbers-seqno-percona-xtradb-cluster/ Thu, 14 Dec 2017 15:21:31 +0000 https://www.percona.com/blog/?p=46385 In this blog post, we’ll look at how sequence numbers work in Percona XtraDB Cluster.IntroductionPercona XtraDB Cluster uses multiple sequence numbers (seqno), each having a special role to play. Let’s try to understand the significance of each sequence number.global_seqnoAn active Percona XtraDB Cluster cluster has multiple write-sets (transactions) generated from one or more nodes. These transactions […]]]> 46385 https://www.percona.com/blog/webinar-thursday-december-7-2017-percona-xtradb-cluster-pxc-101/ Wed, 06 Dec 2017 15:22:54 +0000 https://www.percona.com/blog/?p=46471 Join Percona’s Software Engineer (PXC Lead), Krunal Bauskar as he presents Percona XtraDB Cluster 101 on Thursday, December 7, 2017, at 7:00 am PST / 10:00 am EST (UTC-8). Tags: Percona XtraDB Cluster, MySQL, High Availability, Clustering Experience Level: Beginner Percona XtraDB Cluster (PXC) is a multi-master solution that offers virtual synchronous replication among clustering […]]]> 46471 https://www.percona.com/blog/understanding-ist-donor-selected/ https://www.percona.com/blog/understanding-ist-donor-selected/#comments Wed, 15 Nov 2017 16:11:44 +0000 https://www.percona.com/blog/?p=46108 In a clustering environment, we often see a node that needs to be taken down for maintenance. For a node to rejoin, it should re-sync with the cluster state. In PXC (Percona XtraDB Cluster), there are 2 ways for the rejoining node to re-sync: State Snapshot Transfer (SST) and Incremental State Transfer (IST). SST involves […]]]> https://www.percona.com/blog/understanding-ist-donor-selected/feed/ 3 46108 https://www.percona.com/blog/faster-node-rejoin-improved-ist-performance/ https://www.percona.com/blog/faster-node-rejoin-improved-ist-performance/#comments Fri, 21 Jul 2017 16:01:12 +0000 https://www.percona.com/blog/?p=44157 In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.IntroductionStarting in version 5.7.17-29.20 of Percona XtraDB Cluster significantly improved performance. Depending on the workload, the increase in throughput is in the range of 3-10x. (More details here). These optimization fixes also helped improve IST (Incremental State Transfer) performance. This blog is […]]]> https://www.percona.com/blog/faster-node-rejoin-improved-ist-performance/feed/ 3 44157 https://www.percona.com/blog/difference-error-handling-prepare-statement-binary-text-protocol-percona-xtradb-cluster-galera/ https://www.percona.com/blog/difference-error-handling-prepare-statement-binary-text-protocol-percona-xtradb-cluster-galera/#comments Wed, 05 Jul 2017 18:22:02 +0000 https://www.percona.com/blog/?p=43977 In this blog, we’ll look at the differences in how a PREPARE statement handles errors in binary and text protocols.IntroductionSince Percona XtraDB Cluster is a multi-master solution, when an application executes conflicting workloads one of the workloads gets rolled back with a DEADLOCK error. While the same holds true even if you fire the workload […]]]> https://www.percona.com/blog/difference-error-handling-prepare-statement-binary-text-protocol-percona-xtradb-cluster-galera/feed/ 2 43977 https://www.percona.com/blog/improved-wsrep-stages-and-related-instrumentation/ https://www.percona.com/blog/improved-wsrep-stages-and-related-instrumentation/#comments Mon, 24 Apr 2017 21:22:59 +0000 https://www.percona.com/blog/?p=42739 In this blog post, we’ll look at how we’ve improved wsrep-stages and related instrumentation in Percona XtraDB Cluster.IntroductionWhen you execute a workload and need to find out what the given thread is working on, “SHOW PROCESSLIST” comes to the top of your mind. It is an effective way to track the thread status. We decided to […]]]> https://www.percona.com/blog/improved-wsrep-stages-and-related-instrumentation/feed/ 2 42739 https://www.percona.com/blog/percona-xtradb-cluster-transaction-replay-anomaly/ Sun, 23 Apr 2017 16:05:42 +0000 https://www.percona.com/blog/?p=42726 In this blog post, we’ll look at a transaction replay anomaly in Percona XtraDB Cluster.IntroductionPercona XtraDB Cluster/Galera replays a transaction if the data is non-conflicting but, the transaction happens to have conflicting locks.AnomalyLet’s understand this with an example: Let’s assume a two-node cluster (node-1 and node-2) Base table “t” is created as follows: [crayon-664cc0135c51f338272921/] node-2 […]]]> 42726 https://www.percona.com/blog/beware-increasing-fc_limit-can-affect-select-latency/ Sun, 23 Apr 2017 02:22:36 +0000 https://www.percona.com/blog/?p=42716 In this blog post, we’ll look at how increasing the fc_limit can affect SELECT latency.IntroductionRecent Percona XtraDB Cluster optimizations have exposed fc_limit contention. It was always there, but was never exposed as the Commit Monitor contention was more significant. As it happens with any optimization, once we solve the bigger contention issues, smaller contention issues […]]]> 42716 https://www.percona.com/blog/tracking-ist-progress-in-percona-xtradb-cluster/ https://www.percona.com/blog/tracking-ist-progress-in-percona-xtradb-cluster/#comments Thu, 20 Apr 2017 20:33:56 +0000 https://www.percona.com/blog/?p=42732 In this blog post, we’ll look at how Percona XtraDB Cluster uses IST.IntroductionPercona XtraDB Cluster uses the concept of an Incremental State Transfer (IST). When a node of the cluster leaves the cluster for a short period of time, it can rejoin the cluster by getting the delta set of missing changes from any active node in […]]]> https://www.percona.com/blog/tracking-ist-progress-in-percona-xtradb-cluster/feed/ 2 42732 https://www.percona.com/blog/more-trackable-flow-control-for-percona-xtradb-cluster/ Thu, 20 Apr 2017 17:38:33 +0000 https://www.percona.com/blog/?p=42735 In this blog post, we’ll discuss trackable flow control in Percona XtraDB Cluster.IntroductionPercona XtraDB Cluster has a self-regulating mechanism called Flow Control. This mechanism helps to avoid a situation wherein the weakest/slowest member of the cluster falls significantly behind other members of the cluster.When a member of a cluster is slow at applying write-sets (while simultaneously continuing […]]]> 42735 https://www.percona.com/blog/how-we-made-percona-xtradb-cluster-scale/ Wed, 19 Apr 2017 21:46:36 +0000 https://www.percona.com/blog/?p=42656 In this blog post, we’ll look at the actions and efforts Percona experts took to scale Percona XtraDB Cluster.IntroductionWhen we first started analyzing Percona XtraDB Cluster performance, it was pretty bad. We would see contention even with 16 threads. Performance was even worse with sync binlog=1, although the same pattern was observed even with the binary […]]]> 42656 https://www.percona.com/blog/galera-cache-gcache-finally-recoverable-restart/ https://www.percona.com/blog/galera-cache-gcache-finally-recoverable-restart/#comments Wed, 30 Nov 2016 22:38:18 +0000 https://www.percona.com/blog/?p=39395 This post describes how to recover Galera Cache (or gcache) on restart.Recently Codership introduced (with Galera 3.19) a very important and long awaited feature. Now users can recover Galera cache on restart.NeedIf you gracefully shutdown cluster nodes one after another, with some lag time between nodes, then the last node to shutdown holds the latest data. […]]]> https://www.percona.com/blog/galera-cache-gcache-finally-recoverable-restart/feed/ 5 39395 https://www.percona.com/blog/webinar-qa-mysql-high-availability-percona-xtradb-cluster-5-7/ Tue, 22 Nov 2016 20:34:44 +0000 https://www.percona.com/blog/?p=39401 In this blog I will provide answers to the questions and queries that some of you have raised during the webinar on Nov 17th.I would like to say thank you to all of the audience who attended the talk on November 17, 2016. You can also check the recording and slides here.Q. How is storage distribution […]]]> 39401 https://www.percona.com/blog/all-you-need-to-know-about-gcache-galera-cache/ https://www.percona.com/blog/all-you-need-to-know-about-gcache-galera-cache/#comments Thu, 17 Nov 2016 01:21:40 +0000 https://www.percona.com/blog/?p=38214 This blog discusses some important aspects of GCache.Why do we need GCache?Percona XtraDB Cluster is a multi-master topology, where a transaction executed on one node is replicated on another node(s) of the cluster. This transaction is then copied over from the group channel to Galera-Cache followed by apply action.The cache can be discarded immediately once the transaction […]]]> https://www.percona.com/blog/all-you-need-to-know-about-gcache-galera-cache/feed/ 6 38214