MySQL Fork "Drizzle" Shows Signs of Life
The new version of Drizzle includes a much better 'drizzledump' tool, which now has the ability to migrate databases from MySQL to Drizzle without any intermediate files. If it detects a MySQL server it automatically converts the data and structures into Drizzle formats. If it's connected to a Drizzle server it will simply perform a normal dump.
Drizzle 7 also introduces Sphinx-based documentation. In addition, Drizzle has a new feature that allows it to understand MySQL's network protocol. This should make it pretty simple to run MySQL applications with Drizzle after a few minor changes. These features will reach full stability sometime around February 2011.
Drizzle has been slow in its path to beta status, but it was actually ahead of Oracle's current version of MySQL in some ways because Drizzle started using InnoDB as the transactional storage engine before MySQL. Drizzle also supports a variety of scripting languages for stored procedures - much like PostgreSQL. Drizzle is distinguished by its focus on modularity for sections of its functionality.
Drizzle was conceived in order to produce an SQL database that was optimized for cloud and web applications. Developers scraped out all of the non essential code from MySQL and then re-factored the remaining code and migrated it to C++. While Drizzle was initially supported by Sun, most of its core developers are employed by Rackspace now.