MySQL Forums
Forum List  »  Router & Proxy

Advanced Search
New Topic

Re: Load balancing issues on a Master/Master architecture
Posted by: Diego Medina
Date: July 24, 2009 12:14PM

Kin,

>
> Can you explain to me the behaviour of the rw
> script ?

The idea is that all write statements go to the master, and read statements go to the slave. Of course, there are all kinds of cases where this does not happen.

>
> All the requests goes to the master till it is too
> charged right ?

Kind of, but it is not so 100% like that.

Try this: don't use proxy-read-only-backend-addresses, and just use proxy-backend-addresses

(just as a test, it may work or it may bring up all kinds of issues.)

Thanks

--
Diego Medina, QA Engineer
Enterprise Tools - Database Group, Sun Microsystems

Are you MySQL certified? http://www.mysql.com/certification

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Load balancing issues on a Master/Master architecture
6230
Kin JOY
July 17, 2009 08:51AM
Re: Load balancing issues on a Master/Master architecture
2770
Diego Medina
July 17, 2009 08:30PM
Re: Load balancing issues on a Master/Master architecture
4707
Kin JOY
July 20, 2009 04:08AM
Re: Load balancing issues on a Master/Master architecture
2796
Diego Medina
July 24, 2009 12:14PM
Re: Load balancing issues on a Master/Master architecture
3927
Kin JOY
July 20, 2009 08:31AM
Re: Load balancing issues on a Master/Master architecture
2809
Edwin DeSouza
July 20, 2009 01:41PM
Re: Load balancing issues on a Master/Master architecture
2636
Diego Medina
July 20, 2009 02:03PM
Re: Load balancing issues on a Master/Master architecture
2742
Kin JOY
July 21, 2009 02:30AM


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.