MySQL Forums
Forum List  »  Replication

Re: Differentiate between Read/Write
Posted by: Partha Dutta
Date: September 26, 2005 10:19AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
2542
September 16, 2005 11:58PM
Re: Differentiate between Read/Write
1919
September 26, 2005 10:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.