Go back to fronty page View most popular entries View latest additions Submit tutorials to UnixTutorials.info
UnixTutorials logo

Search results for High Performance MySQL

Unix+clones

How To Set Up Database Replication In MySQL

Post date: December 14, 2005, 19:12 Category: Software Views: 4599 Comments
Tutorial quote: This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync. This is not a backup policy because an accidentally issued DELETE command will also be carried out on the slave; but replication can help protect against hardware failures though.

In this tutorial I will show how to replicate the database exampledb from the master with the IP address 192.168.0.100 to a slave. Both systems (master and slave) are running Debian Sarge; however, the configuration should apply to almost all distributions with little or no modification.
Ubuntu

Virtual Users/Domains With Postfix, Courier, MySQL, SquirrelMail (Ubuntu 9.04)

Post date: June 11, 2009, 12:06 Category: Installing Views: 3432 Comments
Tutorial quote: This document describes how to install a Postfix mail server that is based on virtual users and domains, i.e. users and domains that are in a MySQL database. I'll also demonstrate the installation and configuration of Courier (Courier-POP3, Courier-IMAP), so that Courier can authenticate against the same MySQL database Postfix uses. In addition to that, this tutorial covers the installation of Amavisd, SpamAssassin and ClamAV so that emails will be scanned for spam and viruses. I will also show how to install SquirrelMail as a webmail interface so that users can read and send emails and change their passwords.
Debian

Virtual Hosting With Proftpd And MySQL (Incl. Quota) On Debian Etch

Post date: April 27, 2007, 23:04 Category: Installing Views: 3319 Comments
Tutorial quote: This document describes how to install a Proftpd server that uses virtual users from a MySQL database instead of real system users. This is much more performant and allows to have thousands of ftp users on a single machine. In addition to that I will show the use of quota with this setup.
Ubuntu

Virtual Hosting With Proftpd And MySQL (Incl. Quota) On Ubuntu 8.04 LTS

Post date: July 3, 2008, 08:07 Category: Installing Views: 4530 Comments
Tutorial quote: This document describes how to install a Proftpd server that uses virtual users from a MySQL database instead of real system users. This is much more performant and allows to have thousands of ftp users on a single machine. In addition to that I will show the use of quota with this setup.
Linux

How To Set Up VMware Tools On Various Linux Distributions

Post date: October 2, 2007, 07:10 Category: Miscellaneous Views: 8781 Comments
Tutorial quote: This document explains how to set up the VMware Tools in the following guest operating systems: Ubuntu 7.04, Fedora 7, PCLinuxOS 2007 and Debian Etch. Installing VMware Tools in your guest operating systems will help maximize performance, provide mouse synchronization and copy & paste functionality. This article also shows a way of making VMware Tools start automatically when you start a guest operating system.
Arch

Creating An RSS Feed With PHP And MySQL

Post date: September 6, 2009, 19:09 Category: Programming Views: 6804 Comments
Tutorial quote: Learn to create a custom RSS feed for your website content. These easy to build XML feeds can extend the reach of your content and grow your audience. This howto shows how to build and serve an RSS feed from your MySQL database.
CentOS

How To Monitor A System With Sysstat On Centos 4.3

Post date: August 29, 2006, 15:08 Category: System Views: 6831 Comments
Tutorial quote: A common task for System Administrators is to monitor and care for a server. That's fairly easy to do at a moment's notice, but how to keep a record of this information over time? One way to monitor your server is to use the Sysstat package.

Sysstat is actually a collection of utilities designed to collect information about the performance of a linux installation, and record them over time.

It's fairly easy to install too, since it is included as a package on many distributions.
Debian

Apache2: Logging To A MySQL Database With mod_log_sql (Debian Etch)

Post date: July 6, 2008, 09:07 Category: Installing Views: 3475 Comments
Tutorial quote: This guide shows how you can write the Apache2 access log to a MySQL database instead of a file. To achieve this, I use the Apache2 module mod_log_sql. I am using a Debian Etch server in this tutorial.
Debian

Setting Up Master-Master Replication On Four Nodes With MySQL 5 On Debian Etch

Post date: November 20, 2008, 12:11 Category: Miscellaneous Views: 3591 Comments
Tutorial quote: 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 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.
Ubuntu

Virtual Hosting With PureFTPd And MySQL On Ubuntu 8.10

Post date: January 29, 2009, 12:01 Category: Installing Views: 3142 Comments
Tutorial quote: This document describes how to install a PureFTPd server that uses virtual users from a MySQL database instead of real system users. This is much more performant and allows to have thousands of ftp users on a single machine. In addition to that I will show the use of quota and upload/download bandwidth limits with this setup. Passwords will be stored encrypted as MD5 strings in the database.
Web-based applications and online marketing solutions - LumoLink