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

Search results for MySQL Master Master Repliction

Unix+clones

Resetting a forgotten MySQL root password

Post date: October 2, 2006, 09:10 Category: Security Views: 4633 Comments
Tutorial quote: Resetting the root password of a MySQL database is trivial if you know the current password if you don't it is a little tricker. Thankfully it isn't too difficult to fix, and here we'll show one possible way of doing so.
Debian

Creating Advanced MySQL-Based Virtual Hosts On Lighttpd (Debian Etch)

Post date: August 19, 2008, 10:08 Category: Software Views: 3161 Comments
Tutorial quote: This guide explains how you can create advanced virtual hosts on a lighttpd web server on Debian Etch that are stored in a MySQL database. The method described here does not use the lighttpd mod_mysql_vhost module, and unlike mod_mysql_vhost (which allows you to store only the hostname and document root of a vhost in a database), this method allows to store individual configuration directives for each vhost in the MySQL database.
Unix+clones

High Performance MySQL

Post date: December 1, 2006, 04:12 Category: Optimizing Views: 5833 Comments
Tutorial quote: The operating system your MySQL server runs on and the server's configuration can be just as important to your server's performance as the indexes, schema, or queries themselves. In this chapter, we will help you understand how to tune your server to improve performance, as opposed to tuning schema or queries. We'll be looking at changes to your hardware, operating system, and MySQL configuration to see what effects they have on overall performance.

We assume that you've already made efforts to boost the performance of your queries. If you haven't done that already, stop now and read Chapter 4 and Chapter 5 to get a handle on optimizing your queries and your application code. Only then should you worry about server settings. Hardware is often not the solution to MySQL performance problems. Poorly optimized queries can slow you down far more than not having the latest CPU or SCSI disk. To put this in perspective, one of the MySQL AB trainers even says that changing hardware might, in the best cases, give you a 10-fold performance increase. But tuning queries (and schemas) can often give you 1000-fold performance increase. Seriously.

Some topics covered in this chapter are platform-specific. The authors' knowledge of the various platforms on which MySQL runs is limited. In many cases, you'll need to consult your local documentation for various operating system tools and specifics.

We start with an overview of the factors that limit performance and then look more in depth at RAID, hardware, and operating system issues. The chapter finishes with a discussion of techniques you can use to locate, identify, and fix bottlenecks.
Solaris

AMPS (Apache MySQL PHP SSL) for Solaris 10

Post date: January 26, 2007, 06:01 Category: Software Views: 8823 Comments
Tutorial quote: The strategy is to utilize as much of the Open Source and other free software bundled with Solaris 10 as possible and integrate Apache2, MySQL, PHP and SSL in a environment that can take full advantage of Solaris 10 zones, resource management and highly scaleable, secure System Administration.
Gentoo

Apache with mpm-worker + PHP 5 + SSL + MySQL 4.1

Post date: June 5, 2005, 22:06 Category: Network Views: 5641 Comments
Tutorial quote: We can do Apache 2 with mpm-worker with PHP 5, along with SSL and MySQL 4.1. I tested my configuration with Apache 2.0.53, PHP 5.0.4, and MySQL 4.1.11.
Mandriva

Virtual Users & Domains With Postfix, MySQL & SquirrelMail (Mandriva 2008.1)

Post date: April 15, 2008, 11:04 Category: Installing Views: 3194 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 will 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.
Fedora

Virtual Hosting With Proftpd And MySQL (Incl. Quota) On Fedora 7

Post date: August 12, 2007, 22:08 Category: Installing Views: 2614 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 Users/Domains With Postfix, Courier, MySQL, SquirrelMail (Ubuntu 9.04)

Post date: June 11, 2009, 12:06 Category: Installing Views: 2840 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.
Ubuntu

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

Post date: July 3, 2008, 08:07 Category: Installing Views: 3606 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.
Debian

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

Post date: April 27, 2007, 23:04 Category: Installing Views: 2813 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.
Web-based applications and online marketing solutions - LumoLink