MySQL Update Puts a Toe Into Big Vendors Database Turf

 
 
By Lisa Vaas  |  Posted 2004-10-27 Email Print this article Print
 
 
 
 
 
 
 

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 like—asynchronous 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 base—thats how you get over that objection," he said. Next page: Enterprise-class features.



 
 
 
 
Lisa Vaas is News Editor/Operations for eWEEK.com and also serves as editor of the Database topic center. Since 1995, she has also been a Webcast news show anchorperson and a reporter covering the IT industry. She has focused on customer relationship management technology, IT salaries and careers, effects of the H1-B visa on the technology workforce, wireless technology, security, and, most recently, databases and the technologies that touch upon them. Her articles have appeared in eWEEK's print edition, on eWEEK.com, and in the startup IT magazine PC Connection. Prior to becoming a journalist, Vaas experienced an array of eye-opening careers, including driving a cab in Boston, photographing cranky babies in shopping malls, selling cameras, typography and computer training. She stopped a hair short of finishing an M.A. in English at the University of Massachusetts in Boston. She earned a B.S. in Communications from Emerson College. She runs two open-mic reading series in Boston and currently keeps bees in her home in Mashpee, Mass.
 
 
 
 
 
 
 

Submit a Comment

Loading Comments...

 
Manage your Newsletters: Login   Register My Newsletters























 
 
 
 
 
 
 
 
 
 
 
Rocket Fuel