PUBLIC MARKS from falko with tag mysql

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. The resulting Postfix server is capable of SMTP-AUTH and TLS and quota. In addition to that, this tutorial covers the installation of Amavisd, SpamAssassin and ClamAV so that emails will be scanned for spam and viruses.

This article shows how to set up a Postfix virtual mailserver with Courier-IMAP, Maildrop and the PostfixAdmin web interface. We will secure our mailserver with Mailscanner and ClamAV as anti-virus and SpamAssassin as anti-spam. The setup is based on CentOS 4.4.

With BixData you can monitor your servers as well as VMware and Xen. BixData includes pre-built plugins for things like CPU, Memory, Disk, etc. but any good monitoring tool needs to be customizable. BixData includes the basic ability to run scripts and record their exit values, similar to Nagios Plugins. BixData 2.7 adds support for importing data in more complex formats. This allows you to monitor almost anything. I'll go through the steps showing you how to monitor MySQL locally where an agent is installed and then the steps to monitor a device remotely through SNMP. The advantage of BixData is that any data available through a BixAgent works with the standard tools such as the situation room, scoreboards, notifications and the reporting system. All data are stored in standard SQL tables and are easily accessible.

This article shows how to set up your own news-voting website with Pligg. Pligg is a content-management system published under the Affero General Public License, and it is written in PHP and uses a MySQL database for storing its data. With a little work you can create your own community and let users vote news to the front page.

This is a description of how to set up a secure tunnel between your MySQL Server and a locally running MySQL Administrator using Putty. By creating a secure tunnel to your MySQL server using Putty, you can grant localhost access to powerful applications like MySQL Administrator while at the same time, make your server appear as if it isn't even there. In effect, make your MySQL server disappear from the outside world.

This is a detailed description about how to set up an OpenSuSE 10.2 based server that offers all services needed by ISPs and hosters (Apache web server (SSL-capable), Postfix mail server (with SMTP-AUTH and TLS), BIND DNS server, ProFTPd server, MySQL server, Courier POP3/IMAP, Quota, Firewall, etc.).

This is a detailed description about how to set up a Ubuntu 6.10 (Edgy Eft) based server that offers all services needed by ISPs and hosters: Apache web server (SSL-capable), Postfix mail server with SMTP-AUTH and TLS, DNS server, FTP server, MySQL server, POP3/IMAP, Quota, Firewall, etc.

This tutorial describes how to set up MySQL master-master replication. We need to replicate MySQL servers to achieve high-availability (HA). In my case I need two masters that are synchronized with each other so that if one of them drops down, other could take over and no data is lost. Similarly when the first one goes up again, it will still be used as slave for the live one.

This guide describes how to back up and recover your MySQL databases with mysql-zrm on a Debian Sarge system. mysql-zrm is short for Zmanda Recovery Manager for MySQL, it is a new tool that lets you create full logical or raw backups of your databases (regardless of your storage engine and MySQL configuration), generate reports about the backups, verify the integrity of the backups, and recover your databases. It can also send email notifcations about the backup status, and you can implement multiple backup policies (based on your applications and based on time (e.g. daily, weekly, etc.)).

This document describes how to install a mail server with Postfix 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.

This is a detailed description about how to set up a SuSE 10.1 based server that offers all services needed by ISPs and hosters (Apache web server, Postfix mail server (with SMTP-AUTH and TLS!), DNS server, FTP server, MySQL server, POP3/IMAP, Quota, Firewall, etc.).

This tutorial shows how to configure a MySQL 5 cluster with three nodes: two storage nodes and one management node. This cluster is load-balanced by a high-availability load balancer that in fact has two nodes that use the Ultra Monkey package which provides heartbeat (for checking if the other node is still alive) and ldirectord (to split up the requests to the nodes of the MySQL cluster).

DSPAM is a scalable and open-source content-based spam filter designed for multi-user enterprise systems. It is great at filtering out spam but on busy mailservers the pruning of the MySQL databases takes way too much time.<br><br>The default purge-4.1.sql script provided with DSPAM can be heavily optimized by adding indexes to the database and using the indexes properly when pruning.<br><br><a href=http://www.howtoforge.com/optimizing_dspam_mysql4.1 target=_blank>http://www.howtoforge.com/optimizing_dspam_mysql4.1</a>

This is a detailed description how to set up a Fedora Core 5 based server that offers all services needed by ISPs and hosters (Apache web server (SSL-capable), Postfix mail server (with SMTP-AUTH and TLS), DNS server, FTP server, MySQL server, POP3/IMAP, Quota, Firewall, etc.). This tutorial is written for the 64-bit version of Fedora Core 5, but should apply to the 32-bit version with very little modifications as well.