Diamond Notes

MySQL 5.1 Features

• table/index partitioning   — not parallel, key has to be of a numeric value and no foreign keys
• row-based/hybrid replication — hybrid replication is the default and is changeable on the fly
• disk-based cluster tables
• built-in job scheduler (events) — replacement for cron etc.
• problem SQL identification — dynamic tracing via slow query log and can be logged
• faster full-text search
• archive engine improvements

RC 5.1.24 (Enterprise only I believe) available at conference

GA schedulted for the end of Q2 2008

MySQL 6.0 Features

• Falcon — user defined tablespaces
• maria
• online backups
• optimizer enhancements

scheduled for the end of 2008 (but I am making NO bets on it!! )

It looks like MySQL is beginning to de-couple cluster from the base server project.  They have a roadmap of cluster products through the rest of this year and into next year.  I think this is a great plan since the cluster product/engine is so different from everything else.

memcached will be offered support under MySQL Enterprise
MySQL 6.X — “citadel” mid to end 2009 is the plan

• foreign keys on all engines
• better prepared statements
• better server-side cursors
• replication improvements (checksums)
• data auditing
• external authentication
• security groups/roles
• transparent data encryption
• online alter table

Rob Young is talking about the enterprise products.