Maybe You Should Try Taking a Walk in My Shoes

The title of this post should really be, “Maybe He Should Try Taking a Walk in Your Shoes.”
The he I’m referring to is economist and author, Tim Harford. The you is the people who use NewSQL and NoSQL approaches to mine big data with database platforms like MySQL and MongoDB (or, preferably, our high-performance […]

Read more

Parallel Query for MySQL with Shard-Query

While Shard-Query can work over multiple nodes, this blog post focuses on using Shard-Query with a single node.  Shard-Query can add parallelism to queries which use partitioned tables.  Very large tables can often be partitioned fairly easily. Shard-Query can leverage partitioning to add paralellism, because each partition can be queried independently. Because MySQL 5.6 supports […]

Read more

Galera 3.5 for Percona XtraDB Cluster 5.6 is now available

Galera 3.5 improvements are now available for use with Percona XtraDB Cluster 5.6.
Bugs fixed in Galera 3.5 include:

A crash due to of-by-one error in certification index cleanup has been fixed. Bugs fixed #1309227 and #1267507.
Fixed the corruption in gcache that could lead to a cluster crash. Bugs fixed #1301616 and #1152565.
Joining node crashed under […]

Read more

ScaleArc: Real-world application testing with WordPress (benchmark test)

ScaleArc recently hired Percona to perform various tests on its database traffic management product. This post is the outcome of the benchmarks carried out by me and ScaleArc co-founder and chief architect, Uday Sawant.
The goal of this benchmark was to identify ScaleArc’s overhead using a real-world application – the world’s most popular (according to […]

Read more

Thoughts on Small Datum – Part 2

If you did not read my first blog post about Mark Callaghan’s (@markcallaghan) benchmarks as documented in his blog, Small Datum, you may want to skim through it now for a little context.
——————-
On March 11th, Mark, a former Google and now Facebook database guru, published an insertion rate benchmark comparing MySQL outfitted with the […]

Read more