by Stephane Combaudon | Jul 21, 2014 | Insight for DBAs, MySQL, Percona Software
I recently worked on a case where one node of a Galera cluster had its schema desynchronized with the other nodes. And that was although Total Order Isolation method was in effect to perform the schema changes. Let’s see what happened. Background For those of...
by Jervin Real | Jul 16, 2014 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
This is the second part of my series on High Availability with mysqlnd_ms. In my first post, “Simple MySQL Master HA with mysqlnd_ms,” I showed a simple HA solution using asynchronous MySQL replication. This time we will see how to leverage an all-primary...
by Jericho Rivera | Jun 20, 2014 | Cloud, Insight for DBAs, MySQL, Percona Software
In my Percona ClusterControl and add the existing Patrick Galbraith’s blog series about Docker.
by Jay Janssen | May 21, 2014 | Insight for DBAs, MySQL, Percona Software
I’ve had the opportunity to train lots of people on Percona Live MySQL Conference and Expo in Santa Clara, California for the last two years. Baron even attended this year and had this say: “Jay Janssen’s tutorial on Percona XtraDB Cluster was impressive....
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 Miguel Angel Nieto | Apr 1, 2014 | Insight for DBAs, MySQL, Percona Software
In my last blog post I explained how to use Percona ClusterControl to create a new Percona XtraDB Cluster from scratch. That’s a good option when you want to create a testing environment in just some mouse clicks. In this case I’m going to show you how to...
by Vlad Lesin | Mar 28, 2014 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Percona Server 5.6.11-60.3 introduces a new “log archiving” feature. Percona XtraBackup 2.1.5 supports “apply archived logs.” What does it mean and how it can be used? Percona products propose three kinds of incremental backups. The first is...
by Peter Boros | Feb 26, 2014 | Insight for DBAs, MySQL, Percona Services, Percona Software, Webinars
First of all we would like to thank all of you who attended the Feb. 19 MySQL webinar, “Performance Monitoring and Troubleshooting of Percona XtraDB Cluster.” We got some really good questions – many of which we didn’t have time to address...
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 Miguel Angel Nieto | Feb 17, 2014 | MySQL, Percona Software
We recently announced Percona ClusterControl supplied in partnership with Severalnines. This enterprise-grade cluster management and monitoring software is available with a Percona Support contract covering Percona XtraDB Cluster, MySQL Cluster, or MySQL Galera. In...
by Bill Karwin | Feb 12, 2014 | Insight for DBAs, Webinars
January 22 I gave a presentation on “How to Avoid Common (but Deadly) MySQL Operations Mistakes” for Percona MySQL Webinars. If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended, and especially to...
by Jervin Real | Jan 17, 2014 | Insight for DBAs, MySQL
This is a followup to Jay Janssen’s October post, “HaProxy would. keepalived is a simple load balancer with HA capabilities, which means it can proxy TCP services behind it and at the same time, keep itself highly available using VRRP as failover...
by Yves Trudeau | Jan 10, 2014 | Insight for DBAs, MySQL, Percona Software
Most technologies achieving high-availability for MySQL need a load-balancer to spread the client connections to a valid database host, even the Tungsten special connector can be seen as a sophisticated load-balancer. People often use hardware load balancer or...
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 Yves Trudeau | Nov 20, 2013 | Insight for DBAs, MySQL
It is a rather frequent problem to have to manage Virtual IP addresses (VIPs) with a Percona XtraDB Cluster (PXC) or with MySQL master HA (MHA). In order to help solving these problems, I wrote a Pacemaker agent, mysql_monitor that is a simplified version 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 Yves Trudeau | Oct 23, 2013 | Insight for DBAs, MySQL, Percona Software
The technologies allowing to build highly-available (HA) MySQL solutions are in constant evolution and they cover very different needs and use cases. In order to help people choose the best HA solution for their needs, we decided, Jay Janssen and I, to publish, on a...
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 GLOBAL...
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...
