Excerpts from wietse's message of Mon Nov 09 17:06:11 -0500 2009: > Micah Anderson: > > I would like to reduce the mysql transport retry time (or perhaps the > > proxymap retry time?), is there a variable that I can tweak down to > > reduce the time between retries of mysql transport connection losses? > > Connections to database servers should not be lost routinely.
Agreed, however it seems I'm hitting a kernel oops which is causing a more frequent crash, resulting in a cluster fail-over, than I would like. > > > Oct 27 13:24:37 mx1 postfix/proxymap[14768]: warning: mysql query failed: > > Lost connection to MySQL server during query > > Oct 27 13:24:37 mx1 postfix/trivial-rewrite[11124]: fatal: > > proxy:mysql:/etc/postfix/maps/mysql_aliases.cf(0,lock|fold_fix): table > > lookup problem > > If anything should retry the query, then it would be the mysql > client. The proxymap can't make such decisions (for example, it > makes no sense to retry after a read error from a local file). > > And in fact, the mysql client does implement retry logic. It retries > if you have more than one mysql server configured. Perhaps you > can specify the same server multiple times. Interesting idea. Do you mean specify it twice in the main.cf configuration such as: alias_maps = mysql:/etc/postfix/mysql_aliases.cf, mysql:/etc/postfix/mysql_aliases.cf transport_maps = proxy:mysql:/etc/postfix/mysql_transport.cf, proxy:mysql:/etc/postfix/mysql_transport.cf Or do you mean two times in the host field in those files, such as the following in the mysql_transport.cf: hosts = mysql-cluster1 mysql-cluster1 dbname = postfix user = postfix password = yeahrightidsendthis query = SELECT storage_ip FROM mailboxes WHERE address = '%s' result_format = smtp:[%s] I am guessing the latter method is the one to use? thanks, micah
