Re: mysql transport failover

2009-11-10 Thread Wietse Venema
micah anderson: > > I was talking about DIFFERENT hosts instead of repeating the same > > hostname in the Postfix config file. > > That makes sense. > > However, the mysql_table(5) doesn't specify in the MYSQL PARAMETERS > section that the 'hosts' parameter can take different ports. The The nam

Re: mysql transport failover

2009-11-10 Thread micah anderson
Excerpts from wietse's message of Tue Nov 10 17:22:57 -0500 2009: > micah anderson: > > > > hosts = mysql-cluster1 mysql-cluster1 > > > > > > This repeats the query only if the session breaks. However, the > > > hosts are tried without delay, so this is unlikely to be a solution > > > for ke

Re: mysql transport failover

2009-11-10 Thread Wietse Venema
micah anderson: > > > hosts = mysql-cluster1 mysql-cluster1 > > > > This repeats the query only if the session breaks. However, the > > hosts are tried without delay, so this is unlikely to be a solution > > for kernel panics. > > > > Consider configuring more than one mysql server. > > Ac

Re: mysql transport failover

2009-11-10 Thread micah anderson
Excerpts from wietse's message of Tue Nov 10 15:45:38 -0500 2009: > micah anderson: > > > 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). > > >

Re: mysql transport failover

2009-11-10 Thread Wietse Venema
micah anderson: > > 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 >

Re: mysql transport failover

2009-11-10 Thread micah anderson
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 los

Re: mysql transport failover

2009-11-09 Thread Wietse Venema
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. > Oc

mysql transport failover

2009-11-09 Thread 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? I'm using mysql for transport_maps and virtual_mailbox_maps. transport_maps = proxy:mysql