MySQL 5.6 Transportable Tablespaces Example

Transportable tablespaces allows copying individual InnoDB tables from one MySQL instance to another.

Here is a basic example of it's usage.

Oracle and Flashback Retention

Interestingly, I had a database that was running a large load of data.  I was running across issues with space.

MySQL Enterprise Backup (MEB) 3.8 and Tracing

The new 3.8 feature of tracing is very useful.  I have been looking at where performance is worse and using tracing is very handy.

Running a SQL Script on Startup

Running sql on startup is something Oracle does via STARTUP trigger.  This can also be done via my MySQL but requires some extra steps

MySQL Enterprise Backup (MEB) 3.8 and Parallel Performance

I am currently looking at the newest version of MEB.  I have some experience of 3.7 and was keen to experiment the new version

SQL_MODE Parameter Change in 5.6

This setting has changed from 5.5 to 5.6, it includes strict_trans_tables - sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES.

Mysql 5.6 upgrade (from 5.5) single and replicated instance.

I have been working on an upgrade path from 5.5. to 5.6.  The MySQL documentation is good and explains what could be a muliple phase upgrade to get to 5.5 to then upgrade to 5.6, see

http://dev.mysql.com/doc/refman/5.5/en/upgrading.html

Here are few notes which I hope helps.  There looks to be two ways to upgrade from 5.5 to 5.6. 

• Import/Export
• Binary Upgrade

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.