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
    MySQL 6.x
    • 6.1 :
      • Replication fail-over
      • Crash-safe slaves
      • Event checksums
    • 6.2 :
      • Multi-source replication
    • Extended support of foreign keys
    • GA Q4 2010
    MySQL 7 "Citadel"
    • Security groups / roles
    • Transparent data encryption
    • Data auditing (for compliance)
    • External authentication
    • Online "Alter Table"

    No comments:

    Post a Comment