views:

3108

answers:

22

Is the LAMP (Linux, Apache, MySQL, PHP / Ruby / Python) stack appropriate for Enterprise use?

To be clear, by "Enterprise", I mean a large or very large company, where security, robustness, availability of skill sets, Total Cost of Ownership (TCO), scalability, and availability of tools are key considerations. Said another way, a company that looks for external adoption of frameworks / architecture - Something ubiquitous will be seen as more "valid" than something exotic / esoteric in this kind of environment.

I've seen use cases where Oracle, IBM, and Sun have implemented systems on the LAMP stack for various Enterprises. I've also seen examples where websites like yellowpages.com (Ruby on rails) and Facebook (php) are built on it. However, none of these examples are exactly what I'm looking for.

I'm really trying to find examples where it is an Enterprise standard at a very large bank (I.e., Citigroup), Telecom company (I.e., AT&T), or manufacturer (I.e., Proctor and Gamble). Just to be clear, I'm not looking for an example where it's used in a limited sense (Like at JPMorgan Chase), but where it's a core platform for systems like CRM, manufacturing systems, or HR management, as well as for internal and external websites.

The perception I've seen so far is that applications built on the LAMP stack perform slower and are less flexible. Some of the arguments I've heard are:

  • Linux is seen as not as well supported as Unix, Solaris, or Windows Servers.

  • Apache is harder to configure and maintain than web servers like BEA WebLogic or IIS.

  • MySQL is a "not ready for prime time" DB for hobbyists, and not a competitor for SQL Server or Oracle (Although PostgreSQL seems to have a reputation for being more robust).

  • PHP / Ruby on rails are optimized for CRUD (Create, Read, Update and Delete operations). Although this is an advantage when building CRUD-intensive web aplications, both perform slower than Java/JEE or C# (which are both common Enterprise standards). Furthermore, a lot of applications and systems (like manufacturing systems) have a lot of non-CRUD functionality that may be harder to build with PHP or Ruby, or even Python.

Can anyone please provide arguments to support or refute the idea of the LAMP stack being appropriate for the Enterprise?

Thanks!

KA

UPDATE: Some times the LAMP Stack is Appropriate for Enterprise Use: Externally-Facing Blogs

+12  A: 

Google, Yahoo, and many other companies think it is a good solution.

http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleId=263611&pageNumber=2

EBGreen
Strange. The article even says, "But you probably wouldn’t want to run your core financial systems on LAMP; until recently, MySQL didn’t even understand the notion of a transaction."
Yar
you're right, for any sensitive data I would prefer PostgreSQL to MySQL
chburd
yep, LAPP instead of LAMP ;)
alexanderpas
A: 

no it doesn't scale, lol :D

Nils
StackOverflow isn't really the place for offhand, joking answers. You'll get much better results if you take the time to think and provide helpful answers instead.
Jeff
I think he got the point. No need to bring his answer down to -50...
m_oLogin
So comments are OK for joking, but answers aren't?
Mike C.
@Mike C.: pretty much, yeah.
voyager
A: 

There are two main issues for large enterprises using LAMP stacks:

  • TCO: taking into consideration that LAMP basically comes free, enterprises still acheive a lower total cost of operation with other commercial solutions
  • Supportability: enterprises have no problem paying the extra buck to get around-the-clock proffessional support from their commercial vendors
Yuval A
Yuval, TCO includes support costs - I've seen studies where the TCO of open source software can be higher than propriatary because the skill sets are less common (and therefore more expensive). Can you please provide support?
Kaiser Advisor
I know, this is what I said, or at least what I meant :)
Yuval A
sorry - I re-read it - it's clear now :)
Kaiser Advisor
+16  A: 

"but where it's a core platform for systems like CRM and HR, as well as for internal and external websites"

First, find a LAMP CRM or HR application.

Then find a customer for the LAMP CRM or HR application.

Sadly, there aren't a lot of examples of item 1. Therefore, your case is proven. It can't be used for enterprise applications because -- currently -- there aren't any of the applications you call "enterprise".

Your other points, however, are very interesting.

  1. Linux is seen as not as well supported as Unix, Solaris, or Windows Servers. I think Red Hat would object strongly to this. Give them a call. I think they'll make a very persuasive sales pitch. Read their success stories.

  2. Apache is harder to configure and maintain than web servers like BEA WebLogic or IIS. By whom? Apache web site managers? Or IIS web site managers? This is entirely subjective.

  3. MySQL is a "not ready for prime time" DB. Take it up with Sun Microsystems. I think they'd object strongly to this. Give them a call. I think they'll make a very persuasive sales pitch. Read their success stories.

  4. PHP / Ruby on rails are optimized for CRUD, and both are slowly performing. Could be true. Java and Python might be faster. PHP and Ruby aren't the last word in LAMP.

S.Lott
SugarCRM is pretty heavily used.
ceejayoz
SugarCRM is also junk, so not a great example.
Rob Williams
More to the point, it's subjective. It's too easy to debate if it's "enterprise" enough or if a given customer is like the "enterprises" listed in the question.
S.Lott
You might want to mention that FastCGI gets around a lot of the performance problems with Perl/PHP/Ruby/Python. PHP also benefits from having an opcode cache such as APC installed.
R. Bemrose
I like the way you cited Red Hat in the Linux example - Do you know off hand what references they would cite?
Kaiser Advisor
@Kaiser Advisor: http://www.redhat.com/about/
S.Lott
@SLott - Thanks!
Kaiser Advisor
Actually PHP *is* the last word in LAMP.
Dan Dyer
@Dan Dyer: Funny, the Python folks keep telling me that Python is the last word in LAMP.
S.Lott
PostgreSQL people usually say that M is for Middleware and P is for PostgreSQL
chburd
Call Zend, I think they'll make a very persuasive sales pitch
jpartogi
@Dan Dyer: Just as much as XML is the last word in AJAX, but I use JSON nonetheless. What S.Lott is saying is that you are not tied to PHP, just as much as you are not tied to Linux. You could use FreeBSD, lighthttpd, PostgreSQL and Python and it would still be LAMP (FLPP doesn't have the same ring to it ;)
voyager
+1  A: 

IMO there are no good general arguments against Linux and Apache; You can certainly get enterprise-level support for Linux if you're prepared to pay for it (and a good approximation of it for free if you're willing to play by the community's rules). And Apache is not that hard to configure unless you need its more complex features, which is unlikely in an application server.

You can certainly make a case against MySQL since some of the most important features in regard to data safety have been added only recently. If you're concerned about that, use PostgreSQL instead.

As for the language you write your app in: PHP has definitely proven to be able to run extremely large and complex systems; I'd be more concerned about maintainability than performance. And Ruby on Rails is "optimized for CRUD" only in asmuch as a simple CRUD webapp can be written in nearly no time (literally minutes), but that does not mean it is somehow less suited to more complex apps, just that it will take much more time (still less than with many other languages)

Michael Borgwardt
A: 

Redhat and IBM give full support for Linux, Sun bought MySQL, Yahoo uses Php, numerous companies use a LAMP stack, but many use parts.

Robert Gould
Why the down vote? Seems like some random shooting just happened as JeeBee's answer and mine got down voted, for no apparent reason
Robert Gould
+2  A: 

strictly a subjective opinion but I personally find MySQL and to a lesser extent PHP to be a bit of a weakness, but certainly there's plenty of people who disagree and big companies who went LAMP.

I'd prefer to see postgres or even SQLite take chunks out of the MySQL market, and I'd like to see mono or jsp or cocoon based apps more. I guess LAMP is a bit too specific for an umbrella term. :)

annakata
+1  A: 

I think you will find that many enterprises use Linux servers, often supported by Redhat, Novell or IBM, and that Apache is also commonly used.

But many enterprises tend to use databases like Oracle or IBM DB2 instead of open source offerings - although there are many enterprises that don't really need the kind of power those systems provide and could get away with MySQL or PostgreSQL.

And for the web-server language, I think you can use just about anything. However, if you use Apache it is probably easier to use PHP, Ruby or Python, whereas if you use IIS or Weblogic or Domino it will be easier to do it in Java / C#.

Technical Bard
A: 

Linux is used a lot. Apache and Tomcat are used a lot. MySQL may be robust now. I'd use PostgreSQL instead. Banks will use Oracle, but there's good support for Java and Tomcat there. PHP is used a lot, but many big companies would prefer Java.

You're best off arguing for a Linux, (possibly commercially supported version of) Tomcat, Java, Tomcat|Oracle|MSSQL solution, in my opinion.

You'll need a Linux sysadmin, especially as the number of servers ramps up, although I'm sure you can get a part time one in before that time arises. If the company already has Windows sysadmins then arguing for Linux is going to be tough.

JeeBee
+3  A: 

I just want to add that I've witnessed many times that clients only feel comfortable once they dish out serious $$$ for some solution, even if it makes enterprise integration even harder, despite what arguments you bring to the table.

kRON
I'm sure RedHat and Sun will happily accept giant piles of cash from your company :-)
Orion Edwards
reminds me of: http://thedailywtf.com/Articles/A-Software-Problem,-A-Marketing-Solution.aspx
annakata
+3  A: 

If you hire idiots to implement it, C++ & Oracle will fail to scale. If you hire people who are smart and get things done, PHP & MySQL will scale just fine.

Same argument goes for security & robustness.

Facebook, Digg, portions of Yahoo run on PHP. Of course, they hire lots of PhD programmers.

lo_fye
yes that's the answer, programming language does not matter much, good coders do!
Nils
I think it is also highly unlikely most developers will work on systems where scalability is a big issue. All common platforms (LAMP, .NET, UNIX etc) can easily handle very large scale. Unless you are building the next Google you have more to worry about than that.
Craig
+4  A: 

I think the first criteria should be your team's skill level, comfort level jut to make sure what ever platform decisions are made works well with them. Whatever you decide think of scalability and maintainability of your code. Tools are awesome no matter what stack you choose.

I personally would break it down into 3 stacks-

  1. The Java Stack where you have Solaris or Enterprise Linux like ( RedHat ) with Weblogic/Websphere/Tomcat etc and Java Enterprise along with Hibernate,Spring etc technologies. Most would opt for Oracle as DB.

  2. The Microsoft Stack with some Open Source if needed Win Server - IIS - .net/C# (ASP.net etc) - NHibernate, NUnit (unit testing) etc. Most likely you would want to use SQL Server as DB

  3. None of the above stack with Enterprise Linux running a whole buffet of open source stuff like MySQL (now under Sun's domain so can be looked at seriously), Apache (there are apache gurus out there), Ruby ( not my personal choice)/ PHP (good luck) / Python (I like it because its a mature language). I would advocate python or ruby from the managing code point of view. Maybe for some it could be PHP..i am not into it.

Perpetualcoder
+1  A: 

I personally don't see Linux as being less well supported than the other OS mentioned; in fact hardware vendors typically DO support Linux over any other OS (except for Windows, which they do generally support quite well provided you use maintream distributions).

Provided you don't use a bizarre flavour (Tip: Just use RHEL or Centos which is its free equivalent), Linux is very well supported.

MySQL may have some shortcomings, but in my opinion it has many strengths; we use it at a large scale in ways not intended, but it still works quite well generally (most of the problems are due to our versions being out of date or badly configured).

What "P" stands for in LAMP is debatable. I feel that PHP is not enterprise-ready, because it has so many individual shortcomings (e.g. poor unicode handling, no namespaces, inconsistent APIs, inconsistent syntax, poor version backwards compatibility, duplicated/obsolete functionality) that they add up to making it difficult to implement a maintainable system.

But given an appropriately experienced team, even if you choose PHP it can be used to make an extremely high quality application.

MarkR
+3  A: 

Linux/Apache are hardened, lean and each comes with plenty of people(for the right price of course) who will provide support, plenty of useful tools, many at exceptionally high levels of utility which work with them and which have been built upon them.

Not sure about the other two, however. In particular MySQL seems to have taken a strange turn for the worse since their being acquired by Sun, contrary to the posts in this thread suggesting that Sun may be a good influence:

http://www.reddit.com/r/programming/comments/7gb8j/oops_we_did_it_again_mysql_51_released_as_ga_with/

themusicgod1
+7  A: 

Something ubiquitous will be seen as more "valid" than something exotic / esoteric in this kind of environment.

Although I personally wouldn't recommend PHP due to the many flaws in the language, it's most certainly ubiquitous. With the advent of phusion passenger, Rails support amongst shared-hosting companies is growing pretty quickly too. I give it another year or 2 at most before 90+% of shared-hosting accounts support rails out of the box. If that's not ubiquitous, what is?

Linux is seen as not as well supported as Unix, Solaris, or Windows Servers.

If this bothers you, purchase support from RedHat, or install Solaris and purchase support from Sun. Both of those will give you just as good support as Microsoft is likely to

Apache is harder to configure and maintain than web servers like BEA WebLogic or IIS.

I can't speak for BEA WebLogic, but having configured both Apache, IIS, and Tomcat, Apache is the easiest both to understand, and to find examples and documentation for by a long way.

MySQL is a "not ready for prime time" DB for hobbyists, and not a competitor for SQL Server or Oracle.

Oh really?. You should make it your mission to tell NASA, Google, CERN, Reuters etc that they're all using a hobbyist database that isn't ready for prime-time.

PHP / Ruby on rails are optimized for CRUD, and both perform slower than Java/JEE or C# (which are both common Enterprise standards).

There are 2 things here:

Optimized for CRUD - This is totally irrelevant.
Rails and some of the python/php frameworks are optimized for CRUD apps. Many of the C#/Java frameworks are also optimized for CRUD apps. However, if the app you're building is a CRUD app (and 99% of web applications are), isn't this a Good Thing?
If you're not building a CRUD app, there are plenty of non-crud-optimized frameworks in ruby/python/php/java/C#. Net win: Nobody (hence it's irrelevant)

Perform slower than Java/C# - This is undoubtedly true, but it also doesn't matter. For a low-traffic site the performance difference isn't going to amount to anything, and for a high-traffic site your bottleneck will be the database, whether it be MySQL, oracle, or whatever.

What you trade-off for all of this is development time. Once you've used all this advice to convince your boss that you won't lose out on anything by using LAMP, If you crunch the numbers and show your them that it is going to take 6 man-months to build the site in Java, and only 3 to build it in ruby/python then that's really what it comes down to.

Orion Edwards
+4  A: 

Just thought I'd add another website to the list of those that run on LAMP - Wikipedia. Seventh biggest website in the world, written entirely in PHP and runs off MySQL, and they only have two or three paid developers. Of course, they have some assistance from volunteers, but it's not a lot, and it's scaled just fine. Don't know if you'd really call them 'enterprise', but for such a huge and popular website they seem to have done alright for themselves.

Linux is seen as not as well supported as Unix, Solaris, or Windows Servers.

As others have said above, give Red Hat a call and I'm sure they'll beg to differ. And the amount of support out there for Linux absolutely free is astonishing.

Apache is harder to configure and maintain than web servers like BEA WebLogic or IIS.

That depends who you're asking. People who usually administer IIS servers will probably view it this way. People who usually administer Apache won't. It depends on who you hire, and if your stack is LAMP you won't want to be hiring people with no Apache experience anyway.

naeblis
+2  A: 

I suppose that large commercial CRM and HR applications might be biased toward delivering large commercial RDBMS products as the foundation for their products. If nothing else they will I'm sure prefer to unite against a common threat.

And they have a harder time justifying license and support fees if they integrate products that don't have them.

le dorfier
+1  A: 

My 2c:

Linux: Since kernel 2.6 came out, I would say it is definitelly a high-quality OS. Version 2.4 wasn't quite there and 2.2 was a joke, but 2.6 is really good. Be careful with a choice of distribution, though. In my experience, RedHat/CentOS is very good, and apparently Debian (original, not Ubuntu!) can be set up nicely if you have a good admin. My experience with OpenSUSE was not very good.

Apache: Haven't used it, but I don't see why it would be a problem.

MySQL: This is the weakest point of the stack. I am not going to go into details here - look into comments at reddit.programming if you are interested. Better look at PostgreSQL.

PHP/Perl/Ruby/Python: I have worked with Perl and to a lesser extent with Python. They are probably OK for web-based applications where the bulk of the work is done by the web server and DBMS anyway. However, I do prefer static type system and would rather pick Java/C# for a business application and C++ for system programming.

Nemanja Trifunovic
+2  A: 

The reason for not finding Enterprise applications built on LAMP is not because they aren't enterprise level but something entirely different in my opinion. A lot of the big players use LAMP or similar--Facebook and MySpace immediately come to mind. So its clearly not an issue of scale and perf.

That said, the reason I find that there aren't any enterprise apps built on LAMP is because of their intrinsic open nature. I don't want to build an actuarial module as a PHP file because anyone can steal the logic. On the other hand if I have a DLL I can retain control. You don't find a lot of 30-trial apps built on PHP for this very reason but it's much easier to achieve that kind of protection with say ASP.NET.

aleemb
MySpace is built with .NET not LAMP.
Craig
A: 

If it's good enough for Google, trust me, it's good enough for you.

gargantaun
What do Google do with standard LAMP. AFAIK there platform is highly customised.
Craig
Craig makes a very good point.
IainMH
Which puts the original claim about LAMP being less flexible to rest. And a large chunk of that customization is available to everyone (eg. Google MySQL Tools). But google weighed up all the pros and cons, deliberated and went with LAMP form the start. That customization came later.
gargantaun
+1  A: 

I would like to suggest that we identify the scalability requirements of Enterprise systems and how they differ compared to Web Applications. Look at some of the most scalable systems like Wikipedia, Flickr, Wordpress, Facebook, MySpace and a host of others. You will see LAMP stack there. I am more of a Python fan (since I feel that the language has a cleaner feel) but I listen to experts like Cal Henderson (Flickr) who wrote a book on scalability talking about how he scaled a bank of MySQL servers.

What are the essential features of an enterprise system?

Support, availability of expertise, stability of the platform/language probably count.

But LAMP has other features like faster development, easier extensibility, lots of available libraries for reuse, several documented stories of scalability, maturing web frameworks.

Here are a couple of pointers to building Scalable systems (I am talking about Web Scale). I always wondered in the light of all this evidence, why the perception of LAMP as not being ready for Enterprise apps keep popping up.

As for Apache, every Netcraft study shows a very different adoption story. By the sheer number of servers, there may be more people with knowledge to configure, tune and extend the web server.

Scalable Web Architectures Please Look at Market Share of all Servers Aug 1995 to Jan 2009

+1  A: 

You have some real bad myths in your posting:

JavaEE Myths: -App Servers easier to configure than apache, nope apache is easier. -You imply that only JavaEE full solution is enterprise, nope.

CRUD Myths: -CRUD is slower than JavaEE? WTF? POJO and EJB is using CRUD. The limiting factor is not crud, its server throughput

There are 3 limiting bottleneck areas no matter what technology even MS..server implementation, persistence layer, and app layer..the technology chosen is not the speed factor as you can exchange advantages in one layer for disadvantages in the other layer. Fro example we could spee dup Java by using document store instead of normal DB..

Most new Rails implementations use non apache servers that are faster by a factor of 3 to 5 than Apache..even a well tunned Apache server can outperform some javaEE stacks..just ask yahoo as they use Symfony on some of their properties..

Fred Grott
upvoted for good perspective
Kaiser Advisor