by Tom Diederich | Sep 1, 2015 | MySQL, Percona Live
Booking.com, one of the world’s leading e-commerce companies, helps travels book nearly 1 million rooms per night. Established in 1996, Booking.com B.V. guarantees the best prices for any type of property, from small, family-run bed and breakfasts to executive...
by Jay Janssen | Aug 20, 2015 | MySQL, Percona Software
State Snapshot Transfer (SST) at a glance PXC uses a protocol called State Snapshot Transfer to provision a node joining an existing cluster with all the data it needs to synchronize. This is analogous to cloning a slave in asynchronous replication: you take a full...
by Stephane Combaudon | Aug 19, 2015 | MySQL
I have heard this question quite often: “At busy times, our replicas start lagging quite frequently. We are using N schemas, so which performance boost could we expect from MySQL 5.6 parallel replication?” Here is a quick way to give you a rough estimate...
by Stephane Combaudon | Aug 7, 2015 | Benchmarks, MySQL
During the last couple of months I have been involved in an unusually high amount of performance audits for e-commerce applications running with Magento. And although the systems were quite different, they also had one thing in common: the MySQL query cache was very...
by Jay Janssen | Aug 5, 2015 | MySQL, Percona Software
IST Basics State transfers in Galera remain a mystery to most people. Incremental State transfers (as opposed to full State Snapshot transfers) are used under the following conditions: The Joiner node reports Galera a valid Galera GTID to the cluster The Donor node...
by Sveta Smirnova | Jul 30, 2015 | MySQL
Lately, I saw many cases when users specified the option --base64-output=DECODE-ROWS to print out a statement representation of row events in MySQL binary logs just to get nothing. Reason for this is obvious: option --base64-output=DECODE-ROWS does not convert row...
by Francisco Bordenave | Jul 29, 2015 | Benchmarks, Insight for DBAs, MySQL
MySQL 5.7 comes with a new set of features and multi-source replication is one of them. In few words this means that one slave can replicate from different masters simultaneously. During the last couple of months I’ve been playing a lot with this trying to...
by Vadim Tkachenko | Jul 24, 2015 | Benchmarks, MySQL, Percona Software
Previously I tested Tokutek’s Fractal Trees (TokuMX & TokuMXse) as MongoDB storage engines – today let’s look into the MySQL area. I am going to use modified LinkBench in a heavy IO-load. I compared InnoDB without compression, InnoDB with 8k...
by Akshay Suryawanshi | Jul 23, 2015 | Hardware and Storage, Insight for DBAs, MySQL, Webinars
Thank you for attending my July 15 webinar, “Creating Best in Class Backup solutions for your MySQL environment.” Due to the amount of content we discussed and some minor technical difficulties faced near the end of webinar we have decided to cover the...
by Stephane Combaudon | Jul 22, 2015 | MySQL, Percona Software
I recently worked with a customer who had a weird issue: when their MySQL server was started (Percona Server 5.5), if they try to run service mysql start a second time, the init script was not able to detect that an instance was already running. As a result, it tried...
by Jay Janssen | Jul 16, 2015 | MySQL, Percona Software
In my previous post, I used incremental backups in Percona XtraBackup as a method for rebuilding a Percona XtraDB Cluster (PXC) node without triggering an actual SST. Practically this reproduces the SST steps, but it can be handy if you already had backups available...
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 Fernando Ipar | Jul 9, 2015 | Insight for DBAs, MySQL
I recently helped a customer figure out why a minor version MySQL upgrade was indicating that some tables needed to be rebuilt. The mysql_upgrade program should be run for every upgrade, no matter how big or small the version difference is, but when only the minor...
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 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 Miguel Angel Nieto | Jun 18, 2015 | Insight for DBAs, MySQL
When a new version of MySQL is about to be released we read a lot of blog posts about the performance and scalability improvements. That’s good but sometimes we miss some small features that can help us a lot in our day-to-day tasks. One good example is the blog...
by Yves Trudeau | Jun 17, 2015 | Benchmarks, Hardware and Storage, MySQL
IMPORTANT: DON’T TRY THIS IN PRODUCTION. As demonstrated by Marko (see comments), it may corrupt your data. In a post, written a few months ago, I found that using EXT4 transactions with the “data=journal” mount option, improves the write performance...
by David Ducos | Jun 15, 2015 | MySQL
We usually try to avoid subselects because sometimes they force the use of a temporary table and limits the use of indexes. But, when is good to use a subselect? This example was tested over table a (1310723 rows), b, c and d ( 5 rows each) and with MySQL version 5.5...
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...
