SQL Zone | The social network for developers

Peter Zaitsev05/09/13
408 views
0 replies

MySQL and Percona Server in LinkBench benchmark

Around a month ago Facebook announced the Linkbench benchmark that models the social graph OLTP workload. We decided to run this benchmark for MySQL Server 5.5.30, 5.6.11

Peter Zaitsev05/08/13
527 views
0 replies

Benchmarking Percona Server TokuDB vs InnoDB

After compiling Percona Server with TokuDB, of course I wanted to compare InnoDB performance vs TokuDB.

Peter Zaitsev05/05/13
599 views
0 replies

Percona XtraDB Cluster for MySQL and encrypted Galera replication

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.

Peter Zaitsev05/04/13
499 views
0 replies

Galera Flow Control in Percona XtraDB Cluster 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 covering flow control because it is important to understand.

Steven Lott05/03/13
3192 views
0 replies

Legacy Code Preservation: Paving the Cowpaths

The phrase refers to the way cows tend to meander across the landscape in a remarkably consistent way. The cows reliably follow a consistent path. The paths tend to wander in ways that seem crazy to us.

Sean Hull05/01/13
652 views
0 replies

Make MySQL clustering work for you

We’ve told you all about MySQL mult-master replication’s limitations. If you write to two masters it is bound to fail for myriad reasons. Now what? Do what the pros do, that’s what!

Eric Genesky04/27/13
2567 views
0 replies

MySQL on AWS 101

This slideshow from Anders Karlsson helps you get MySQL running on AWS by revealing how to take full advantage of EC2.

Peter Zaitsev04/26/13
818 views
0 replies

More on transactions descriptors optimization

Since our first post on transaction descriptors optimization introduced in Percona Server 5.5.30-30.2 and a followup by Dimitri Kravchuk we have received a large number of questions on why the benchmark results in both posts look rather different.

Allen Coin04/24/13
3791 views
0 replies

Links You Don't Want to Miss (Apr. 24)

Today: a huge collection of JavaScript patterns, a developer reflects on burning out, BitTorrent's new Dropbox competitor, Eric Schmidt and Julian Assange have a chat, and what school lunches look like when your dad is a graphic designer.

Peter Zaitsev04/24/13
879 views
0 replies

High-load problems? Investigate them with ‘pt-query-digest’

I had the chance to work on an interesting case last week, and I thought I’d share what I think is a little known goodie from Percona Toolkit for MySQL called pt-query-digest.

Peter Zaitsev04/23/13
766 views
0 replies

MySQL alternative Percona Server 5.1.68 -14.6 now available

Percona is glad to announce the release of Percona Server 5.1.68 -14.6 on April 19, 2013 (downloads are available here and from the Percona Software Repositories).

Peter Zaitsev04/23/13
769 views
0 replies

How to recover table structure from InnoDB dictionary

To recover a dropped or corrupt table with Percona Data Recovery Tool for InnoDB you need two things: media with records(ibdata1, *.ibd, disk image, etc.) and a table structure.

Peter Zaitsev04/22/13
1021 views
0 replies

Rotating MySQL slow logs safely

In my last post, I described a solution for keeping the caches of a MySQL standby server hot using MySQL slow logs with long_query_time set to 0. Here are a some lessons we learned when logging a high volume of queries to the slow log.

Peter Zaitsev04/22/13
1077 views
0 replies

The write cache: Swap insanity tome III

Swapping has always been something bad for MySQL performance but it is even more important for HA systems. It is so important to avoid swapping with HA that NDB cluster basically forbids calling malloc after the startup phase and hence its rather complex configuration.

Peter Zaitsev04/21/13
1120 views
0 replies

Disconnecting a replication slave is easier with MySQL 5.5+

MySQL provides the handy RESET SLAVE command. But as we’ll see, its behavior has changed along with the MySQL versions and it’s easy to shoot yourself in the foot if you use it incorrectly. So how do you safely disconnect a replication slave?