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. While it is certainly possible to successfully use mysql with transport, it will require some care and feeding -- especially for a high-volume server. 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. -- Noel Jones
