NEWSLETTERS
 

CIO.com updates, insights and advice on technology, management and your career.

 Advice and Opinion

 CIO Consumer IT

 CIO Leader

 CIO Enterprise

 CIO Insider

 

RSS Feeds »

 
 
LEADERSHIP
 

CIO Executive Programs

The Leader in Face-to-Face Education for Senior Executives

Offering regional and national programs, CIO (and CSO) events bring together some of the most respected names and thought leaders in information technology and security. Presented by CIOs and other senior level executives, these invitation-only programs offer timely topics and strong networking. Learn More »

 

CIO Executive Council

Public Teleconferences

Join CIO Executive Council members and participate in the following live teleconferences:

* Planning for Succession:
Models for IT Leadership Development, June 23
* Youth in IT: How CIOs Can Engage the Next Generation
June 10
* Change Leadership at General Growth Properties: A
Pathways Leadership Development Seminar, June 25

More / Register »

Learn more about the CIO Executive Council »



 
 
RESOURCE CENTER
 
 
 
SUBSCRIBE TO CIO
 

Are you involved in setting the direction for your company's IT budget or strategy?


Apply today for a FREE subscription to CIO Magazine!

Subscription Services »

Reprints »

 
 

Feature

 

Five Compelling Reasons to Use MySQL

Why should MySQL be at the top of your database list?
 

PAGE 3

It Is Well Supported
MySQL's dual-licensing scheme means that those who want extra hand-holding can get it directly from the creator of the database. MySQL AB provides support and maintenance services such as code updates and bug fixes as part of its roughly $3,000 annual subscription fee. For a separate fee, customers can get priority 24/7 support, access to an extensive online knowledge base and a dedicated technical account manager.

Users of the free version have plenty of support options too. At dev.mysql.com, a large, robust community of users and developers discuss all things MySQL. The site has blogs, tutorials, videos, webinars, white papers and discussion forums. Any question you have has probably already been answered somewhere by someone in the community—and if it hasn't, just ask or google. "The MySQL community is active, friendly and knowledgeable," Schroeder says.

It Is Flexible and Scalable
Because there are so many options for additional features like storage engines, you can pick the one that works best for your company, or try out more than one. MySQL starts small and grows with the company. "This makes it possible to adapt the system to the needs that you currently have," says Mats Kindahl, a senior developer for MySQL AB.

"MySQL is actually a family of databases, where you can choose and configure your back end to adapt to a large set of conditions," says Patrick Sinz, owner and president of open-source consultancy Ethiqa, "so you can start small and grow later in size and/or performance."

You can configure MySQL to run tiny embedded applications using a footprint no larger than one megabyte, or scale it up to handle many terabytes of data. One way MySQL achieves this scalability is through a popular feature called stored procedures, mini, precompiled routines that reside outside of the application. These procedures are stored and run on the database server to reduce the processing footprint on the client and make the most of processing power, since the database server is usually faster. Stored procedures aren't unique to MySQL, but the recent addition of this feature set makes the database that much more attractive.

It Has Native Support for Cutting-Edge Technologies
MySQL comes prepared to support all the most popular Web 2.0-ish languages, such as Ruby, Ajax and, of course, PHP. Tim O'Reilly has said, "Every Web 2.0 company is ultimately a database company." Since MySQL is already the database that runs some of the best-known Web 2.0 sites (including Craigslist, Digg, Wikipedia and Google), maybe O'Reilly should have said that every Web 2.0 company is ultimately a MySQL database company.

Now that you've read the reasons to choose MySQL, be sure to read the alternate view: Eight Sound Reasons Not to Use MySQL.

Tina Gasperson is a freelance IT journalist who specializes in open source for the enterprise. Visit her blog at www.gasperson.com.

Other stories by Tina Gasperson

© 2008 CXO Media Inc.
 
 
 
 
 
 
Loading...
 
 
ABCs
 

How To Do Nearly Anything

Just the basics, please. Sometimes we all need a refresher or we need to make sure our team and our colleagues are all on the same page.

Over 25 tutorials on everything from business intelligence to virtualization.

 
 
FEATURED SPONSORS
 
 
 
SPONSORED LINKS
 

IDC VP Carl Olofson Reviews Technology Advances and How to Handle Reporting and Querying

Oracle Database 11g: Advances in Compression, Real Application Testing and Data Guard

InfoWorld Test Center on Oracle Active Data Guard

How Office 2007 Exposed Bill Gates

Citrix XenServer FREE trial

TDWI Research report clears confusion about automating data governance

Tuning ERP and the Supply Chain for Profitable Growth

Evolve your data center on proven technology. The Brocade DCX.

Taking Control of Software Licensing

Simple, Economical Server Virtualization for Any Size Company

Learn about B2B integration for Companies of All Sizes

Integration as a Service Webcast: Are you connected?

WAN Optimization for mobile users is critical to your business success.

Case Study: 24 Hour Fitness turned to SEPATON

White Paper: HP Application Modernization Services

Establishing a Strategy for Global Distributed Development

This white paper highlights best-of-breed solutions being built on the Microsoft platform

A Must Read on Data Protection Strategies!

Read the FREE Forrester study "Optimizing Users and Applications in a Mobile World"

Fujitsu Case Study - Thomson Learning

State of the Portal Market 2007: Portals and the Power of Participation

Write an RFP for Master Data Management: 10 Common Mistakes to Avoid

Building Compliance and Security into an Application Delivery Framework

Keys to a smooth and successful Office 2007 rollout, before, during and after!

Consider the ROI of Unified Communications for your contact center

InfoWorld Test Center on Oracle Real Application Testing

Oracle Real Application Testing with Oracle Database 11g

Increase conversions on your site with the help of EV SSL.

Performance Brief: Mobile Application Acceleration

Nothing Short of Revolutionary: Four Steps toward More Effective Enterprise Finance

White Paper: Unlocking the Potential of B2B

Shift your ERP investments into high gear and join the leaders!

Mitigating Risk with Security Assessments

White Paper: IDC Analysts Discuss Open Text

Case Study: Customer Integration Wins at Invitrogen

Internet's Largest Book Retailer Scores Big with B2B Customers

Riverbed RiOS 4.0: Raising the Bar in Wide Area Data Services

Business Value of Performance IDC Whitepaper

BPM At The Crossroads Webcast" Tackling the "Hard Issues" to Drive Success

Top 10 Questions to Ask when Choosing a Secure File Transfer Solution

An Executive Guide to Understanding Hosted and Managed Messaging

BEA & Forrester Webcast: "The Enterprise 2.0 Workplace." Register Now!

LIVE Webcast - The Mainframe is Dead...Long Live the Mainframe?

White Paper: Learn how wide-area data services accelerate information across wide-area networks

Learn about the Power of Pen Computing

Webcast: Optimizing Wide-Area Data Services

Putting Windows Server and Citrix to Work in the Enterprise

Getting Off on the Right Foot: Avoiding Common Master Data Management False Starts

The Case and Criteria for Combining Application Acceleration and Security

Webcast: Learn how organizations are overcoming productivity declines