Users Delighted

By Lisa Vaas  |  Posted 2005-12-29 Print this article Print

Yaakov Menken, CEO of Capalon Internet Solutions, has been using MySQL since 2000, when he migrated from Microsoft Access. He told me his company had made the "grave error" of building a database on top of Access and having a situation where multiple people were trying to update the database, if not down to the second, at very close times, thereby resulting in data corruption.
Its not surprising, given that bad experience, that MySQLs master/slave database replication is his favorite feature. It gives users a live backup copy of any database, already having given him his database back up in a matter of minutes, as opposed to what would have been hours.
His company moved off of Windows not just because of the database, however, but because Linux and Apache were more stable than Windows and IIS (Internet Information Services) 4. "Certainly the fact that you could add the pieces together and move from [Windows] to … LAMP [Linux/Apache/MySQL/Perl, Python, PHP], and do so with no software costs, was a powerful motivation to go in that particular direction," he told me. Hes "delighted" with MySQL and has never seen any reason to go back, nor to ponder using a lite version of a proprietary database. Going over to Oracle, for example, would introduce an arduous learning curve. But he finds a side-by-side comparison of MySQL to the lite databases to be relevant because theyre both aimed for low-budget situations. "Theres a lot of small businesses for whom the full versions are not financially viable at this point," he told me. "Theyre going to go with an express version." Wilkes backed him up on this one, with cost again being a big part of the equation. "Why choose a light commercial database for a business? Cost is one, since companies that once had one database now have dozens," he said. Beyond that, Wilkes said, feature bloat is another good reason why a small business might want to go with a lite database. "…Modern Enterprise databases have become bloated with so many extended features that the simple task of storing data is almost an afterthought. If you compare the feature sets of a light vs. enterprise database, youll find things like internal security and encryption, back-end compression, OLAP workspaces, etc. I dont need those things. A lot of other companies dont either, or if they do, they dont need them for all their data. I think the question for everything but the largest monolithic deployments is, why not choose the standard edition and save a bundle?" So after listening to users, at least on the MySQL side, I can see why there might be some good reasons to compare MySQL with the light databases. Theyre closer in pricing and feature set. Plus, as Wilkes pointed out, the light databases arguably came into being in great part because the proprietary vendors had to respond to MySQL and the pressure its putting on the lower end of the market. So, funky premise or no, congratulations, MySQL—it was a nice recognition of how far youve come to get the editors choice. Are you plugging into the light database versions? Tell me why they appeal: Write to me at Lisa Vaas is Ziff Davis Internets news editor in charge of operations. She is also the editor of eWEEK.coms Database and Business Intelligence topic center. She has been with eWEEK and since 1995, most recently covering enterprise applications and database technology. Check out eWEEK.coms for the latest database news, reviews and analysis.

Lisa Vaas is News Editor/Operations for 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, 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