leowong8888 wrote:
> Dear Friends,
>
> I have a Master / Slave setup, and would like to
> put Write/Read operations to the Master and Read
> operations to the Slave.
>
> I would like to know if there are any
> opensource/commercial software out there that can
> intercept at 3306 port and differentiate between
> Read/Write and then redirect to the correct mySQL.
> Or, if i write something like that, would it be
> possible?
>
> I know a clustering solution is most likely to
> suit my need, but i've tried NDB, as well as EMIC.
> Both didn't work for me in my environment.
>
> Please help.
>
> thanks
> Leo
I haven't heard of one, but it might be an interesting project. You can have a 'hacked up' solution though, using the heartbeat form the Linux-HA project. If you have 2 IP addresses bound to a NIC, you can use one of them as "read" and one of them as "write". If a machine fails, the IP address can 'travel' to the other machine, and vice versa. I don't have any implementation details as of yet, but I think it could be doable.
- Partha
Partha Dutta
Senior Consultant, MySQL Inc.
http://www.mysql.com