MySQL goes lean

sugarcrmdevelopers —  July 24, 2008 — Leave a comment

An extremely fast database is a key comonpent to a successful SugarCRM implementation.  MySQL lead architect Brian Aker has announced the Drizzle project which will redesign the MySQL core to be based on a modular architecture.  The upside of this redesign will be the ability to install a MySQL-based db without unneeded functionality that slows down the db engine.  Hence a smaller db engine designed for Web-based apps.

Some of the functionality that won’t be in the core engine are listed in the project FAQ.

No modes, views, triggers, prepared statements, stored procedures, query cache, data conversion inserts, ACL. Fewer data types.  Less engines, less code. Assume the primary engine is transactional.

It appears Drizzle is a separate project and product with many MySQL engineers working on it but not being directly run by Sun/MySQL.  It would be interesting to see how much of this work will factor back into the core MySQL distribution over time.  Either way, it seems there is certainly a market for lean and mean db’s targeted exclusively at Web-based apps.

No Comments

Be the first to start the conversation!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s