MySQL 5.6 includes a host of enhancements to replication, enabling DevOps teams to reliably scale-out their MySQL infrastructure across commodity hardware, on-premise or in the cloud.

One of the most significant enhancements is the introduction of Global Transaction Identifiers (GTIDs) where the primary development motivation was:

href="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/04/tape-machine_replay.jpg"> class="alignright size-medium wp-image-14250" style="margin: 12px;" alt="Percona Playback for MySQL" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/04/tape-machine_replay-300x225.jpg" width="300" height="225" />Percona is glad to announce the release of Percona Playback 0.6 for MySQL on April 9, 2013.

This is a simple step-by-step introduction to rdebug: Debugger and Debugging API for MySQL Stored Routines, as part of common_schema.

In other words: let me take you through the steps for debugging your stored routines on your own server. We will step into, step over, step out, modify variables, set a breakpoint, run to breakpoint...

href="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/04/calculator.jpg"> class="alignright size-medium wp-image-14244" style="margin: 12px;" alt="Understanding the maximum number of columns in a MySQL table" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/04/calculator-300x207.jpg" width="300" height="207" />This post was initially going to be two sets of polls: “What is the maximum number of columns in MySQL?” and “What is the minimum maximum number of columns in MySQL?”.