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:... 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... 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... 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... 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... 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... 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 | Oct 15, 2013 | MySQL
Percona XtraDB Cluster (PXC) itself manages quorum and node failure. Minorities of nodes in a network partition situation will move themselves into a Non-primary state and not allow any DB activity. Nodes in such a state will be easily detectable via SHOW... by Jay Janssen | Oct 8, 2013 | MySQL, Percona Software
I occasionally see customers who are taking backups from their PXC clusters that complain that the cluster “stalls” during the backup. As I wrote about in a previous blog post, often these stalls are really just Flow Control. But why would a... 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... by Jay Janssen | Aug 16, 2013 | Insight for DBAs, MySQL, Webinars
My colleague and teammate Ernie Souhrada will be presenting a webinar on Wednesday, August 21, 2013 at 10 a.m. PDT titled “MySQL Security: Armoring Your Dolphin.”This is a popular topic with news breaking routinely that yet another Internet company has... by Jay Janssen | Jul 4, 2013 | MySQL, Webinars
Thanks to all who attended my PXC Operations webinar last week. If you missed it you can watch the video here.I wanted to take some time to answer the questions I didn’t get to during the broadcast. Is there an easy way to leverage the xtrabackup SST and... 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... 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... by Jay Janssen | May 3, 2013 | Percona Software
Few people realize that Galera/Percona XtraDB (PXC) replication can be encrypted via SSL for secure transfer of your replicated data. Setting this up is actually quite easy to do and probably will look familiar to a lot of people. Setting up SSL and Galera... 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... 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....