MySQL Multi threaded Replication

The general architecture is using 'slave' worker threads on the slave machine to process replicated transactions to the slave databases. 


MySQL Enterprise Backup (MEB) 3.7 - Backup and Restore Examples

I have been working with MEB and put a few examples of working with MEB on-line.  It's not a comprehensive list of everything MEB does but hopefully will be enough to get things started.  For a more comprehensive information please see the documentation.
http://dev.mysql.com/doc/mysql-enterprise-backup/3.8/en/index.html

MySQL 5.6 DateTime Column Type


Whilst migrating a table I found an interesting thing.  The table contained a datetime field and the plan was to migrate directly from 5.5 to 5.6.  The method I choose was to SELECT INTO....OUTFILE (mainly because the table was large, over 1 billion rows, and is partitioned).  As I was loading the data into the table using LOAD INFILE it was thoroughing out errors:

ERROR 1292 (22007): Incorrect datetime value: '1970-01-01 00:00:00' for column 'publish_date' at row 2374801

Interestingly enough the earliest time the column can have is '1970-01-01 00:00:01' UTC. 

MySQL has annonced that 5.6 is now GA.