Am 10.02.2011 12:12, schrieb Robert Schetterer:
> Hi in
>
> http://www.postfix.org/MYSQL_README.html
>
> we've included the ability to have Postfix reference multiple hosts for
> access to a single mysql map. This will work if sites set up mirrored
> mysql databases on two or more hosts. Whenever queries fail with an
> error at one host, the rest of the hosts will be tried in random order.
> If no mysql server hosts are reachable, then mail will be deferred until
> at least one of those hosts is reachable.
>
> i have i.e
>
> relay_recipient_maps = mysql:/etc/postfix/relay_recipients_mysql.cf
>
>
> user =
> password =
> hosts = 1
> dbname = postfix
> query = SELECT address FROM alias WHERE address like '%u\@%d' AND active = 1
>
> so how use fallback on second host
>
> simple like this ?
>
> relay_recipient_maps = mysql:/etc/postfix/relay_recipients_mysql.cf,
> mysql:/etc/postfix/relay_recipients_mysql_2.cf
>
>
> with mysql:/etc/postfix/relay_recipients_mysql_2.cf
>
> user =
> password =
> hosts = 2
> dbname = postfix
> query = SELECT address FROM alias WHERE address like '%u\@%d' AND active = 1
>
> ?
>
sorry its in the man page
MYSQL PARAMETERS
hosts The hosts that Postfix will try to connect to and query
from. Specify unix: for UNIX domain sockets, inet: for TCP
connections (default).
Example:
hosts = host1.some.domain host2.some.domain
hosts = unix:/file/name
--
Best Regards
MfG Robert Schetterer
Germany/Munich/Bavaria
