Welcome!

Linux Containers Authors: Elizabeth White, Mano Marks, Mehdi Daoudi, Pat Romanski, Carmen Gonzalez

Related Topics: Linux Containers

Linux Containers: Article

State Government Leads the Way with LAMP

An online database using open source tools

Jim Willis, director of e-Government Services for the Rhode Island Office of the Secretary of State, was a consultant for the state when he implemented an online database using open source tools. The ability to use open source technologies was a condition of his hiring, and the state has benefited as a result of his leadership.

Putting Linux in Plain View

The first project Willis undertook was an online rules and regulations database available to the public and other government agencies. It was the proof that open source tools could deliver value for less. The whole project was delivered for $40,000 with Willis working alone part time for four months. Because the new online database faced the public, it was the perfect test for open source value.

Willis was promoted to director of e-Government after the next election of a new Secretary of State, and he took on the role of advising other agencies on the use of open source. A high-level member of the new secretary's staff was well versed in open source, and encouraged a more open attitude toward Willis' proposals. A trend of working to improve efficiency in IT has also worked in favor of open source adoption.

The LAMP Development Model

A major trend has emerged in Internet development utilizing four open source tools or platforms: Linux for the operating system; Apache for the Web server; MySQL for the database; and PHP, Perl, or Python for the custom code (LAMP). Willis used these tools for the rules and regulations database and was able to complete the project in less time than other development models would have allowed.

Willis has been consistently pleased with the performance of the MySQL database. It is running on a Dell server with Red Hat preinstalled, with almost perfect uptime. MySQL was also included in the Red Hat installation. Agencies use a custom PHP form to upload their regulation files in PDF format. Willis was already familiar with PHP, so it was a natural choice. Some freely available Perl code was adapted to provide certain functions as well, but the vast majority of development occurred using PHP.

A big advantage of open source is that help is easier to find. Willis recommends developing staff who are able to find the solutions to problems because no one has memorized how to handle every situation. You just have to know where to look. "I've called Red Hat for support just once, when I was getting started. Google is really the first line of support."

Saving Time Is More Important Than Saving Money

After his initial success with the rules and regulations online database, Willis looked for other ways to use open source software. He started by replacing an Exchange server with Courier IMAP and QMail on Linux, and replacing Outlook with SquirrelMail, a Web-based e-mail client. Users were having trouble with Outlook, and his staff was spending too much time supporting it. Willis picked the e-mail system as a good migration candidate because he knew it would save both money and time. It took Willis' team two days to migrate the mail server. They saved money in licensing costs by replacing Windows and Microsoft Exchange, but the biggest benefit has been the free time to devote to other projects. Willis says that he saves between 6–10 hours per week of support time with the new system. The reliability of open source software on Linux is allowing him to pursue other projects that will benefit the public.

Cost is still an issue, of course. Before starting on any migration to open source, Willis does an informal analysis to find out how much it will save the state. In his case, it's sufficient justification to proceed.

Web Servers and Databases

The next step was to start migrating Web servers and database servers. Willis had several Microsoft IIS servers that needed to be upgraded. By now, his staff was familiar with Apache, so they used Linux and Apache as a replacement for Windows and IIS. There was one glitch, however. They had previously written Active Server Pages that needed to be converted to PHP and Perl.

According to Willis, when you have applications "write" code for you, rather than code by hand, it's hard to know later what you've done. This made it somewhat difficult to convert the applications. They tried some conversion tools, such as asp2php. It worked sometimes, but Willis found that it was easier to rewrite the applications. Most of them were just database query scripts, which were easy to rewrite, and took about 3–4 days per script. All of the servers that Willis' team has converted have paid for themselves already.

Advice for Other States

Now other states are asking Jim Willis for advice in adopting open source. His advice for getting started is to take on a small migration project first to prove to colleagues that it will work. "Don't pick something critical for the first project.

Pick a server that provides an important service, though, that people will be able to see in action."

He generally plans a migration when one of two things happen: he is tired of always supporting a problem system, or he needs to purchase an upgrade.

Open Source Software Utilized

The State of Rhode Island Secretary of State's office saves 6–10 hours per week of support time with a migration to Linux and a Web-based e-mail solution, instead of Microsoft Exchange and Outlook.

Open source products used are:

  • Red Hat Linux
  • Apache Web server
  • MySQL database
  • PHP Web scripting language
  • Courier IMAP, QMail
  • SquirrelMail

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
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...
WebRTC is bringing significant change to the communications landscape that will bridge the worlds of web and telephony, making the Internet the new standard for communications. Cloud9 took the road less traveled and used WebRTC to create a downloadable enterprise-grade communications platform that is changing the communication dynamic in the financial sector. In his session at @ThingsExpo, Leo Papadopoulos, CTO of Cloud9, discussed the importance of WebRTC and how it enables companies to focus o...
Big Data engines are powering a lot of service businesses right now. Data is collected from users from wearable technologies, web behaviors, purchase behavior as well as several arbitrary data points we’d never think of. The demand for faster and bigger engines to crunch and serve up the data to services is growing exponentially. You see a LOT of correlation between “Cloud” and “Big Data” but on Big Data and “Hybrid,” where hybrid hosting is the sanest approach to the Big Data Infrastructure pro...
In his General Session at 16th Cloud Expo, David Shacochis, host of The Hybrid IT Files podcast and Vice President at CenturyLink, investigated three key trends of the “gigabit economy" though the story of a Fortune 500 communications company in transformation. Narrating how multi-modal hybrid IT, service automation, and agile delivery all intersect, he will cover the role of storytelling and empathy in achieving strategic alignment between the enterprise and its information technology.
Buzzword alert: Microservices and IoT at a DevOps conference? What could possibly go wrong? In this Power Panel at DevOps Summit, moderated by Jason Bloomberg, the leading expert on architecting agility for the enterprise and president of Intellyx, panelists peeled away the buzz and discuss the important architectural principles behind implementing IoT solutions for the enterprise. As remote IoT devices and sensors become increasingly intelligent, they become part of our distributed cloud enviro...
With major technology companies and startups seriously embracing IoT strategies, now is the perfect time to attend @ThingsExpo 2016 in New York. Learn what is going on, contribute to the discussions, and ensure that your enterprise is as "IoT-Ready" as it can be! Internet of @ThingsExpo, taking place June 6-8, 2017, at the Javits Center in New York City, New York, is co-located with 20th Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry p...
"LinearHub provides smart video conferencing, which is the Roundee service, and we archive all the video conferences and we also provide the transcript," stated Sunghyuk Kim, CEO of LinearHub, in this SYS-CON.tv interview at @ThingsExpo, held November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA.
Things are changing so quickly in IoT that it would take a wizard to predict which ecosystem will gain the most traction. In order for IoT to reach its potential, smart devices must be able to work together. Today, there are a slew of interoperability standards being promoted by big names to make this happen: HomeKit, Brillo and Alljoyn. In his session at @ThingsExpo, Adam Justice, vice president and general manager of Grid Connect, will review what happens when smart devices don’t work togethe...
"There's a growing demand from users for things to be faster. When you think about all the transactions or interactions users will have with your product and everything that is between those transactions and interactions - what drives us at Catchpoint Systems is the idea to measure that and to analyze it," explained Leo Vasiliou, Director of Web Performance Engineering at Catchpoint Systems, in this SYS-CON.tv interview at 18th Cloud Expo, held June 7-9, 2016, at the Javits Center in New York Ci...
The 20th International Cloud Expo has announced that its Call for Papers is open. Cloud Expo, to be held June 6-8, 2017, at the Javits Center in New York City, brings together Cloud Computing, Big Data, Internet of Things, DevOps, Containers, Microservices and WebRTC to one location. With cloud computing driving a higher percentage of enterprise IT budgets every year, it becomes increasingly important to plant your flag in this fast-expanding business opportunity. Submit your speaking proposal ...
Discover top technologies and tools all under one roof at April 24–28, 2017, at the Westin San Diego in San Diego, CA. Explore the Mobile Dev + Test and IoT Dev + Test Expo and enjoy all of these unique opportunities: The latest solutions, technologies, and tools in mobile or IoT software development and testing. Meet one-on-one with representatives from some of today's most innovative organizations
SYS-CON Events announced today that Super Micro Computer, Inc., a global leader in Embedded and IoT solutions, will exhibit at SYS-CON's 20th International Cloud Expo®, which will take place on June 7-9, 2017, at the Javits Center in New York City, NY. Supermicro (NASDAQ: SMCI), the leading innovator in high-performance, high-efficiency server technology, is a premier provider of advanced server Building Block Solutions® for Data Center, Cloud Computing, Enterprise IT, Hadoop/Big Data, HPC and E...
SYS-CON Events announced today that Linux Academy, the foremost online Linux and cloud training platform and community, will exhibit at SYS-CON's 20th International Cloud Expo®, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY. Linux Academy was founded on the belief that providing high-quality, in-depth training should be available at an affordable price. Industry leaders in quality training, provided services, and student certification passes, its goal is to c...
20th Cloud Expo, taking place June 6-8, 2017, at the Javits Center in New York City, NY, 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.
WebRTC is the future of browser-to-browser communications, and continues to make inroads into the traditional, difficult, plug-in web communications world. The 6th WebRTC Summit continues our tradition of delivering the latest and greatest presentations within the world of WebRTC. Topics include voice calling, video chat, P2P file sharing, and use cases that have already leveraged the power and convenience of WebRTC.
"Matrix is an ambitious open standard and implementation that's set up to break down the fragmentation problems that exist in IP messaging and VoIP communication," explained John Woolf, Technical Evangelist at Matrix, in this SYS-CON.tv interview at @ThingsExpo, held Nov 4–6, 2014, at the Santa Clara Convention Center in Santa Clara, CA.
WebRTC sits at the intersection between VoIP and the Web. As such, it poses some interesting challenges for those developing services on top of it, but also for those who need to test and monitor these services. In his session at WebRTC Summit, Tsahi Levent-Levi, co-founder of testRTC, reviewed the various challenges posed by WebRTC when it comes to testing and monitoring and on ways to overcome them.
"A lot of times people will come to us and have a very diverse set of requirements or very customized need and we'll help them to implement it in a fashion that you can't just buy off of the shelf," explained Nick Rose, CTO of Enzu, in this SYS-CON.tv interview at 18th Cloud Expo, held June 7-9, 2016, at the Javits Center in New York City, NY.
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 @...
WebRTC services have already permeated corporate communications in the form of videoconferencing solutions. However, WebRTC has the potential of going beyond and catalyzing a new class of services providing more than calls with capabilities such as mass-scale real-time media broadcasting, enriched and augmented video, person-to-machine and machine-to-machine communications. In his session at @ThingsExpo, Luis Lopez, CEO of Kurento, introduced the technologies required for implementing these idea...