MySQL Forums
Forum List  »  Router & Proxy

read-only and normal backends . what's the default behaviour?
Posted by: Amr Hamdy
Date: August 26, 2007 04:03PM

Hello, I really appreciate your work a lot .. I'm very new to this project and have 2 simple question ..

1- How does mysql-proxy behave when I start it like this,

mysql-proxy --proxy-backend-addresses=10.0.45.3:3306 --proxy-read-only-backend-addresses=10.0.45.4:3306

with NO lua scripts .. no special configuration of any type .. ?
Does it do a load balancing? which type of load balancing if any?
Does it redirect all read-only connections to the read-only backend and all write connections to the normal backend?
Does it redirect all write connections to the normal backend and load balances the read-only connections between both?


2-Does the users authenticate against the proxy or the backends?
Does the proxy support any kind of authentication itself?

Thanks really a lot for your efforts :)

Options: ReplyQuote




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.