Update on the Multi-threaded Slave

A few months have passed since we announced our MySQL 5.6.2 DM based feature preview - Multi-threaded Slaves (MTS) - back in April. Since then, we have had some very good feedback from all around. You deserve a big thank you.

We have now a new snapshot available on labs.mysql.com. This snapshot includes:

• Bug fixes. A lot of them, both in the server core and in the replication layer, especially at the MTS layer.
• Sound recovery procedure. The recovery procedure, which runs on slave threads (re)start, has been improved significantly.
• STOP SLAVE consistently. We have made STOP SLAVE to stop at a consistent point with respect to the master execution history. There were quite a few requests to implement this behavior. That said, one can still stop the SQL thread immediately if one KILLs the SQL thread.
• Enhanced SBR replication. In multi-threaded mode, in particular, support for temporary tables replication was added.
• Usability improvements. There is now a simplified set of configuration options which will make DBAs life easier.
• Improved codebase. Following an effort on codebase clean up and related refactorings, the multi-threaded slave code is now easier to maintain.
  

Please, give the latest snapshot a spin and let us know how it goes!

These are exciting times... Not only MTS is coming, some very cool replication features are also on their way, such as binary log group commit and an API for inspecting binary logs:

http://www.oracle.com/us/corporate/press/439460

You can find these feature previews next to the MTS snapshot on labs.mysql.com as well.

Enjoy!