MySQL Breaks Into the Data Center
Once dismissed as inadequate for high transaction volumes, the open-source database's improved performance and low cost are winning new converts -- and shaking up the status quo in the database world.
Computerworld - MySQL infuriated a janitor one night in the New York headquarters of The Associated Press. Because of a successful adoption of the open-source database, the IT staffers there figured they no longer needed their DB2 manuals. So they dumped them all in the trash.
"He looked at the manuals, and there were stacks of them, got angry, said he'd come back for them later and stormed out," recalls Michael Welles, a database consultant on the project. "All because of MySQL."
MySQL is also upsetting the entire database market. Charles Garry, an analyst at Meta Group Inc. in Stamford, Conn., hails it as "a disruptive technology" that's commoditizing databasesso much so, he says, that "the future of the database market will be the standardization on MySQL."
Strong words, but adherents of the open-source database are passionate supporters, and they number in the millions. These users are drawn to it because it offers high performance, ease of use and a feature set broad enough to handle most of their database development needs. And it's cheap.
Indeed, MySQL's low cost never fails to come up in conversation with users. Mark Cotner, manager of network application development at Cox Communications Inc. in Atlanta, points out that his MySQL-based application cost less than $90,000 from soup to nuts, including the Intel-based servers, programming time and the approximately $4,000 annual license and support payments to MySQL AB, the Uppsala, Sweden-based company that oversees the development and distribution of the open-source database. An Oracle database license for the project would have totaled $300,000 by itself, he says.
Cotner is far from the only person with a MySQL money-saving story. Another is Dwight Clark, an IT specialist and systems analyst for the Marshall Space Flight Center Procurement Office at NASA. He says the NASA Acquisition Internet Service (NAIS) migrated an Oracle database to MySQL because a price restructuring by Oracle Corp. meant the licensing costs alone for a simple upgrade would be "more than twice the NAIS annual budget."
Fast and Easy
But free source code and inexpensive licensing aren't the only reasons why users sing MySQL's praises. Performance also rises to the top of the list.
Cotner says that the 700GB data warehouse he built "is very, very fast." The application atop the database gathers monitoring information via Simple Network Management Protocol on Cox's 1.2 million cable modems in the field. With it, Cox is now able to supply critical service data to analysts and technical support staff.
"The most expensive part of running a cable company is managing the last mile," he says. "So if we can do that more intelligently, we can save the company money and improve customer satisfaction."
- 15 Non-Certified IT Skills Growing in Demand
- How 19 Tech Titans Target Healthcare
- Twitter Suffering From Growing Pains (and Facebook Comparisons)
- Agile Comes to Data Integration
- Slideshow: 7 security mistakes people make with their mobile device
- iOS vs. Android: Which is more secure?
- 11 sure signs you've been hacked
- The value of smarter oil and gas fields With global energy requirements continuing to rise, the exploration, development and production of new oil and gas resources are shifting to increasingly challenging...
- Smarter Environmental Analytics Solutions: Offshore Oil and Gas Installations Example This IBM Redbooks® Solution Guide describes a solution for implementing smarter environmental monitoring and analytics for oil and gas industries. The solution implements...
- Piecing Together the Business Intelligence Puzzle Business intelligence (BI) technology collects and analyzes company data, delivering relevant information to corporate decision-makers in an effort to produce favorable outcomes.
- Harness IT -- An Introduction to Business Intelligence Solutions Learn the key selection criteria required to provide your organization with the capability to address structured data, unstructured data and mobile demands so...
- Live Webcast Best Practices for the Hyperconverged Enterprise Network To the Age of Constant Connectivity and Information overload
- Live Webcast On-demand webinar: "Mobility Mayhem: Balancing BYOD with Enterprise Security" Check out this on-demand webinar to hear Sophos senior security expert John Shier deep dive into how BYOD impacts your enterprise security strategy...
- Live Webcast Endpoint Backup & Restore: Protect Everyone, Everywhere Arek Sokol from the bleeding-edge IT team at Genentech/Roche explains how he leverages cross-platform enterprise endpoint backup in the public cloud as part...
- The Software-Defined Data Center: Is your ADC ready? Data center transformation is accelerating beyond virtualization to next-generation cloud architectures and software-defined data centers, bringing new challenges for application performance, scalability and...
- Application Acceleration: Optimize the End-User Experience Watch this on-demand webcast and learn how you can optimize your web content, accelerate performance across any device and browser combination, and offload...