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;