Digital (dis)content: MySQL conference in Paris

Nov 19, 2008

MySQL conference in Paris - MySQL roadmap

I attended the MySQL conference in Paris today.

As always, presentations are kind of hit & miss. The best one was by far the MySQL Roadmap by Robin Schumacher, Director of Product Management at MySQL. Here's my (very raw) transcript.

MySQL Server 5.1

Faster : 11-18% over 5.0 (internal MySQL QA tests)
New features ( list @ MySQL.com)
- Table/index partitioning : range, hash, key, list, composite
  - Partition pruning : only needed partitions are
    examined
- Replication : statement-based, row-based, hybrid
  - Not only statement based replication (ex: random
    number generation)
  - Actual replication on row data
- Built-in scheduler
- Identification of SQL problems
  - Query logs can be activated dynamically (no restart required)
  - Query tuning
GA scheduled for CY Q42008

MySQL Server 6.0

Falcon engine : transactional engine
- Not an InnoDB replacement (i.e. configuration files are different)
- ACID transactions
- Crash recovery
- Record-based cache, not page-based
New backup features
- SQL-command driver interface
- Online, non-blocking for DML operations
- Native driver --> faster backup (about 75%
  compared to mysqldump, about 90% for recovery)
- All general engines supportes, except cluster
Optimizer enhancements
Replication
- Semi-sync replication
- Ensure commited slave
- Replication heartbeat

MySQL Entreprise

memcached part of MySQLEnterprise
MySQL Workbench : data modeling / database generation tool
zmanda : backup tool
MySQL query analyzer
- Trace, monitor and analyze MySQL query activity
- "Query sniffer" on the network
- Analysis across all servers
- Available now
MySQL load balancer
- Q1/Q2 2009
MySQL connection manager
- Connection concentrator ("multiplexer")
- Connection pooler
- Q1/Q2 2009
Carrier-grade edition compared to enterprise-edition
- Geographical replication
- LDAP interface