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

Linux and Windows share many characteristics. 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. 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 sign 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 that runs 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.articlegoldmine.com

Levi Reiss has authored or co-authored ten books on computers and the Internet. He loves the occasional glass of wine as exemplified by his wine websites including www.theworldwidewine.com. He teaches Linux and Windows operating systems plus other computer courses at an Ontario French-language community college. Visit his new website www.linux4windows.com which enables you to download and run Damn Small Linux on even outdated Windows computers.

Please Rate this Article

5 out of 54 out of 53 out of 52 out of 51 out of 5 

Not yet Rated