Ok good to know so I don't have to test it for my self... Harald
Am 19.05.2010, 17:15 Uhr, schrieb Jonathan Feally <vult...@netvulture.com>: > 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 <namai...@yahoo.com>: >> >> >>> 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 >>> DBmail@dbmail.org >>> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail >>> >> _______________________________________________ >> DBmail mailing list >> DBmail@dbmail.org >> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail >> >> > _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
