DreamHost today announced support for MySQL 5.0. All new MySQL databases being created will be version 5, and they will soon offer the possibility to upgrade current databases from version 4 to version 5.
For the ones who haven’t followed MySQL progress the latest years, I will recap the development roadmap here.
- Query cashing (increased performance for many applications with repetitive queries)
- Full-text indexing (searching on packed indexes, bulk inserts and other new optimizations for faster query execution)
- Sub-queries and derived tables (search complex data sets with greater ease and efficiency)
- Full Unicode support
- ACID-compliant transaction support
- Stored Procedures (to embed business logic in the database and improve performance)
- Triggers (to enforce complex business rules at the database level)
- Cursors (to allow easier database development and reference of large datasets)
- Views (to ensure protection of sensitive information)
MySQL has over the last few years evolved from being a populaire hobby database to be a full enterprise level database. David Axmark, co-founder of MySQL, summarized this when he at the release of MySQL 5.0 said: “People have been criticising MySQL since we started [in 1995] for not having stored procedures, triggers and views”, and “We’re fixing 10 years of criticism in one release”.
More info in the DreamHost Community Wiki: