by Jay Janssen | Jul 16, 2015 | MySQL, Percona Software
Beware the SST In Percona XtraDB Cluster (PXC) I often run across users who are fearful of SSTs on their clusters. I’ve always maintained that if you can’t cope with a SST, PXC may not be right for you, but that doesn’t change the fact that SSTs with...
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 Jim Doherty | Jun 25, 2015 | MySQL
Oracle was in the news recently with the story of its license revenue declining as much as 17% in the recent quarter. This is blamed on transitioning to the cloud in some publications, but others, such as Bloomberg and TechRepublic, look deeper, seeing open source...
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 Stephane Combaudon | Apr 28, 2015 | Insight for DBAs, MySQL, Percona Software
I often talk with people who are very interested in the features of Percona XtraDB Cluster (PXC) such as synchronous and parallel replication, multi-node writing and high availability. However some get confused when operating a real PXC cluster because they do not...
by Matt Griffin | Apr 8, 2015 | Insight for DBAs, MySQL, Percona Live, Percona Software
In April and May, Percona will hold and participate in two OpenStack events: OpenStack Summit. Join our talks at these events in Santa Clara and Vancouver for new insights into the MySQL operations of the core of OpenStack as well as the latest information on MySQL...
by Matt Griffin | Mar 24, 2015 | MySQL, Percona Live, Percona Services, Percona Software
Percona Toolkit is one of our most mature open source applications. Derived from Maatkit and Aspersa, Percona Toolkit has evolved significantly over the years. The software now contains 32 tools, over 4,000 tests, and has been downloaded over 250,000 times. Anyone who...
by Stephane Combaudon | Mar 13, 2015 | Insight for DBAs, MySQL, Percona Software, Webinars
My webinar “Multi-threaded Replication in MySQL 5.6 and 5.7” on February 25 generated several excellent questions following the presentation (available an online migration to GTIDs and that’s why here.
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 Matt Griffin | Feb 18, 2015 | Insight for DBAs, MySQL, Percona Events
Percona has submitted seven talks for the next Voting ends February 23, and if you aren’t already an OpenStack Foundation member (required to vote), you can join now for free MySQL and OpenStack Deep Dive Speakers: Peter Boros, Jay Pipes (Mirantis) MySQL on Ceph...
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 Stephane Combaudon | Dec 30, 2014 | MySQL, Percona Software
State Snapshot Transfer (SST) is used in Percona XtraDB Cluster (PXC) when a new node joins the cluster or to resync a failed node if Incremental State Transfer (IST) is no longer available. SST is triggered automatically but there is no magic: If it is not configured...
by Jay Janssen | Dec 22, 2014 | MySQL, Percona Software
Background on Backup Locks I was very excited to see Backup locks support in release notes for the latest Percona XtraDB Cluster 5.6.21 release. For those who are not aware, backup locks offer an alternative to FLUSH TABLES WITH READ LOCK (FTWRL) in
by Stephane Combaudon | Dec 18, 2014 | Insight for DBAs, MySQL, Percona Software
HAProxy is frequently used as a software load balancer in the MySQL world. Peter Boros, in a past post, explained how to set it up with Percona XtraDB Cluster (PXC) so that it only sends queries to available nodes. The same approach can be used in a regular...
