[Dovecot] IMAP/POP3 Proxy Redundancy

[Cory]

  Looking over the list archives and Wiki there doesn't seem to be any 
sort of built-in host redundancy with the proxy.  I would prefer to use 
a built in though it doesn't look like this is possible.

One of the suggestions that I found in the list archives was to write a 
script which checks the health of the hosts and adjusts the MySQL table 
accordingly.   Has anyone done anything like this in production?


Thanks,

Cory



Here is a sample of what I'm testing the proxy with.

CREATE TABLE `users` (
   `user` varchar(255) NOT NULL,
   `filesystem` varchar(5) NOT NULL,
   PRIMARY KEY  (`user`),
   UNIQUE KEY `idx_user` (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

CREATE TABLE `hostmap` (
   `id` int(11) NOT NULL auto_increment,
   `filesystem` varchar(5) NOT NULL COMMENT 'Filesystem identifier',
   `ip` int(10) unsigned NOT NULL,
   `alive` tinyint(1) NOT NULL default '1',
   PRIMARY KEY  (`id`),
   UNIQUE KEY `idx_hostmap` (`filesystem`,`ip`)
) ENGINE=MyISAM AUTO_INCREMENT=103 DEFAULT CHARSET=latin1

password_query = SELECT  user,NULL as password, INET_NTOA(hostmap.ip) as 
host, 'Y' AS proxy_maybe from users left join hostmap on 
users.filesystem=hostmap.filesystem where hostmap.alive=1 and 
users.user='%u' limit 1;