Linux Containers Authors: Pat Romanski, Liz McMillan, Elizabeth White, Roger Strukhoff, Yeshim Deniz

Related Topics: Linux Containers

Linux Containers: Article

MySQL for AP Hosted News

Bottom line: it just works

The Associated Press (AP), the world's oldest and largest news agency, offers a service that allows news providers to integrate AP online content directly into their Web sites. The service, AP Hosted News, is used by approximately 600 affiliate newspapers and broadcasters. The service handles between 150,000 and 500,000 pages of content per affiliate per day, supporting 11,000 concurrent users. MySQL, a free open source database, has been the backbone of AP Hosted News since 2002.

From Informix to MySQL

AP originally used Informix for the online news service, but the development team started looking for a new database vendor when the project was going through a redesign. They downloaded MySQL to use as a proof-of-concept model to demonstrate what they needed, but assumed that the production system would use a commercial database from a large vendor.

After getting quotes from several commercial databases such as Oracle and IBM's DB2, they realized that their exact mix of requirements were going to be very expensive. AP needed 24/7 support, speed, and reliability, but not the mix of other features the large vendors include.

According to Terry Ewing, senior systems manager, "Oracle tries to be everything to everyone, so when you buy the product, you buy all the extras that someone else needed. The licensing and support model is so complicated that we would have spent too much to get the solution we needed. DB2 would also have been hundreds of thousands of dollars." They eventually realized that MySQL would be sufficient for the job, as long as they could get quality commercial support.

MySQL had the speed and efficiency AP needed, and the product was free. High-quality support was available from MySQL, Inc., a company that provides expert support for the database.

"MySQL just happened to fit what we needed: speed and efficiency. It's because other companies had the same problems, and the product evolved to match what companies like us need most. We just don't need everything Oracle has to offer, so we don't need to pay for it."
- Terry Ewing, senior systems manager, AP

According to Ewing, ease of deployment and license flexibility were important. They are able to quickly add databases according to changes in news requirements. When the Iraq war was imminent, for example, the team added a casualty database without having to worry about license compliance or renegotiating a contract.

Nine Times the Performance, but Only Twice the Cost

Ewing wanted to be sure about the benefit of using Linux on Intel hardware, so he checked Standard Performance Evaluation Corporation (SPEC, www.specbench.org) for a comparison against replacing their Sun hardware running Solaris. He was surprised by the findings. The cost of their older Sun hardware, originally $11,000, came out to $.60 per million operations per second. The Sun hardware they considered replacing it with, now $23,000, came out to $.83 per million operations per second. The price had actually increased for the same performance. Linux on Intel hardware with a 4-processor CPU, priced at $24,600, came out to $.23 per million operations per second. Once they knew how much power they could expect from the hardware, they added in the costs of the software.

Once the software and support costs were added in, Ewing calculated the performance of Linux at nine times better than Solaris on Sun hardware, at just twice the cost.

Support Is Better on MySQL

Maintaining the highest service level was a crucial requirement for the AP project, so it was important to work with a commercial support company. MySQL, Inc., was the obvious choice. According to Ewing, AP has received better support from MySQL, Inc., than he ever did with Informix. He believes there are a couple of reasons for this. "First, AP was using a particular application server that Informix was no longer totally committed to supporting. Since they weren't fully behind it anymore, we paid for 24/7 support, but didn't get the responsive help anymore. Second, Informix and the other major database vendors receive their money in a lump sum, and support contracts are just gravy. That gives them less incentive to work hard supporting customers. But since MySQL Inc.'s whole business is services and support, they have a big incentive to work hard for the customer."

Advice for Developers of Database Applications

Ewing's advice to technical managers deploying database applications is to maintain a distance between you and your chosen database vendor, which he calls "unbundling." Write applications so that you are able to switch databaselater if you find a business reason to do so. Be mindful of standards, and stay away from proprietary features. "We could always move to a commercial database later, since we built the application with unbundling in mind."

It Just Works

Even though the development team originally expected to use a commercial database, an open source solution won out in the end. "The decision to use MySQL was easy because the system runs on its own," says Ewing. "The key benefits of using the MySQL database are its performance, its stability, and its low total cost of ownership. Bottom line: it just works."

More Stories By Maria Winslow

Maria Winslow is the author of The Practical Manager's Guide to Open Source, available at http://www.lulu.com/practicalGuide and can be contacted at [email protected]

Comments (0)

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.

@ThingsExpo Stories
DXWorldEXPO LLC announced today that ICOHOLDER named "Media Sponsor" of Miami Blockchain Event by FinTechEXPO. ICOHOLDER give you detailed information and help the community to invest in the trusty projects. Miami Blockchain Event by FinTechEXPO has opened its Call for Papers. The two-day event will present 20 top Blockchain experts. All speaking inquiries which covers the following information can be submitted by email to [email protected] Miami Blockchain Event by FinTechEXPO also offers s...
Predicting the future has never been more challenging - not because of the lack of data but because of the flood of ungoverned and risk laden information. Microsoft states that 2.5 exabytes of data are created every day. Expectations and reliance on data are being pushed to the limits, as demands around hybrid options continue to grow.
Poor data quality and analytics drive down business value. In fact, Gartner estimated that the average financial impact of poor data quality on organizations is $9.7 million per year. But bad data is much more than a cost center. By eroding trust in information, analytics and the business decisions based on these, it is a serious impediment to digital transformation.
The IoT Will Grow: In what might be the most obvious prediction of the decade, the IoT will continue to expand next year, with more and more devices coming online every single day. What isn’t so obvious about this prediction: where that growth will occur. The retail, healthcare, and industrial/supply chain industries will likely see the greatest growth. Forrester Research has predicted the IoT will become “the backbone” of customer value as it continues to grow. It is no surprise that retail is ...
Digital Transformation: Preparing Cloud & IoT Security for the Age of Artificial Intelligence. As automation and artificial intelligence (AI) power solution development and delivery, many businesses need to build backend cloud capabilities. Well-poised organizations, marketing smart devices with AI and BlockChain capabilities prepare to refine compliance and regulatory capabilities in 2018. Volumes of health, financial, technical and privacy data, along with tightening compliance requirements by...
Business professionals no longer wonder if they'll migrate to the cloud; it's now a matter of when. The cloud environment has proved to be a major force in transitioning to an agile business model that enables quick decisions and fast implementation that solidify customer relationships. And when the cloud is combined with the power of cognitive computing, it drives innovation and transformation that achieves astounding competitive advantage.
DevOpsSummit New York 2018, colocated with CloudEXPO | DXWorldEXPO New York 2018 will be held November 11-13, 2018, in New York City. Digital Transformation (DX) is a major focus with the introduction of DXWorldEXPO within the program. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of bus...
Dion Hinchcliffe is an internationally recognized digital expert, bestselling book author, frequent keynote speaker, analyst, futurist, and transformation expert based in Washington, DC. He is currently Chief Strategy Officer at the industry-leading digital strategy and online community solutions firm, 7Summits.
DXWordEXPO New York 2018, colocated with CloudEXPO New York 2018 will be held November 11-13, 2018, in New York City and will bring together Cloud Computing, FinTech and Blockchain, Digital Transformation, Big Data, Internet of Things, DevOps, AI, Machine Learning and WebRTC to one location.
Widespread fragmentation is stalling the growth of the IIoT and making it difficult for partners to work together. The number of software platforms, apps, hardware and connectivity standards is creating paralysis among businesses that are afraid of being locked into a solution. EdgeX Foundry is unifying the community around a common IoT edge framework and an ecosystem of interoperable components.
Cloud-enabled transformation has evolved from cost saving measure to business innovation strategy -- one that combines the cloud with cognitive capabilities to drive market disruption. Learn how you can achieve the insight and agility you need to gain a competitive advantage. Industry-acclaimed CTO and cloud expert, Shankar Kalyana presents. Only the most exceptional IBMers are appointed with the rare distinction of IBM Fellow, the highest technical honor in the company. Shankar has also receive...
Enterprises have taken advantage of IoT to achieve important revenue and cost advantages. What is less apparent is how incumbent enterprises operating at scale have, following success with IoT, built analytic, operations management and software development capabilities - ranging from autonomous vehicles to manageable robotics installations. They have embraced these capabilities as if they were Silicon Valley startups.
The standardization of container runtimes and images has sparked the creation of an almost overwhelming number of new open source projects that build on and otherwise work with these specifications. Of course, there's Kubernetes, which orchestrates and manages collections of containers. It was one of the first and best-known examples of projects that make containers truly useful for production use. However, more recently, the container ecosystem has truly exploded. A service mesh like Istio addr...
As IoT continues to increase momentum, so does the associated risk. Secure Device Lifecycle Management (DLM) is ranked as one of the most important technology areas of IoT. Driving this trend is the realization that secure support for IoT devices provides companies the ability to deliver high-quality, reliable, secure offerings faster, create new revenue streams, and reduce support costs, all while building a competitive advantage in their markets. In this session, we will use customer use cases...
Cloud Expo | DXWorld Expo have announced the conference tracks for Cloud Expo 2018. Cloud Expo will be held June 5-7, 2018, at the Javits Center in New York City, and November 6-8, 2018, at the Santa Clara Convention Center, Santa Clara, CA. Digital Transformation (DX) is a major focus with the introduction of DX Expo within the program. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive ov...
DXWorldEXPO | CloudEXPO are the world's most influential, independent events where Cloud Computing was coined and where technology buyers and vendors meet to experience and discuss the big picture of Digital Transformation and all of the strategies, tactics, and tools they need to realize their goals. Sponsors of DXWorldEXPO | CloudEXPO benefit from unmatched branding, profile building and lead generation opportunities.
Digital Transformation and Disruption, Amazon Style - What You Can Learn. Chris Kocher is a co-founder of Grey Heron, a management and strategic marketing consulting firm. He has 25+ years in both strategic and hands-on operating experience helping executives and investors build revenues and shareholder value. He has consulted with over 130 companies on innovating with new business models, product strategies and monetization. Chris has held management positions at HP and Symantec in addition to ...
With 10 simultaneous tracks, keynotes, general sessions and targeted breakout classes, @CloudEXPO and DXWorldEXPO are two of the most important technology events of the year. Since its launch over eight years ago, @CloudEXPO and DXWorldEXPO have presented a rock star faculty as well as showcased hundreds of sponsors and exhibitors! In this blog post, we provide 7 tips on how, as part of our world-class faculty, you can deliver one of the most popular sessions at our events. But before reading...
The best way to leverage your Cloud Expo presence as a sponsor and exhibitor is to plan your news announcements around our events. The press covering Cloud Expo and @ThingsExpo will have access to these releases and will amplify your news announcements. More than two dozen Cloud companies either set deals at our shows or have announced their mergers and acquisitions at Cloud Expo. Product announcements during our show provide your company with the most reach through our targeted audiences.
Andrew Keys is Co-Founder of ConsenSys Enterprise. He comes to ConsenSys Enterprise with capital markets, technology and entrepreneurial experience. Previously, he worked for UBS investment bank in equities analysis. Later, he was responsible for the creation and distribution of life settlement products to hedge funds and investment banks. After, he co-founded a revenue cycle management company where he learned about Bitcoin and eventually Ethereal. Andrew's role at ConsenSys Enterprise is a mul...