Am 07.03.2013 21:01, schrieb Noel Jones: > 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
it is not a problem if you have TWO mysqld-hosts with replication because all of this lookups are read-only and you can easily configure postfix to use both servers hosts = unix:/var/lib/mysql/mysql.sock inet:ip-of-mysql-slave
signature.asc
Description: OpenPGP digital signature
