Welcome!

Linux Containers Authors: Martin Etmajer, Anders Wallgren, Elizabeth White, Pat Romanski, Flint Brenton

Related Topics: Linux Containers

Linux Containers: Article

NASA Department Saves Nearly $180,000 with MySQL

Speed and reliability are key

The NAIS (NASA Acquisition Internet Service) organization provides procurement Web applications for the entire agency through a suite of 14 applications. Tools relating to efficient procurement, such as posting solicitations and looking up past performance data for contracts, are provided via the online service. John Sudderth, a senior computer scientist with Computer Sciences Corporation, has been working with NASA on the project for several years and was instrumental in bringing a practical open source solution to the agency.

Dropping Oracle Saved Nearly $180,000

In 2000, the organization was faced with a dilemma. The procurement Web applications were running on Oracle and Solaris. A change in the enterprise-wide agreement NASA had with Oracle meant that individual departments would now be required to purchase each license used. The development team evaluated the requirements and according to Sudderth, "an Oracle license was going to be around $180,000 for what we needed. It was going to eat up a good chunk of the entire budget for the project."

After analyzing the numbers, Sudderth determined that Oracle was prohibitively expensive. They then turned to evaluating the two most popular open source databases, PostgreSQL and MySQL. The team searched the Web for basic descriptions, and compared the feature set of each with their project requirements. They decided on MySQL because it had just the feature set they needed. The database was free, and they purchased support from MySQL AB. The end result was a savings of nearly $180,000.

Performance: An Added Benefit

Speed and reliability were the most important features needed for the NAIS project. Sudderth was not concerned about missing advanced features. "One of the things we like about MySQLis the flexibility to get just what you need. The new 4.0 version has advanced features like row-level locking and naturally they come at a cost - performance. But they're offered as different table types, so if you need the features, you can use them and take the performance hit. If you don't need them, you don't have to use them and you retain the speed advantage. With Oracle, you get everything, whether you need it or not. You can't 'turn off' features like you can with MySQL."

Reliability has also been better with MySQL. "The way that MySQL stores files tends to make it less prone to crashes and makes it easier to recover. Crashes were more severe with Oracle."

Sudderth's team did their own benchmark tests of Oracle versus MySQL, both on the exact same Sun hardware running Solaris. They found that MySQL was 28% faster for their application suite.

Better Support

Many technical managers assume that commercial vendors will provide superior support, but Sudderth was never satisfied with the support they were getting from Oracle. When they chose MySQL, they purchased support from MySQL AB. "It's definitely not the same experience as Oracle. I wasn't even allowed to talk directly with Oracle support, but had to go through the DBA with questions. Much of the time we knew as much as they did about the product. The MySQL support has been totally different, and very satisfying."

When a problem did arise, Sudderth was able to talk with a core developer and get it fixed quickly. "A patch was available in about a week. That never would have happened with Oracle, in my experience."

Perl Kept the Application Neutral

The applications are written in Perl, an open source language. "We are so comfortable with Perl that it would be hard to switch languages. Everything just works. There are lots of solutions out there pre-written. When we needed graphics, we found a free module and plugged it in. It amazed me how easy it was to move our Perl applications. Literally one line out of about 15,000 was changed to get our applications running on MySQL."

According to Sudderth, language portability is key. "If the language is portable, it's a tremendous asset. I can't run old Visual Basic code on anything. Something breaks with each upgrade and it infuriates me. You've heard about DLL hell - I've spent a lot of time there. I like the fact that Perl works every day when I come to work. It sounds so simple, but it's a big deal."

Stick with Standards for Future Flexibility

Sudderth offers a word of caution, "This is something that I try to be aware of - stick with ANSI SQL. Don't use pro-prietary features. The fact that MySQL is ODBC compliant is a huge benefit. You can connect from Excel, or any- thing, really. Using open standards allows us to consistently provide services to other departments without problems.

"I'm a big believer in choice. Open source is a tremendous benefit for all of us. Operating systems all do basically the same things now, so there is no need to be locked into a single vendor anymore."

SIDEBAR

Open Source Software Used

In benchmark tests of Oracle versus MySQL, the NAIS department of NASA found that MySQL was 28% faster for their application suite on the exact same Sun hardware running Solaris.

Open source products used:

  • Red Hat Linux
  • MySQL database
  • Perl scripting language

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 (1) View Comments

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.


Most Recent Comments
Atul Gupta 10/27/04 09:47:13 AM EDT

MySQL is definitely the best database solution for OLTP(Online transaction processing) applications where the singleton transactions fetch the data _or_ do most of the IUD(Insert/Update/Delete) operations.
But, Oracle database server is still better for OLAP(Analytical processing) and data warehousing/mining applications. In the next few years, oracle will be phased out for transactional applications because of the obvious overheads, license cost, maintenance and upgrades.

@ThingsExpo Stories
SYS-CON Events announced today that Avere Systems, a leading provider of enterprise storage for the hybrid cloud, 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. Avere delivers a more modern architectural approach to storage that doesn’t require the overprovisioning of storage capacity to achieve performance, overspending on expensive storage media for inactive data or the overbuilding of data centers ...
SYS-CON Events announced today that Commvault, a global leader in enterprise data protection and information management, has been named “Bronze 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, and the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. Commvault is a leading provider of data protection and information management...
SYS-CON Events announced today that VAI, a leading ERP software 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. VAI (Vormittag Associates, Inc.) is a leading independent mid-market ERP software developer renowned for its flexible solutions and ability to automate critical business functions for the distribution, manufacturing, specialty retail and service sectors. An IBM Premier Business Part...
With an estimated 50 billion devices connected to the Internet by 2020, several industries will begin to expand their capabilities for retaining end point data at the edge to better utilize the range of data types and sheer volume of M2M data generated by the Internet of Things. In his session at @ThingsExpo, Don DeLoach, CEO and President of Infobright, will discuss the infrastructures businesses will need to implement to handle this explosion of data by providing specific use cases for filte...
Cognitive Computing is becoming the foundation for a new generation of solutions that have the potential to transform business. Unlike traditional approaches to building solutions, a cognitive computing approach allows the data to help determine the way applications are designed. This contrasts with conventional software development that begins with defining logic based on the current way a business operates. In her session at 18th Cloud Expo, Judith S. Hurwitz, President and CEO of Hurwitz & ...
Fortunately, meaningful and tangible business cases for IoT are plentiful in a broad array of industries and vertical markets. These range from simple warranty cost reduction for capital intensive assets, to minimizing downtime for vital business tools, to creating feedback loops improving product design, to improving and enhancing enterprise customer experiences. All of these business cases, which will be briefly explored in this session, hinge on cost effectively extracting relevant data from ...
SYS-CON Events announced today that Pythian, a global IT services company specializing in helping companies adopt disruptive technologies to optimize revenue-generating systems, has been named “Bronze Sponsor” of SYS-CON's 18th Cloud Expo, which will take place on June 7-9, 2015 at the Javits Center in New York, New York. Founded in 1997, Pythian is a global IT services company that helps companies compete by adopting disruptive technologies such as cloud, Big Data, advanced analytics, and DevO...
Companies can harness IoT and predictive analytics to sustain business continuity; predict and manage site performance during emergencies; minimize expensive reactive maintenance; and forecast equipment and maintenance budgets and expenditures. Providing cost-effective, uninterrupted service is challenging, particularly for organizations with geographically dispersed operations.
As enterprises work to take advantage of Big Data technologies, they frequently become distracted by product-level decisions. In most new Big Data builds this approach is completely counter-productive: it presupposes tools that may not be a fit for development teams, forces IT to take on the burden of evaluating and maintaining unfamiliar technology, and represents a major up-front expense. In his session at @BigDataExpo at @ThingsExpo, Andrew Warfield, CTO and Co-Founder of Coho Data, will dis...
With the Apple Watch making its way onto wrists all over the world, it’s only a matter of time before it becomes a staple in the workplace. In fact, Forrester reported that 68 percent of technology and business decision-makers characterize wearables as a top priority for 2015. Recognizing their business value early on, FinancialForce.com was the first to bring ERP to wearables, helping streamline communication across front and back office functions. In his session at @ThingsExpo, Kevin Roberts...
SYS-CON Events announced today that iDevices®, the preeminent brand in the connected home industry, 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. iDevices, the preeminent brand in the connected home industry, has a growing line of HomeKit-enabled products available at the largest retailers worldwide. Through the “Designed with iDevices” co-development program and its custom-built IoT Cloud Infrastruc...
Eighty percent of a data scientist’s time is spent gathering and cleaning up data, and 80% of all data is unstructured and almost never analyzed. Cognitive computing, in combination with Big Data, is changing the equation by creating data reservoirs and using natural language processing to enable analysis of unstructured data sources. This is impacting every aspect of the analytics profession from how data is mined (and by whom) to how it is delivered. This is not some futuristic vision: it's ha...
Silver Spring Networks, Inc. (NYSE: SSNI) extended its Internet of Things technology platform with performance enhancements to Gen5 – its fifth generation critical infrastructure networking platform. Already delivering nearly 23 million devices on five continents as one of the leading networking providers in the market, Silver Spring announced it is doubling the maximum speed of its Gen5 network to up to 2.4 Mbps, increasing computational performance by 10x, supporting simultaneous mesh communic...
The cloud promises new levels of agility and cost-savings for Big Data, data warehousing and analytics. But it’s challenging to understand all the options – from IaaS and PaaS to newer services like HaaS (Hadoop as a Service) and BDaaS (Big Data as a Service). In her session at @BigDataExpo at @ThingsExpo, Hannah Smalltree, a director at Cazena, will provide an educational overview of emerging “as-a-service” options for Big Data in the cloud. This is critical background for IT and data profes...
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,...
SYS-CON Events announced today that Alert Logic, Inc., the leading provider of Security-as-a-Service solutions for the cloud, 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. Alert Logic, Inc., provides Security-as-a-Service for on-premises, cloud, and hybrid infrastructures, delivering deep security insight and continuous protection for customers at a lower cost than traditional security solutions. Ful...
SYS-CON Events announced today that Interoute, owner-operator of one of Europe's largest networks and a global cloud services platform, has been named “Bronze Sponsor” of SYS-CON's 18th Cloud Expo, which will take place on June 7-9, 2015 at the Javits Center in New York, New York. Interoute is the owner-operator of one of Europe's largest networks and a global cloud services platform which encompasses 12 data centers, 14 virtual data centers and 31 colocation centers, with connections to 195 ad...
One of the bewildering things about DevOps is integrating the massive toolchain including the dozens of new tools that seem to crop up every year. Part of DevOps is Continuous Delivery and having a complex toolchain can add additional integration and setup to your developer environment. In his session at @DevOpsSummit at 18th Cloud Expo, Miko Matsumura, Chief Marketing Officer of Gradle Inc., will discuss which tools to use in a developer stack, how to provision the toolchain to minimize onboa...
SYS-CON Events announced today that Fusion, a leading provider of cloud services, 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. Fusion, a leading provider of integrated cloud solutions to small, medium and large businesses, is the industry's single source for the cloud. Fusion's advanced, proprietary cloud service platform enables the integration of leading edge solutions in the cloud, including clou...
Most people haven’t heard the word, “gamification,” even though they probably, and perhaps unwittingly, participate in it every day. Gamification is “the process of adding games or game-like elements to something (as a task) so as to encourage participation.” Further, gamification is about bringing game mechanics – rules, constructs, processes, and methods – into the real world in an effort to engage people. In his session at @ThingsExpo, Robert Endo, owner and engagement manager of Intrepid D...