Free Articles on Computer and many other topics
Another free Computer article for you by Levi Reiss
Titled: Top The Ten Reasons For Learning Damn Small Linux - Number 5, Linux, Apache, and MySQL Get the Computer category RSS Feed

Top The Ten Reasons For Learning Damn Small Linux - Number 5, Linux, Apache, and MySQL

Article Summary: Linux has many advantages over Microsoft Windows. This article discusses its companion programs, the Apache web server and the MySQL database management system. Other articles talk about its free applications, Linux's integration with the Internet, resistance to viruses, how it improves your control over the computer, the road to Linux certification and more. Be sure to read our companion series on Linux concepts.

Linux and Windows have many things in common. For example, most people aren't very interested in knowing how they work. Both of these operating systems make the computer available for the applications that people want to apply; such as running an Internet server, browsing the Internet, creating and accessing data bases, writing programs, playing music, or, or, or. All these tasks are coordinated by the operating system and require specialized programs that drive hardware efficiently and correctly. We'll talk about Linux's closely integrated "friends" and compare them to the similar but oh so different Microsoft offerings.

The Linux group is called LAMP, an acronym standing for Linux, Apache, MySql, and PHP. There is no similar acronym for the Microsoft set of interacting products. Could that be a symptom of their relatively low level of integration? In contrast Linux is closely integrated with the other LAMP components. In a sense these companions grew up together. Improvements to one component are easily transmitted to the others. These programs are all Open Source meaning that the actual code for all components is readily available. When a security breach occurs (don't let anybody tell you there are no security breaches in Linux and friends) people work on the problem and may post corrections rapidly. Now let's look at the other LAMP components.

Apache is a quite highly regarded web server. It has been the most popular web server on the Internet since April, 1996. Believe me, if Microsoft with its virtually unlimited resources cannot dislodge Apache from the top of the pack this software must be doing a lot of things right. Of the four LAMP components Apache is the one that non-specialists are least likely to try to learn. But if you want to play with it, guess how much it costs. You can download a version which will run under Windows but it is unlikely to contain the full functionality. At the time of this writing the Windows version of Apache has some problems concerning its cryptographic functions. Apache is undergoing constant development; its new features such as security enhancements and bug fixes will be available first on the Open Source (LAMP) version. And then filter down to the Windows version.

MySQL is the most popular Open Source Database Management System. The MySQL Community Server is free. The more powerful MySQL Enterprise Server starts at $595 per server per year, a very reasonable price for a commercial product. Microsoft's competitive database management system is Microsoft SQL Server. Licensing of this software is fairly complicated and believe me, costs a lot, lot more than does MySQL Enterprise Server. Microsoft often makes you pay for purchasing the server and client software and then pay annual server licenses and client licenses for system access.

MySQL runs on a wide range of hardware in conjunction with various operating systems. You can guess from its name that Microsoft SQL Server runs only under Windows. Both of these database management products are constantly upgraded and many technical features that once were available only on SQL Server now run on MySQL. In the past SQL Server clearly surpassed MySQL for enterprise-level systems, while itself often losing out to Oracle or other database management systems. Today's reality is more complicated and MySQL Enterprise Server manages many huge database systems.

Talking about size, we didn't finish discussing LAMP components in this article. PHP is the subject of the next one in this series.

Article Source: http://www.upublish.info

About the Author:
Levi Reiss
Once upon a time Levi Reiss wrote ten computer and Internet books either alone or with a co-author. The books are over, at least for the time being, replaced by a multitude of websites, including global wine, Italian wine, Italian travel (www.travelitalytravel.com ), and health and nutritional aspects of wine. He has taught various and sundry computer courses including Linux and Windows operating systems at an Ontario French-language community college for decades. His new website http://www.linux4windows.com teaches you how to download and run Damn Small Linux even on that outdated Windows computer which has been gathering dust in the basement.