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
