Hi all -
I'm looking for a way to have a group of mysql servers that are all slaves
to a single master. That part I can do.
However, what I'd like is a way to put another server in front of the
entire cluster and have that pretend to be the mysql database, except that
it would simply redirect all update/insert/deletes to the master and all
selects to one of the slaves (randomly or weighted or whatever).
There's an app for postgres called pgpool that does this, but I haven't
found anything for mysql yet.
http://pgpool.projects.postgresql.org/
I'd rather not get into multi-master if I can help it and I don't think I
need it. And I don't want to get into ndb cluster either... Yes, I'm
picky :-)
It's also not as simple as changing my front end as we're using Rails and
from what I can tell Rails can't do this unless I break up all my models
into ReadModel and WriteModel which defeats the whole purpose.
Any ideas?
Thanks!
-philip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
