We use a load balanced pair of mail servers, mounting a shared mail spool off a NetApp filer. Currently we are using cdb but are converting to MySQL. In the interest of improved redundancy and speed, we wanted to use MySQL replication to distribute requests/updates across three servers, the master server on a third box and local slave servers on each mail server. In order to accomplish this, I made some minor modifications to vmysql.c and vmysql.h to allow selects to be sent to the local MySQL servers (most of the traffic) and updates to be sent to the master server. In theory, talking to the local MySQL server via a unix domain socket should be much faster than establishing a tcp connection to a remote server. Plus each mail server can run without the other mail server or the master database server for extended periods of time. Anywho, I have created a patch against vmysql.c. If anyone is interested, please contact me off-list. Ken, since this is going to become a permanent part of our infrastructure it would be quite awesome if it could be integrated into the main distribution. If you would like to see the patch, give me a shout. Thanks, Ben -- Ben Beuchler There is no spoon. [EMAIL PROTECTED] -- The Matrix
