Welcome!

Linux Containers Authors: Robert Reeves, Dana Gardner, John Esposito, Pat Romanski, Elizabeth White

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
So, you bought into the current machine learning craze and went on to collect millions/billions of records from this promising new data source. Now, what do you do with them? Too often, the abundance of data quickly turns into an abundance of problems. How do you extract that "magic essence" from your data without falling into the common pitfalls? In her session at @ThingsExpo, Natalia Ponomareva, Software Engineer at Google, will provide tips on how to be successful in large scale machine lear...
SYS-CON Events announced today that Peak 10, Inc., a national IT infrastructure and cloud services provider, will exhibit at SYS-CON's 18th International Cloud Expo®, which will take place on June 7-9, 2016, at the Javits Center in New York City, NY. Peak 10 provides reliable, tailored data center and network services, cloud and managed services. Its solutions are designed to scale and adapt to customers’ changing business needs, enabling them to lower costs, improve performance and focus inter...
In his session at @ThingsExpo, Chris Klein, CEO and Co-founder of Rachio, will discuss next generation communities that are using IoT to create more sustainable, intelligent communities. One example is Sterling Ranch, a 10,000 home development that – with the help of Siemens – will integrate IoT technology into the community to provide residents with energy and water savings as well as intelligent security. Everything from stop lights to sprinkler systems to building infrastructures will run ef...
SYS-CON Events announced today that DatacenterDynamics has been named “Media Sponsor” of SYS-CON's 18th International Cloud Expo, which will take place on June 7–9, 2016, at the Javits Center in New York City, NY. DatacenterDynamics is a brand of DCD Group, a global B2B media and publishing company that develops products to help senior professionals in the world's most ICT dependent organizations make risk-based infrastructure and capacity decisions.
You think you know what’s in your data. But do you? Most organizations are now aware of the business intelligence represented by their data. Data science stands to take this to a level you never thought of – literally. The techniques of data science, when used with the capabilities of Big Data technologies, can make connections you had not yet imagined, helping you discover new insights and ask new questions of your data. In his session at @ThingsExpo, Sarbjit Sarkaria, data science team lead ...
The IoT has the potential to create a renaissance of manufacturing in the US and elsewhere. In his session at 18th Cloud Expo, Florent Solt, CTO and chief architect of Netvibes, will discuss how the expected exponential increase in the amount of data that will be processed, transported, stored, and accessed means there will be a huge demand for smart technologies to deliver it. Florent Solt is the CTO and chief architect of Netvibes. Prior to joining Netvibes in 2007, he co-founded Rift Technol...
Join IBM June 8 at 18th Cloud Expo at the Javits Center in New York City, NY, and learn how to innovate like a startup and scale for the enterprise. You need to deliver quality applications faster and cheaper, attract and retain customers with an engaging experience across devices, and seamlessly integrate your enterprise systems. And you can't take 12 months to do it.
Machine Learning helps make complex systems more efficient. By applying advanced Machine Learning techniques such as Cognitive Fingerprinting, wind project operators can utilize these tools to learn from collected data, detect regular patterns, and optimize their own operations. In his session at 18th Cloud Expo, Stuart Gillen, Director of Business Development at SparkCognition, will discuss how research has demonstrated the value of Machine Learning in delivering next generation analytics to im...
This is not a small hotel event. It is also not a big vendor party where politicians and entertainers are more important than real content. This is Cloud Expo, the world's longest-running conference and exhibition focused on Cloud Computing and all that it entails. If you want serious presentations and valuable insight about Cloud Computing for three straight days, then register now for Cloud Expo.
IoT device adoption is growing at staggering rates, and with it comes opportunity for developers to meet consumer demand for an ever more connected world. Wireless communication is the key part of the encompassing components of any IoT device. Wireless connectivity enhances the device utility at the expense of ease of use and deployment challenges. Since connectivity is fundamental for IoT device development, engineers must understand how to overcome the hurdles inherent in incorporating multipl...
The IETF draft standard for M2M certificates is a security solution specifically designed for the demanding needs of IoT/M2M applications. In his session at @ThingsExpo, Brian Romansky, VP of Strategic Technology at TrustPoint Innovation, will explain how M2M certificates can efficiently enable confidentiality, integrity, and authenticity on highly constrained devices.
The paradigm has shifted. A Gartner survey shows that 43% of organizations are using or plan to implement the Internet of Things in 2016. However, not just a handful of companies are still using the old-style ad-hoc trial-and-error ways, unaware of the critical barriers, paint points, traps, and hidden roadblocks. How can you become a winner? In his session at @ThingsExpo, Tony Shan will present a methodical approach to guide the holistic adoption and enablement of IoT implementations. This ov...
We’ve worked with dozens of early adopters across numerous industries and will debunk common misperceptions, which starts with understanding that many of the connected products we’ll use over the next 5 years are already products, they’re just not yet connected. With an IoT product, time-in-market provides much more essential feedback than ever before. Innovation comes from what you do with the data that the connected product provides in order to enhance the customer experience and optimize busi...
Artificial Intelligence has the potential to massively disrupt IoT. In his session at 18th Cloud Expo, AJ Abdallat, CEO of Beyond AI, will discuss what the five main drivers are in Artificial Intelligence that could shape the future of the Internet of Things. AJ Abdallat is CEO of Beyond AI. He has over 20 years of management experience in the fields of artificial intelligence, sensors, instruments, devices and software for telecommunications, life sciences, environmental monitoring, process...
SYS-CON Events announced today that Ericsson has been named “Gold Sponsor” of SYS-CON's @ThingsExpo, which will take place on June 7-9, 2016, at the Javits Center in New York, New York. Ericsson is a world leader in the rapidly changing environment of communications technology – providing equipment, software and services to enable transformation through mobility. Some 40 percent of global mobile traffic runs through networks we have supplied. More than 1 billion subscribers around the world re...
SYS-CON Events announced today that Stratoscale, the software company developing the next generation data center operating system, will exhibit at SYS-CON's 18th International Cloud Expo®, which will take place on June 7-9, 2016, at the Javits Center in New York City, NY. Stratoscale is revolutionizing the data center with a zero-to-cloud-in-minutes solution. With Stratoscale’s hardware-agnostic, Software Defined Data Center (SDDC) solution to store everything, run anything and scale everywhere...
Angular 2 is a complete re-write of the popular framework AngularJS. Programming in Angular 2 is greatly simplified – now it's a component-based well-performing framework. This immersive one-day workshop at 18th Cloud Expo, led by Yakov Fain, a Java Champion and a co-founder of the IT consultancy Farata Systems and the product company SuranceBay, will provide you with everything you wanted to know about Angular 2.
SYS-CON Events announced today that Men & Mice, the leading global provider of DNS, DHCP and IP address management overlay solutions, will exhibit at SYS-CON's 18th International Cloud Expo®, which will take place on June 7-9, 2016, at the Javits Center in New York City, NY. The Men & Mice Suite overlay solution is already known for its powerful application in heterogeneous operating environments, enabling enterprises to scale without fuss. Building on a solid range of diverse platform support,...
You deployed your app with the Bluemix PaaS and it's gaining some serious traction, so it's time to make some tweaks. Did you design your application in a way that it can scale in the cloud? Were you even thinking about the cloud when you built the app? If not, chances are your app is going to break. Check out this webcast to learn various techniques for designing applications that will scale successfully in Bluemix, for the confidence you need to take your apps to the next level and beyond.
Manufacturers are embracing the Industrial Internet the same way consumers are leveraging Fitbits – to improve overall health and wellness. Both can provide consistent measurement, visibility, and suggest performance improvements customized to help reach goals. Fitbit users can view real-time data and make adjustments to increase their activity. In his session at @ThingsExpo, Mark Bernardo Professional Services Leader, Americas, at GE Digital, will discuss how leveraging the Industrial Interne...