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 Jay Janssen | May 6, 2014 | MySQL, Percona Software
Whither your rollback plan? MySQL 5.6 upgrades are in full swing these days and knowing how to safely upgrade from MySQL 5.5 to 5.6 is important. When upgrading a replication environment, it’s important that you can build a migration plan that safely allows for...
by Jay Janssen | Feb 7, 2014 | MySQL, Webinars
Thanks to all who attended my webinar yesterday. The slides and recording are available on the webinar’s page. I was a bit overwhelmed with the amount of questions that came in and I’ll try to answer them the best I can here. Q: Does Percona XtraDB...
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 | Jan 8, 2014 | MySQL
Gcache and IST The Gcache is a memory-based cache of recent Galera transactions that is local to each node in a cluster. If a node leaves and rejoins the cluster, it can use the gcache from another node that stayed in the cluster (i.e., its donor node) to fetch the...
by Jay Janssen | Dec 19, 2013 | MySQL
A decade ago MySQL folks were in love with the concept of a relay slave for MySQL high availability across data centers. A relay is a single slave in a remote data center that receives replication from the global master and, in turn, replicates to all the other local...
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 17, 2013 | MySQL
Checking throughput with async MySQL replication Replication throughput is the measure of just how fast the slaves can apply replication (at least by my definition). In MySQL async replication this is important to know because the single-threaded apply nature of...
by Jay Janssen | Jun 21, 2013 | MySQL, Percona Software
Async and PXC A common question I get about Percona XtraDB Cluster is if you can mix it with asynchronous replication, and the answer is yes! You can pick any node in your cluster and it can either be either a slave or a master just like any other regular MySQL...
by Jay Janssen | Jun 18, 2013 | Percona Events, Percona Software
Percona XtraDB Cluster (PXC) was released over a year ago and since then there has been tremendous interest and adoption. There’s plenty of talks that explain the fundamentals of PXC, but we’re starting to reach a threshold where it’s easier to find...
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 Jay Janssen | May 2, 2013 | Insight for DBAs, Percona Live, Percona Software
Last week at Percona Live, I delivered a six-hour tutorial about Percona XtraDB Cluster (PXC) for MySQL. I actually had more material than I covered (by design), but one thing I regret we didn’t cover was Flow control. So, I thought I’d write a post...
by Jay Janssen | Apr 1, 2013 | Percona Live, Percona Software
As is typical at the beginning of every April, many of us who submitted talks to the Percona Live MySQL Conference and Expo are wondering why we submitted so many. I had 3 official talks selected, including one that is a 6-hour tutorial, as well as a BoF....
by Jay Janssen | Feb 12, 2013 | MySQL, Percona Events, Percona Live
I’ve been woefully neglectful of my responsibilities to post regularly about Percona Live MySQL Conference and Expo 2013 (PLCME 2013), but here’s some highlights of what I am planning to attend from the schedule. Read to the very bottom for the chance to...
