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 Fernando Laudares Camargos | Aug 29, 2014 | MySQL, Percona Services, Percona Software
I was talking with a Percona Support customer earlier this week who was looking for Galera data on Percona Cloud Tools. (Percona Cloud Tools is a hosted service providing access to query performance insights for all MySQL uses.) The customer mentioned they were...
by Stephane Combaudon | Jul 25, 2014 | Insight for DBAs, MySQL, Percona Software
Monitoring flow control in a Galera cluster is very important. If you do not, you will not understand why writes may sometimes be stalled. Percona XtraDB Cluster 5.6 provides 2 status variables for such monitoring: wsrep_flow_control_paused and...
by Jay Janssen | May 8, 2014 | MySQL, Percona Software
Overview Percona XtraDB Cluster 5.6 has been GA for several months now and people are thinking more and more about moving from 5.5 to 5.6. Most people don’t want to upgrade all at once, but would prefer a rolling upgrade to avoid downtime and ensure 5.6 is...
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 | Jan 15, 2014 | MySQL, Webinars
I’ve been blogging a lot about some of the new things you can expect with Percona XtraDB Cluster 5.6 and Galera 3.x – and GA is coming soon. To get prepared, I’ll be giving a webinar on February 5th at 1PM EST/10AM PST to talk about some of the big...
by Jay Janssen | Dec 2, 2013 | MySQL, Percona Software
I get a lot of questions about Percona XtraDB Cluster 5.6 (PXC 5.6), specifically about whether such and such MySQL 5.6 Community Edition feature is in PXC 5.6. The short answer is: yes, all features in community MySQL 5.6 are in Percona Server 5.6 and, in turn, are...
by Jay Janssen | Nov 22, 2013 | MySQL
Now that Percona XtraDB Cluster 5.6 is out in beta, I wanted to start a series talking about new features in Galera 3 and PXC 5.6. On the surface, Galera 3 doesn’t reveal a lot of new features yet, but there has been a lot of refactoring of the system in...
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 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...
by Jay Janssen | Jun 14, 2012 | Benchmarks, MySQL, Percona Software
I have a customer who is considering Percona XtraDB Cluster (PXC) in a two colo WAN environment. They wanted me to do a test comparing PXC against semi-synchronous replication to see how they stack up against each other. Test Environment The test environment included...
