I tested MySQL proxy last year, and the delay inserted because of the proxying was huge. DBMail has a lot of queries just to do simple things (a lot of IMAP compliance) and it just slows it way down. I think logging into a mailbox with a user will very little email in the INBOX went from 0.5 seconds to 5.0 seconds. This was on a 100 Mbit/sec LAN with 2 DB servers, and dbmail with the proxy on a 3rd server. I have not tested the newer proxy code, but I doubt that it has improved so much that it would be a viable solution for most end users expectations of how fast their server should give them their mail.
-Jon ITronic Harald Leithner wrote: > Has anyone thought about using mysql proxy to split "select" and > "manipulation" querys to 2 Servers? > > I used MySQL Proxy just for testing and a sms script, but I think it > should be possible to use LUA to > split the queries to do a simple load balancing. If you like I can try to > write such a script for you. > > > > Am 19.05.2010, 04:15 Uhr, schrieb N Sj <[email protected]>: > > >> I've read through the archives and noticed that multimaster replication >> is really discouraged to be used with dbmail, but I'd still like to see >> if I can figure out a way to use my second mysql server to take some >> load off the master server. Please find the scenario below where all >> the pop/imap clients and SMTP from internet will be pointing to >> mysql-server1 and all the webmail clients to mysql-server2. Both >> mysql-server1 and mysql-server2 are configured with multimaster >> replication. >> >> Is it possible to do something like this or will it completely break >> dbmail. >> >> pop/imap ---->mysql-server1 >> webmail ---->mysql-server2 >> >> both mysql1 and mysql2 are configured Master and slave to each other for >> multimaster replication. >> mysql1<=====>mysql2 >> >> Thank you for your feedback. >> >> >> >> >> _______________________________________________ >> DBmail mailing list >> [email protected] >> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail >> > _______________________________________________ > DBmail mailing list > [email protected] > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail > > -- Scanned for viruses and dangerous content by MailScanner _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
