The Future of Mysql
In a recent article from zdnet:
"Oracle played a big card when it bought InnoDB, the most popular way to inject data into the open source mySQL database.
Monday mySQL responds by getting Solid™ Information Technology, a proprietary database vendor, to take its solidDB Storage Engine for MySQL open source, under the GPL, starting in June.
Solid has its base in telecommunications and transaction processing, which had been considered a completely different market from the small fry mySQL supplies. It has 3 million copies out at places like Alcatel, Cisco, EMC, HP, NEC, Nokia, and Nortel.
The addition of Solid technology to mySQL, the company said, puts mySQL into the enterprise league and makes it a direct threat to Oracle." (full article available here)
Where is mysql going from here? The purchase of the solidDB storage engine is a direct result of the Oracle buy out of the innoDB storage engine currently being used. Oracle attempted to buy out the mysql database back in February for an undisclosed amount, but were unsuccessful. They are now trying to rid themselves of their competiton by purchasing the developers and the technology behind it. It was only a matter of time before something like this was going to happen. As a company based on an open source product, its biggest asset is its developers. Large companies may not be able to take the company over, but they can purchase the developers behind its main technology. The Mysql corporation now has control over technology that sets them apart from their competition.
* ACID transactions.
* Automatic roll forward recovery after failure.
* Uses optimistic (or pessimistic) multiversion concurrency control.
* Database and log files are binary compatible among different platforms.
* Fully multi-threaded using kernel threads. It uses multiple CPUs/cores if they are available.
* Supports all MySQL SQL data types
* Supports full MySQL syntax
* Isolation levels supported: READ COMMITTED, REPEATABLE READ and SERIALIZABLE
* The MySQL-specific SHOW command can be used to retrieve information
about databases, database engines, tables, and indexes.
* Function names occupy a different name space than table or column names.
* No practical limit on number of tables or columns, or database size.
* The EXPLAIN command can be used to determine how the optimizer resolves
a query. (not yet supported in the prototype)
* Foreign keys and on-line backup will be supported in future product release. They are already supported by solidDB, but the interface between MySQL and solidDB is not yet available for these features.