mysql-proxy-discuss team mailing list archive

[Brian Zammit <brianjzammit@xxxxxxxxx>]

Hello,

I'm a 0.6.1 refugee thats looking to the updated 0.7 code (in the new repo
;) to allow this config to function.

Setup is two write servers in a multi-master setup, each with two read-only
slaves. Each master+2slaves are in a separate physical location. Read-writes
need to be split, with write failover between the write masters. Load
balancing of reads to one group of read slaves, with fail over of reads to
the other group of read slaves.

Its not clear to me what code in the pre 0.7 scripts should be
functional/fixed and what may not work now.

Are there updated working examples of pre 0.7 code scripts that are working
in the current branch? eg. Server failover as found at
http://www.pythian.com/news/896/simple-mysql-proxy-failover, and read-write
splitting like http://www.infoq.com/news/2007/10/mysqlproxyrwsplitting based
on Jan's notes at
http://jan.kneschke.de/2007/8/1/mysql-proxy-learns-r-w-splitting?


Brian