PUBLIC MARKS with tags mysql & applications

Server2Go is a Webserver that runs out of the box without any installation and on write protected media. This means that web applications based on Server2Go can be used directly from cdrom, a usb stick or from any folder on a hard disk without the hassle of configuring Apache, PHP or MySQL. Server2Go allows you to create a standalone working web site or PHP application on a CD-ROM. There are many examples of its possible useses such as catalogue software, calculation programmes, image campaigns (CMS-based), computer based training lessons or other applicatons. Most PHP-Software such as the content management system Joomla or the computer based training software Moodle can be used from CD-ROM with the help of Server2Go. Server2Go was developed in the first instance for use on CD-ROM but there is no problem in using it from other drives too. Using a web browser, a user can run php programs as well as view html files on the CD-ROM. He only needs to insert a CD with Server2Go. The server software starts automatically and a browser is opened with the Website of the CD-ROM. Server2Go was built in the first place to replace other CD-ROM webservers such as WampOnCD or Microweb that lacked some important features or are not being actively developed. Main Features * Free! No royalties * Complete WAMPP Server-Stack * Runs directly from CD-ROM, USB Stick or Hard disk without installation * Full featured webserver (based on apache) * PHP 5.x support with many extensions installed (e.g. gd) * Supports SQLite databases * Runs on all versions of Windows from Win 98 and above, MAC OSX support is coming * Support for MySQL 5 Databases * Supports many PHP extensions (GD-Lib, PDO...) by default * Support for Perl 5.8

This tutorial explains how you can set up MySQL master-master replication on four MySQL nodes (running on Debian Etch). The difference to a two node master-master replication (which is explained here) is that if you have more than two nodes, the replication goes in a circle, i.e., with four nodes, the replication goes from node1 to node2, from node2 to node3, from node3 to node4, and from node4 to node1. Since version 5, MySQL comes with built-in support for master-master replication, solving the problem that can happen with self-generated keys. In former MySQL versions, the problem with master-master replication was that conflicts arose immediately if node A and node B both inserted an auto-incrementing key on the same table. The advantages of master-master replication over the traditional master-slave replication are that you don't have to modify your applications to make write accesses only to the master, and that it is easier to provide high-availability because if the master fails, you still have the other master.

Since version 5, MySQL comes with built-in support for master-master replication, solving the problem that can happen with self-generated keys. In former MySQL versions, the problem with master-master replication was that conflicts arose immediately if node A and node B both inserted an auto-incrementing key on the same table. The advantages of master-master replication over the traditional master-slave replication are that you don't have to modify your applications to make write accesses only to the master, and that it is easier to provide high-availability because if the master fails, you still have the other master.

A userguide for mysql v5.0.