I currently setting up a master slave configuration with MySQL where I
will have 1 master for reads/writes and a slave for reads. Just looking
around, I see the Masochism plugin was written for this. Has anyone
used this and does it work well in a production environment with high
traffic? Are there any better solutions? Thanks!
I haven't used that one, but we used another one (mysql_replication_adapter I think it was). That one worked well. Where we used that one I heard they switched over to this one and love it. The site is huge too so meets your criteria.