In line... De: "Noel Jones" <[email protected]> Para: [email protected] Enviadas: Quinta-feira, 7 de Março de 2013 17:01:45 Assunto: Re: Transport maps in MySQL
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? >> >> BR, >> >> Junix >> > 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 >high-volume server. OK. >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. Thank you Noel. -- Noel Jones
