Click here to close now.




















Welcome!

Linux Containers Authors: Kevin Jackson, Elizabeth White, Pat Romanski, Liz McMillan, Esmeralda Swartz

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
As more and more data is generated from a variety of connected devices, the need to get insights from this data and predict future behavior and trends is increasingly essential for businesses. Real-time stream processing is needed in a variety of different industries such as Manufacturing, Oil and Gas, Automobile, Finance, Online Retail, Smart Grids, and Healthcare. Azure Stream Analytics is a fully managed distributed stream computation service that provides low latency, scalable processing of streaming data in the cloud with an enterprise grade SLA. It features built-in integration with Azur...
A producer of the first smartphones and tablets, presenter Lee M. Williams will talk about how he is now applying his experience in mobile technology to the design and development of the next generation of Environmental and Sustainability Services at ETwater. In his session at @ThingsExpo, Lee Williams, COO of ETwater, will talk about how he is now applying his experience in mobile technology to the design and development of the next generation of Environmental and Sustainability Services at ETwater.
SYS-CON Events announced today that Micron Technology, Inc., a global leader in advanced semiconductor systems, will exhibit at the 17th International Cloud Expo®, which will take place on November 3–5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. Micron’s broad portfolio of high-performance memory technologies – including DRAM, NAND and NOR Flash – is the basis for solid state drives, modules, multichip packages and other system solutions. Backed by more than 35 years of technology leadership, Micron's memory solutions enable the world's most innovative computing, consumer,...
SYS-CON Events announced today that Pythian, a global IT services company specializing in helping companies leverage disruptive technologies to optimize revenue-generating systems, has been named “Bronze Sponsor” of SYS-CON's 17th Cloud Expo, which will take place on November 3–5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. 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 DevOps to advance innovation and increase agility. Specializing in designing, imple...
While many app developers are comfortable building apps for the smartphone, there is a whole new world out there. In his session at @ThingsExpo, Narayan Sainaney, Co-founder and CTO of Mojio, will discuss how the business case for connected car apps is growing and, with open platform companies having already done the heavy lifting, there really is no barrier to entry.
SYS-CON Events announced today that HPM Networks will exhibit at the 17th International Cloud Expo®, which will take place on November 3–5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. For 20 years, HPM Networks has been integrating technology solutions that solve complex business challenges. HPM Networks has designed solutions for both SMB and enterprise customers throughout the San Francisco Bay Area.
As more intelligent IoT applications shift into gear, they’re merging into the ever-increasing traffic flow of the Internet. It won’t be long before we experience bottlenecks, as IoT traffic peaks during rush hours. Organizations that are unprepared will find themselves by the side of the road unable to cross back into the fast lane. As billions of new devices begin to communicate and exchange data – will your infrastructure be scalable enough to handle this new interconnected world?
WebRTC has had a real tough three or four years, and so have those working with it. Only a few short years ago, the development world were excited about WebRTC and proclaiming how awesome it was. You might have played with the technology a couple of years ago, only to find the extra infrastructure requirements were painful to implement and poorly documented. This probably left a bitter taste in your mouth, especially when things went wrong.
Through WebRTC, audio and video communications are being embedded more easily than ever into applications, helping carriers, enterprises and independent software vendors deliver greater functionality to their end users. With today’s business world increasingly focused on outcomes, users’ growing calls for ease of use, and businesses craving smarter, tighter integration, what’s the next step in delivering a richer, more immersive experience? That richer, more fully integrated experience comes about through a Communications Platform as a Service which allows for messaging, screen sharing, video...
SYS-CON Events announced today that IceWarp will exhibit at the 17th International Cloud Expo®, which will take place on November 3–5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. IceWarp, the leader of cloud and on-premise messaging, delivers secured email, chat, documents, conferencing and collaboration to today's mobile workforce, all in one unified interface
The Internet of Things (IoT) is about the digitization of physical assets including sensors, devices, machines, gateways, and the network. It creates possibilities for significant value creation and new revenue generating business models via data democratization and ubiquitous analytics across IoT networks. The explosion of data in all forms in IoT requires a more robust and broader lens in order to enable smarter timely actions and better outcomes. Business operations become the key driver of IoT applications and projects. Business operations, IT, and data scientists need advanced analytics t...
With the proliferation of connected devices underpinning new Internet of Things systems, Brandon Schulz, Director of Luxoft IoT – Retail, will be looking at the transformation of the retail customer experience in brick and mortar stores in his session at @ThingsExpo. Questions he will address include: Will beacons drop to the wayside like QR codes, or be a proximity-based profit driver? How will the customer experience change in stores of all types when everything can be instrumented and analyzed? As an area of investment, how might a retail company move towards an innovation methodolo...
Too often with compelling new technologies market participants become overly enamored with that attractiveness of the technology and neglect underlying business drivers. This tendency, what some call the “newest shiny object syndrome,” is understandable given that virtually all of us are heavily engaged in technology. But it is also mistaken. Without concrete business cases driving its deployment, IoT, like many other technologies before it, will fade into obscurity.
Consumer IoT applications provide data about the user that just doesn’t exist in traditional PC or mobile web applications. This rich data, or “context,” enables the highly personalized consumer experiences that characterize many consumer IoT apps. This same data is also providing brands with unprecedented insight into how their connected products are being used, while, at the same time, powering highly targeted engagement and marketing opportunities. In his session at @ThingsExpo, Nathan Treloar, President and COO of Bebaio, will explore examples of brands transforming their businesses by t...
Akana has announced the availability of the new Akana Healthcare Solution. The API-driven solution helps healthcare organizations accelerate their transition to being secure, digitally interoperable businesses. It leverages the Health Level Seven International Fast Healthcare Interoperability Resources (HL7 FHIR) standard to enable broader business use of medical data. Akana developed the Healthcare Solution in response to healthcare businesses that want to increase electronic, multi-device access to health records while reducing operating costs and complying with government regulations.
For IoT to grow as quickly as analyst firms’ project, a lot is going to fall on developers to quickly bring applications to market. But the lack of a standard development platform threatens to slow growth and make application development more time consuming and costly, much like we’ve seen in the mobile space. In his session at @ThingsExpo, Mike Weiner, Product Manager of the Omega DevCloud with KORE Telematics Inc., discussed the evolving requirements for developers as IoT matures and conducted a live demonstration of how quickly application development can happen when the need to comply wit...
The Internet of Everything (IoE) brings together people, process, data and things to make networked connections more relevant and valuable than ever before – transforming information into knowledge and knowledge into wisdom. IoE creates new capabilities, richer experiences, and unprecedented opportunities to improve business and government operations, decision making and mission support capabilities.
Explosive growth in connected devices. Enormous amounts of data for collection and analysis. Critical use of data for split-second decision making and actionable information. All three are factors in making the Internet of Things a reality. Yet, any one factor would have an IT organization pondering its infrastructure strategy. How should your organization enhance its IT framework to enable an Internet of Things implementation? In his session at @ThingsExpo, James Kirkland, Red Hat's Chief Architect for the Internet of Things and Intelligent Systems, described how to revolutionize your archit...
MuleSoft has announced the findings of its 2015 Connectivity Benchmark Report on the adoption and business impact of APIs. The findings suggest traditional businesses are quickly evolving into "composable enterprises" built out of hundreds of connected software services, applications and devices. Most are embracing the Internet of Things (IoT) and microservices technologies like Docker. A majority are integrating wearables, like smart watches, and more than half plan to generate revenue with APIs within the next year.
Growth hacking is common for startups to make unheard-of progress in building their business. Career Hacks can help Geek Girls and those who support them (yes, that's you too, Dad!) to excel in this typically male-dominated world. Get ready to learn the facts: Is there a bias against women in the tech / developer communities? Why are women 50% of the workforce, but hold only 24% of the STEM or IT positions? Some beginnings of what to do about it! In her Opening Keynote at 16th Cloud Expo, Sandy Carter, IBM General Manager Cloud Ecosystem and Developers, and a Social Business Evangelist, d...