Buy Percona ServicesBuy Now!

ScaleArc: Benchmarking with sysbench

 | March 31, 2014 |  Posted In: Benchmarks, Insight for DBAs, MySQL, Percona Live, Percona MySQL Consulting

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 Uday Sawant (ScaleArc) and myself. You can also download the report directly as a PDF here. The goal of these benchmarks is to identify the potential overhead of the ScaleArc […]

Read More

Percona XtraBackup 2.2.1 alpha release is now available

 | March 28, 2014 |  Posted In: MySQL

Percona is glad to announce the release of Percona XtraBackup 2.2.1-alpha1 on March 28th 2014. Downloads are available from our download site here. This ALPHA release, will be available in our Debian experimental and CentOS testing repositories. This is an ALPHA quality release and it is not intended for production. If you want a high […]

Read More

Innodb redo log archiving

 | March 28, 2014 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Percona Server for MySQL, Percona XtraBackup

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 full scan of data files and comparison the data with backup data to find some delta. This approach […]

Read More

On TokuMX (and MongoDB) Replication and Transactions

 | March 28, 2014 |  Posted In: Tokutek, TokuView

In my last post, I describe the differences between a TokuMX oplog entry and a MongoDB oplog entry. One reason why the entries are so different is that TokuMX supports multi-statement and multi-document transactions. In this post, I want to elaborate on why multi-statement transactions cause changes to the oplog, and explain how we changed […]

Read More

Percona Server 5.6.16-64.2 with TokuDB engine Beta is now available

 | March 27, 2014 |  Posted In: Events and Announcements, Percona Server for MySQL, Percona Software

Percona is glad to announce the first BETA release of Percona Server 5.6.16-64.2 with TokuDB engine on March 27th, 2014. Downloads are available here and from the Percona Software Repositories. Based on Percona Server 5.6.16-64.2 including all the features and bug fixes in it, and on TokuDB 7.1.5-rc.4, Percona Server 5.6.16-64.2-tokudb is the first BETA […]

Read More

Lock Escalation and Big Transactions in TokuDB and TokuMX

 | March 27, 2014 |  Posted In: Tokutek, TokuView

We have seen TokuDB lock escalation stall the execution of SQL operations for tens of seconds. To address this problem, we changed the lock escalation algorithm used by TokuDB and TokuMX so that the cost of lock escalation only affects big transactions. We also eliminated a serialization point when running lock escalation. Transactions in TokuDB […]

Read More

A conversation with 5 Facebook MySQL gurus

 | March 27, 2014 |  Posted In: MySQL, Percona Live

Facebook, the undisputed king of online social networks, has 1.23 billion monthly active users collectively contributing to an ocean of data-intensive tasks – making the company one of the world’s top MySQL users. A small army of Facebook MySQL experts will be converging on Santa Clara, Calif. next week where several of them are leading […]

Read More

Comparing a TokuMX and MongoDB Oplog Entry

 | March 26, 2014 |  Posted In: Tokutek, TokuView

As I mentioned in my last post, TokuMX replication is completely incompatible with MongoDB replication. Replica sets (and sharded clusters, but that is for another blog) must be either entirely TokuMX or entirely MongoDB. This is by design. While elections and failover are basically the same, we have completely changed the oplog protocol. In the […]

Read More