291825Re: Transport maps in MySQL
- Mar 7, 2013DO NOT POST HTML-MESSAGES
Am 07.03.2013 21:17, schrieb Alfredo Saldanha:
> In line...in short: if you use mysql for your config your mysqld MUST NOT
> On 3/7/2013 1:37 PM, Alfredo Saldanha wrote:
>>> Hi people,
>>> Simple question:
>>> Is safe use mysql to get the transport maps information? if the
>>> connection with database drops ? is there cache?
>> The transport table is a critical table used by pretty much every
>>part of postfix (by way of the trivial_rewrite service). If the
>>mysql database is unavailable, no mail will flow. If the lookups
>>are slow, all postfix performance will suffer.
> In case of mysql connection drop, Postfix doesn't use the last transport information ?
> And another stuffs that use MySQL, like virtual aliases, users, etc. the message will be rejected ?
>>While it is certainly possible to successfully use mysql with
>>transport, it will require some care and feeding -- especially for a
>>Transport tables don't usually change frequently, and it's better to
>>keep that information in a local hash: or cdb: table for both
>>performance and availability. If you want to keep everything in
>>mysql, consider creating a process to periodically dump the data to
>>a local hash: or cdb: table.
be unreachable, ever at all, if your setup is OK this will never
happen - i am saying this after 5 years dbmail where ANYTHING
is in a innodb-database, not only postfix-config
never ever shutdown mysql alone, make sure you always stop any
mail-service before, make sure any mailservice is stopped before
mysqld at reboot/shutdown, make sure your mysqld is high available
with replication and you are fine
- << Previous post in topic Next post in topic >>