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

Debian

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

Post date: August 19, 2008, 10:08 Category: Software Views: 3164 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.
SmoothWall

Install SquidGuard on Smoothwall

Post date: April 12, 2005, 18:04 Category: Software Views: 10805 Comments
Tutorial quote: squidGuard describes itself as: "An ultrafast and free filter, redirector and access controller for Squid". In my experience, it is the ideal web filter for use with Smoothwall and IpCop since it is lightweight and easy to set up. I use it on an i486, 33Mhz system with 18Mb of Ram and 500Mb of hard drive - and while there is a minor performance hit, the hit is not significant.

This simple how-to describes the steps I took to install squidGuard on my system - it should work for yours too.
Linux

Optimizing Desktop Performance, Part II

Post date: May 24, 2005, 18:05 Category: Optimizing Views: 3398 Comments
Tutorial quote: As we discussed in last week's article, for most of its existence, people have distributed Linux as a workstation or a server rather than as a desktop. The default workstation that evolved has existed mostly for use by developers. So, when you install a Linux distribution with a graphical interface, it generally looks like what a developer might want. In addition, it performs similar to how many UNIX workstations work, which can seem slow.

In this article, we continue to look at the Linux desktop in a different light. Here, we think of it as a computer system with a fast interface that we can optimize for the knowledge worker and consumer.
Solaris

AMPS (Apache MySQL PHP SSL) for Solaris 10

Post date: January 26, 2007, 06:01 Category: Software Views: 8824 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.
Unix+clones

Xen Disk I/O benchmarking: NetBSD dom0 vs Linux dom0

Post date: April 21, 2005, 10:04 Category: Benchmarks Views: 3020 Comments
Tutorial quote: Xen is a relatively new technology to enable several virtual machines (domU) to run on one computer. The purpose of this article is to determine what operating system (NetBSD or Linux) should be selected as domain 0 (dom0) operating system to get the best performance when running several CPU and disk intensive virtual machines at the same time.
Ubuntu

How To Set Up MySQL Database Replication With SSL Encryption On Ubuntu 9.10

Post date: February 9, 2010, 01:02 Category: Installing Views: 2727 Comments
Tutorial quote: This tutorial describes how to set up database replication in MySQL using an SSL connection for encryption (to make it impossible for hackers to sniff out passwords and data transferred between the master and slave). 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.
CentOS

How To Set Up MySQL Database Replication With SSL Encryption On CentOS 5.4

Post date: February 18, 2010, 13:02 Category: Miscellaneous Views: 4536 Comments
Tutorial quote: This tutorial describes how to set up database replication in MySQL using an SSL connection for encryption (to make it impossible for hackers to sniff out passwords and data transferred between the master and slave). 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.
Gentoo

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

Post date: June 5, 2005, 22:06 Category: Network Views: 5643 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: 3195 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: 2615 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