Two very popular and widely used languages for building dynamic web sites are Perl and PHP. They make up two thirds of the "P" in the Linux Apache, MySQL, Perl/PHP/Python (LAMP) stack. How does their performance, using mod_perl and mod_php, compare for everyday web programming? I attempted to find out.

The MySQL database is unique in that it offers multiple storage engines. The SQL parser and front end interfaces are separate from the storage engines. This lets you choose the low level table format that suits your application best.

If you are like me on a shared hosting server chances are your web hosting account has cPanel or some other administration panel through which you can create/delete MySQL databases (DBs)/DB users. But you will not be able to:

Sometimes we may require to run multiple versions of MySQL on the same Server. This can happen if you either need to test a new MySQL release or you need a new MySQL version and you don't want to make any changes to the existing system.

This tutorial really should be titled "How to get your
Debian server off the ground as quickly as possible", since it's based on
minimal Debian Linux (stable) install.

Here you'll be able to get your box secured very quickly, and then get the
services running with minimum hassle and pain.

I receive a great deal of mail as a result of this HOWTO, much of it asking me to solve various LAMP-related problems. Please bear in mind that the money that puts food on my family's table comes from the consultancy work that I do. If you would like help with any of the points discussed in this article, mail me and tell me what that help is worth to you. Quote any amount you like, and if I'm able to help you out, you can make a PayPal donation by way of thanks. Fair enough?

Introduction
MySQL Cluser Server is a fault-tolerant, redundant, scalable database architecture built on the open-source MySQL application, and capable of delivering 99.999% reliability. In this paper we describe the process we used to setup, configure, and test a three-node mySQL cluster server in a test environment.

When it comes to creating a robust server environment for delivering dynamic content securely and reliably across the Internet, it's practically impossible to beat the LAMP setup. LAMP is an acronym which represents the combination of Linux+Apache+MySQL+PHP which is probably the most common and best-loved collection of server-side technologies on planet Earth.

This tutorial is designed to guide you through the initial steps of setting up an Apache, MySQL, and PHP server on Linux which will utilize an external LDAP server for authenticating users. The server will be able to use either Apache's authentication process (i.e. via httpd.conf), or PHP's (i.e. coded into your app). The Linux distribution being utilized for this tutorial is Fedora Core 2, however the steps should be very similar across most distributions.

Having Your Own Web Server Locally
When designing a web application, as opposed to a web site, you will need to make the jump from client-side technologies like DHTML, to server-side technologies like PHP and Perl. In order to successfully develop in any language, you must possess the ability to test your work before you launch it into the public domain of the Internet. This can be problematic, however, if your web site is hosted remotely by a hosting company, where you need to upload your work to their web server before you can test it. This can be a time-consuming process.

I'm writing this article assuming you're running Windows XP on your computer. Even if you are not, you can use this article to setup these three on almost all basic Windows flavors.

This article may help you to get starting in using MySQL under NT. There is no distinction made between Windows NT, Windows 2000 or Windows XP. These three operating systems support 'Windows services' which you will not find with the Windows 95/98/ME versions.

SQL stands for Structured Query Language.

MySQL runs on a server deamon where users on the same or even remote computers can connect.
Once connected you can select database if you have privileges to do so.
In this tutorial you will learn:
1. How to connect to MySQL.
2. Create a Table
3. Insert data in to you database.
4. Display database data in you browser.
5. Change data.

This tutorial is designed to guide you through the initial steps of setting up Apache, MySQL, and PHP on Linux. The Linux distribution being utilized for this tutorial is Fedora Core 1, however the steps should be very similar across most distributions. This tutorial makes the assumption that you have the required development tools loaded for compiling programs from source, these tools are beyond the scope of this document and will not be covered here. Also, it assumes you can use the vi text editor for basic editing tasks.