PUBLIC MARKS with tags mysql & linux

cd /usr/lib

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.

This is the MySQL GUI Tools Bundle for 5.0. It includes the following products. * MySQL Administrator 1.2 Generally Available (GA) * MySQL Query Browser 1.2 Generally Available (GA) * MySQL Migration Toolkit 1.1 Generally Available (GA)

This document describes how to integrate ASSP (Anti-Spam SMTP Proxy) with embedded ClamAV into a mail server based on Postfix featuring virtual users and domains, i.e. users and domains that are in a MySQL database.

The Developer Cheat Sheet Compilation

Si comme moi vous avez sous la main un serveur abritant plusieurs (dizaines, voir centaines de) bases de données, le jour où une des bases de données plante et qu'on vous demande de la restaurer, je vous souhaite bien du courage si vous n'avez qu'un résultat de mysqldump --all-databases sous la main. Afin de pallier ce problème, j'ai écris ce script bash qui vous facilitera bien la vie !

the missing piece for installing pdo_mysql on ubuntu (sudo apt-get install libmysqlclient15-dev)

ZRM for MySQL Community Edition is a freely downloadable version of ZRM for MySQL - the leading MySQL backup solution. It has been developed by Zmanda engineers with input from many Database and System Administrators who were looking for an easy-to-use yet enterprise-strength backup and recovery solution for MySQL. We expect to provide frequent updates to ZRM for MySQL, so please check back often.

This tutorial shows how to set up a Debian Etch (Debian 4.0) 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 FTP server, MySQL server, Courier POP3/IMAP, Quota, Firewall, etc. This tutorial is written for the 32-bit version of Debian Etch, but should apply to the 64-bit version with very little modifications as well.

WebLog sur l’informatique générale et plus précisément sur l’OpenSource, le Libre et le développement

sudo apt-get install build-essential

下載下列的程式，再把它一次升級就可以了！ rpm -Uvh *.rpm

Autoresponders to accompany Virtual Users and Domains with Postfix, Courier and MySQL | HowtoForge - Linux Howtos and Tutorials

Fine post about tuning a Linux Apache MySQL PHP (LAMP) Server. From the software approach to the TCP tuning. Many clues about tuning a linux server.

A userguide for mysql v5.0.