Linux Containers Authors: Kareen Kircher, Elizabeth White, Pat Romanski, John Mertic, Liz McMillan

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
Ask someone to architect an Internet of Things (IoT) solution and you are guaranteed to see a reference to the cloud. This would lead you to believe that IoT requires the cloud to exist. However, there are many IoT use cases where the cloud is not feasible or desirable. In his session at @ThingsExpo, Dave McCarthy, Director of Products at Bsquare Corporation, will discuss the strategies that exist to extend intelligence directly to IoT devices and sensors, freeing them from the constraints of ...
What happens when the different parts of a vehicle become smarter than the vehicle itself? As we move toward the era of smart everything, hundreds of entities in a vehicle that communicate with each other, the vehicle and external systems create a need for identity orchestration so that all entities work as a conglomerate. Much like an orchestra without a conductor, without the ability to secure, control, and connect the link between a vehicle’s head unit, devices, and systems and to manage the ...
Intelligent machines are here. Robots, self-driving cars, drones, bots and many IoT devices are becoming smarter with Machine Learning. In her session at @ThingsExpo, Sudha Jamthe, CEO of IoTDisruptions.com, will discuss the next wave of business disruption at the junction of IoT and AI, impacting many industries and set to change our lives, work and world as we know it.
DevOps is being widely accepted (if not fully adopted) as essential in enterprise IT. But as Enterprise DevOps gains maturity, expands scope, and increases velocity, the need for data-driven decisions across teams becomes more acute. DevOps teams in any modern business must wrangle the ‘digital exhaust’ from the delivery toolchain, "pervasive" and "cognitive" computing, APIs and services, mobile devices and applications, the Internet of Things, and now even blockchain. In this power panel at @...
@ThingsExpo has been named the Top 5 Most Influential M2M Brand by Onalytica in the ‘Machine to Machine: Top 100 Influencers and Brands.' Onalytica analyzed the online debate on M2M by looking at over 85,000 tweets to provide the most influential individuals and brands that drive the discussion. According to Onalytica the "analysis showed a very engaged community with a lot of interactive tweets. The M2M discussion seems to be more fragmented and driven by some of the major brands present in the...
19th Cloud Expo, taking place November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA, will feature technical sessions from a rock star conference faculty and the leading industry players in the world. Cloud computing is now being embraced by a majority of enterprises of all sizes. Yesterday's debate about public vs. private has transformed into the reality of hybrid cloud: a recent survey shows that 74% of enterprises have a hybrid cloud strategy. Meanwhile, 94% of enterpri...
Amazon has gradually rolled out parts of its IoT offerings, but these are just the tip of the iceberg. In addition to optimizing their backend AWS offerings, Amazon is laying the ground work to be a major force in IoT - especially in the connected home and office. In his session at @ThingsExpo, Chris Kocher, founder and managing director of Grey Heron, explained how Amazon is extending its reach to become a major force in IoT by building on its dominant cloud IoT platform, its Dash Button strat...
SYS-CON Events announced today that Streamlyzer will exhibit at the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. Streamlyzer is a powerful analytics for video streaming service that enables video streaming providers to monitor and analyze QoE (Quality-of-Experience) from end-user devices in real time.
You have great SaaS business app ideas. You want to turn your idea quickly into a functional and engaging proof of concept. You need to be able to modify it to meet customers' needs, and you need to deliver a complete and secure SaaS application. How could you achieve all the above and yet avoid unforeseen IT requirements that add unnecessary cost and complexity? You also want your app to be responsive in any device at any time. In his session at 19th Cloud Expo, Mark Allen, General Manager of...
Cloud based infrastructure deployment is becoming more and more appealing to customers, from Fortune 500 companies to SMEs due to its pay-as-you-go model. Enterprise storage vendors are able to reach out to these customers by integrating in cloud based deployments; this needs adaptability and interoperability of the products confirming to cloud standards such as OpenStack, CloudStack, or Azure. As compared to off the shelf commodity storage, enterprise storages by its reliability, high-availabil...
The IoT industry is now at a crossroads, between the fast-paced innovation of technologies and the pending mass adoption by global enterprises. The complexity of combining rapidly evolving technologies and the need to establish practices for market acceleration pose a strong challenge to global enterprises as well as IoT vendors. In his session at @ThingsExpo, Clark Smith, senior product manager for Numerex, will discuss how Numerex, as an experienced, established IoT provider, has embraced a ...
The Internet of Things (IoT), in all its myriad manifestations, has great potential. Much of that potential comes from the evolving data management and analytic (DMA) technologies and processes that allow us to gain insight from all of the IoT data that can be generated and gathered. This potential may never be met as those data sets are tied to specific industry verticals and single markets, with no clear way to use IoT data and sensor analytics to fulfill the hype being given the IoT today.
Donna Yasay, President of HomeGrid Forum, today discussed with a panel of technology peers how certification programs are at the forefront of interoperability, and the answer for vendors looking to keep up with today's growing industry for smart home innovation. "To ensure multi-vendor interoperability, accredited industry certification programs should be used for every product to provide credibility and quality assurance for retail and carrier based customers looking to add ever increasing num...
In the next forty months – just over three years – businesses will undergo extraordinary changes. The exponential growth of digitization and machine learning will see a step function change in how businesses create value, satisfy customers, and outperform their competition. In the next forty months companies will take the actions that will see them get to the next level of the game called Capitalism. Or they won’t – game over. The winners of today and tomorrow think differently, follow different...
“Media Sponsor” of SYS-CON's 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. CloudBerry Backup is a leading cross-platform cloud backup and disaster recovery solution integrated with major public cloud services, such as Amazon Web Services, Microsoft Azure and Google Cloud Platform.
In his general session at 19th Cloud Expo, Manish Dixit, VP of Product and Engineering at Dice, will discuss how Dice leverages data insights and tools to help both tech professionals and recruiters better understand how skills relate to each other and which skills are in high demand using interactive visualizations and salary indicator tools to maximize earning potential. Manish Dixit is VP of Product and Engineering at Dice. As the leader of the Product, Engineering and Data Sciences team a...
The security needs of IoT environments require a strong, proven approach to maintain security, trust and privacy in their ecosystem. Assurance and protection of device identity, secure data encryption and authentication are the key security challenges organizations are trying to address when integrating IoT devices. This holds true for IoT applications in a wide range of industries, for example, healthcare, consumer devices, and manufacturing. In his session at @ThingsExpo, Lancen LaChance, vic...
What are the successful IoT innovations from emerging markets? What are the unique challenges and opportunities from these markets? How did the constraints in connectivity among others lead to groundbreaking insights? In her session at @ThingsExpo, Carmen Feliciano, a Principal at AMDG, will answer all these questions and share how you can apply IoT best practices and frameworks from the emerging markets to your own business.
Big Data has been changing the world. IoT fuels the further transformation recently. How are Big Data and IoT related? In his session at @BigDataExpo, Tony Shan, a renowned visionary and thought leader, will explore the interplay of Big Data and IoT. He will anatomize Big Data and IoT separately in terms of what, which, why, where, when, who, how and how much. He will then analyze the relationship between IoT and Big Data, specifically the drilldown of how the 4Vs of Big Data (Volume, Variety,...
SYS-CON Events announced today that SoftNet Solutions will exhibit at the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. SoftNet Solutions specializes in Enterprise Solutions for Hadoop and Big Data. It offers customers the most open, robust, and value-conscious portfolio of solutions, services, and tools for the shortest route to success with Big Data. The unique differentiator is the ability to architect and ...