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;