MySQL's latest update isn't the definiitive open-source database that will give commercial databases a run for their money, but experts say it's a good evolutionary step in that direction.
MySQL AB on Wednesday released into general availability a version of its open-source database with subqueries, faster and more secure client-server communication, tools that ease installation and configuration, and support for international character sets and geographic data.
MySQL Version 4.1, which can be downloaded now here,
isnt the truly competitive database that everybodys waiting for and that everybody thinks will give commercial databases a run for their money, according to Charlie Garry, an analyst at Meta Group, in Simsbury, Conn. That would be Version 5.0, which will feature stored procedures and triggers and which will take advantage of the 2.6 Linux kernel and its improved scalability and support for things that databases likeasynchronous I/O, for example.
But MySQL 4.1 is a good evolutionary step toward that truly competitive version, Garry said. Version 4.1 is easier to use, he said. "Theyre getting more SQL compliance. Theyre starting to catch up with other commercial databases."
In Version 4.1, subqueries and derived tables are geared to helping users search complex data sets easier and more efficiently. A faster and more flexible client/server protocol will support prepared statements, which should help to optimize query execution and improve warning information.
A new GUI installer and configuration wizards for Linux and Windows should enable developers to more easily set up and optimize MySQL databases. In addition, client/server communication is encrypted with OpenSSL in the new version.
An optimized server library with a smaller footprint promises to perform much faster when embedded into third-party applications.
At this point, MySQL
is the worlds most popular open-source database. In the spring, Forrester Research Inc. surveyed 140 large North American companies on their open-source plans
and found that MySQL was high on respondents project lists, with 52 percent of respondents reporting that they were using it or planned to use it.
Still, database giants such as Oracle Corp. sneer at the idea of MySQL competing. Open-source databases share of the RDBMS market is negligible, with the following fears comprising the list of what scares CIOs away from the technology, according to research done by Garry:
- Informal product support.
- Rate of feature change, with some CIOs concerned that changes happen too slowly and others concerned about exactly the opposite.
- Lack of a product road map.
- Functional gaps.
- Licensing caveats.
- Low ISV support.
Many of these fears are irrational when applied to MySQL, Garry said. For example, the company has a formal support program and a product road map, and has secured a strong relationship with at least one ISV: SAP AG.
But its still important for MySQL to build relationships with software companies, Garry said. "To prove to you, Mr. software vendor/application provider, that you could run your database on MySQL and significantly reduce total cost of ownership to your client basethats how you get over that objection," he said.