Replaying database load with Percona Playback

Average: 9 (6 votes)

Percona Playback is a new tool for taking a general or slow query log produced by one database server and replaying that load against another. It is designed to help evaluate new server versions, patches and hardware against existing setups to allow users to make an informed choice about delpoying changes to their database infrastructure.

In this session we will:
- Go over ways to capture database load
- Examine the flaws in each way to capture load
- Cover basic use of Percona Playback
- Cover how the load generated by Playback may differ from the original load
- Cover roadmap of future features for Percona Playback

Experience level: 

Schedule info

Time slot: 
11 April 13:00 - 13:50
Ballroom A

Schedule Info

11 April 13:00 - 13:50 @
Ballroom A


Stewart Smith's picture
Director of Server Development, Percona

Stewart Smith joined Percona in 2011 as Director of Server Development with a deep background in database internals including MySQL, MySQL Cluster, Drizzle, InnoDB and HailDB.

Prior to joining Percona, Stewart worked at Rackspace on the Drizzle database server focusing on getting it through a critical milestone of a stable Generally Available (GA) release. Prior to Rackspace, he worked on Drizzle as a member of the CTO Labs group inside Sun Microsystems.

As one of the founding core developers of the Drizzle database server Stewart has deep expertise in the code base. He had direct involvement in significant refactoring of the database server including removing the FRM, the InnoDB storage engine, xtrabackup, the storage engine API, CATALOG support and countless bug fixes. He also maintains HailDB, a shared library offering a NoSQL C API directly to InnoDB.

At Sun Microsystems, and MySQL before that, Stewart was a Senior Software Engineer in the MySQL Cluster team working on core code and features inside the MySQL Server and the Cluster codebase working on projects such as: geographical asynchronous replication, online add node, online backup, NDBINFO for improved monitoring and the Win32 port.

He’s been found speaking at MySQL User Conferences,, OSCON, OSDC, SAGE-AU and more.


Sponsored By