Re: [Dbmail] dbmail and multimaster mysql replication

2010-05-19 Thread ITronic Harald Leithner
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

Re: [Dbmail] {Spam?} Re: dbmail and multimaster mysql replication

2010-05-19 Thread Jonathan Feally
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

Re: [Dbmail] dbmail and multimaster mysql replication

2010-05-19 Thread ITronic Harald Leithner
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

Re: [Dbmail] dbmail and multimaster mysql replication

2010-05-19 Thread tabris
On 05/19/2010 10:19 AM, N Sj wrote: I've asked the DBA to review to see if this would be feasible and I've received the following response, he is speaking based on mysql he is not familiar with dbmail architecture, so I'm asking whether this is true. multi-master would be very difficult to

Re: [Dbmail] dbmail and multimaster mysql replication

2010-05-19 Thread Paul J Stevens
tabris wrote: On 05/19/2010 10:19 AM, N Sj wrote: I've asked the DBA to review to see if this would be feasible and I've received the following response, he is speaking based on mysql he is not familiar with dbmail architecture, so I'm asking whether this is true. multi-master would be