MySQL Forums
Forum List  »  Router & Proxy

Advanced Search
New Topic

Re: R/W splitting. All requests only to write server.
Posted by: Pavel Scherbakov
Date: June 03, 2009 06:03AM

Thank you for answer.
We have updated mysql-proxy to 0.7.1 version and
read-write splitting work.

But now we have the next problem:
when master(write) host was down,
I have got error
ERROR 1105 (HY000): #07000(proxy) all backends are down
on SELECT requests.
I thought that SELECT requests must work in this case, because "read"
servers are up.

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


Subject
Views
Written By
Posted
R/W splitting. All requests only to write server.
5567
Pavel Scherbakov
June 01, 2009 06:15AM
Re: R/W splitting. All requests only to write server.
3214
Diego Medina
June 01, 2009 09:45AM
Re: R/W splitting. All requests only to write server.
4305
Pavel Scherbakov
June 03, 2009 06:03AM
Re: R/W splitting. All requests only to write server.
3184
Diego Medina
June 03, 2009 01:11PM
Re: R/W splitting. All requests only to write server.
2863
Danila Lelaev
July 01, 2009 07:07AM
Re: R/W splitting. All requests only to write server.
2517
Emmanuel Dyan
July 09, 2009 01:11AM
Re: R/W splitting. All requests only to write server.
4573
Diego Medina
July 12, 2009 08:46AM
Re: R/W splitting. All requests only to write server.
2842
Diego Medina
July 12, 2009 07:44PM


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.