by Jay Janssen | Jul 6, 2015 | MySQL, Percona Software
I noticed that in the latest release of Percona XtraDB Cluster (PXC), the behavior of wsrep_OSU_method changed somewhat. Prior to this release, the variable was GLOBAL only, meaning to use it you would: mysql> set GLOBAL wsrep_OSU_method='RSU'; mysql> ALTER...
by Sveta Smirnova | Jun 30, 2015 | Cloud, Insight for DBAs, MySQL, Percona Software
Like any good, thus lazy, engineer I don’t like to start things manually. Creating directories, configuration files, specify paths, ports via command line is too boring. I wrote already how I survive in case when I need to start MySQL server (here). There is...
by Stephane Combaudon | Jun 23, 2015 | MySQL, Percona Software
A question I often hear when customers want to set up a production PXC cluster is: “How many nodes should we use?” Three nodes is the most common deployment, but when are more nodes needed? They also ask: “Do we always need to use an even number of...
by Michael Coburn | Jun 19, 2015 | Cloud, MySQL, Percona Software, Webinars
Last week I hosted a webinar on using MySQL in the cloud for High Availability (HA) alongside 451 Research analyst Jason Stamper. You can watch the recording and also download the slides (free) here. Just click the “Register” button at the end of that...
by Stephane Combaudon | Jun 12, 2015 | MySQL
Percona XtraDB Cluster (PXC) has become a popular option to provide high availability for MySQL servers. However many people are still having a hard time understanding what will happen to the cluster when one or several nodes leave the cluster (gracefully or...
by Stephane Combaudon | Jun 3, 2015 | Insight for DBAs, MySQL, Percona Software
Some applications have a heavy write workload on a few records – for instance when incrementing a global counter: this is called a write hotspot. Because you cannot update the same row simultaneously from multiple threads, this can lead to performance...
by Tom Diederich | May 6, 2015 | MySQL, Percona Events
Percona CEO Peter Zaitsev and Big Data guru Alexander Rubin will be speaking at Meetups along the East Coast next week with stops in Boston (May 11), New York City (May 12), Philadelphia (May 13) and Baltimore (May 14). Dubbed the “MySQL Whistle-Stop Tour” since...
by Nik Vyzas | Mar 3, 2015 | Cloud, MySQL, Percona Software
As the need for information grows so does the size of data we need to keep in our databases. SST is unavoidable for spinning up new nodes in a PXC cluster and when datasets reach the “terra-byte” range this becomes ever more cumbersome requiring many hours...
by Fernando Laudares Camargos | Feb 20, 2015 | Insight for DBAs, MySQL, Percona Software
This past week was marked by a series of personal findings related to the use of Global Transaction IDs (GTIDs) on Galera-based clusters such as
by Stephane Combaudon | Feb 13, 2015 | MySQL, Percona Software
Say you have a cluster with 3 nodes using Percona XtraDB Cluster (PXC) 5.6 and one asynchronous replica connected to node1. If asynchronous replication is using GTIDs, moving the replica so that it is connected to node2 is trivial, right? Actually replication can...
by Ernie Souhrada | Sep 9, 2014 | Insight for DBAs, MySQL, Percona Software
A common migration path from standalone MySQL/Percona Server to a Percona XtraDB Cluster (PXC) environment involves some measure of time where one node in the new cluster has been configured as a slave of the production master that the cluster is slated to replace. In...
by Przemysław Malkowski | Sep 1, 2014 | Insight for DBAs, MySQL, Percona Software
Galera replication for MySQL brings not only the new, great features to our ecosystem, but also introduces completely new maintenance techniques. Are you concerned about adding such new complexity to your MySQL environment? Perhaps that concern is unnecessarily. I am...
by David Busby | May 16, 2014 | Benchmarks, Insight for DBAs, MySQL
Github user Adrianlzt provided a python-twisted alternative version of pyclustercheck per discussion on issue 7. Due to sporadic performance issues noted with the original implementation in SimpleHTTPserver, the benchmarks which I’ve included as part of the...
by Raghavendra | Feb 21, 2014 | MySQL, Percona Software
I spoke last month at linux.conf.au 2014 in Perth, Australia, and one of my sessions focused on the “Continuous Integration (CI) testing of Percona XtraDB Cluster (PXC)” at the Developer,Testing, Release and CI miniconf. Here is the video of the...
by Jay Janssen | Oct 31, 2013 | MySQL, Percona Software
The Percona Monitoring Plugins (PMP) provide some free tools to make it easier to monitor PXC/Galera nodes. Monitoring broadly falls into two categories: alerting and historical graphing, and the plugins support Nagios and Cacti, respectively, for those purposes....
by Jay Janssen | Sep 23, 2013 | MySQL, Percona Software
Percona XtraDB Cluster (PXC) is different enough from async replication that it can be a bit of a puzzle how to do things the Galera way. This post will attempt to illustrate the basics of setting up 2 node PXC cluster from scratch. Requirements Two servers (could be...
by Raghavendra | Jun 17, 2013 | MySQL, Percona Software
The aim of this post is to enumerate real-world usage of Percona XtraDB Cluster (PXC), and also to solicit use cases from the readers. One of the prominent usages in the production environment that we have come across (and our Percona consultants have assisted) is...
by Ernie Souhrada | May 28, 2013 | Insight for DBAs, MySQL, Percona Events, Webinars
Selecting the most appropriate solution for a MySQL HA infrastructure is as much a business and philosophical decision as it is a technical one, but often the choice is made without adequately considering all three perspectives. When too much attention is paid to one...
by Jay Janssen | May 14, 2013 | MySQL, Percona Software
I talk with lot of people who are really interested in Percona XtraDB Cluster (PXC) and mostly they are interested in PXC as a high-availability solution. But, what they tend not to think too much about is if moving from async to synchronous replication is right for...
by Jervin Real | May 1, 2013 | Insight for DBAs, MySQL, Percona Software
Galera/Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump right in without enough testing. Consequently, they’re more likely to either suffer failure or issues that prevent them from moving forward. If you are thinking of...
