Re: Postfix med MySQL backend

From: Anders D. Hansen (none@anders--dyekjaer.dk.lh.bsd-dk.dk)
Date: Tue 24 Oct 2006 - 10:45:24 CEST 

From: "Anders D. Hansen" <none@anders--dyekjaer.dk.lh.bsd-dk.dk>
Subject: Re: Postfix med MySQL backend
Date: Tue, 24 Oct 2006 10:45:24 +0200
To: bsd-dk@bsd-dk.dk

On Oct 24, 2006, at 10:37 , Allan Wermuth wrote:

> Ja, det ville være en brugbar løsning, hvis det kun drejede sig om
> én data-
> baseserver, men jeg ønsker at angive 2 databaseservere, hvor det så
> er til-
> fældigt hvilken af de 2 dbservere der bliver spurgt.
>
> De 2 databaseservere kører i et såkaldt master-master setup, hvor data
> replikeres mellem dem. På den måde har vi redundans i vores backend
> DB.

Skulle være muligt.... F.eks.:

----------
# Database server
hosts = postfixaliasdb1, postfixaliasdb2

# The user name and password to log into the mysql server.
user = <username>
password = <password>

# The database name on the servers.
dbname = <dbname>

# See mysql_table(5) for details.
query = SELECT access FROM domain WHERE domain='%s'

----------

Quote:
               The hosts are tried in random order, with all
connections over
               UNIX domain sockets being tried before those over
TCP. The con-
               nections are automatically closed after being idle
for about 1
               minute, and are re-opened as necessary. Postfix
versions 2.0 and
               earlier do not randomize the host order.

~Anders

This archive was generated by hypermail 2b30 : Wed 15 Nov 2006 - 18:25:05 CET