Loading ...
Sorry, an error occurred while loading the content.

291824Re: Transport maps in MySQL

Expand Messages
  • Alfredo Saldanha
    Mar 7, 2013
      In line...

      De: "Noel Jones" <njones@...>
      Para: postfix-users@...
      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.


      >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

    • Show all 7 messages in this topic