MySQL Forums
Forum List  »  Router & Proxy

Re: R/W splitting
Posted by: Gerry Reno
Date: July 31, 2007 09:10PM

Jan,
I think I am seeing some writes on my readonly connection because I'm seeing errors like this:
Database error: Invalid SQL: UPDATE ...
mysql Error: 1290 (The MySQL server is running with the --read-only option so it cannot execute this statement)

I actually forced the slave into read only mode so they would error if they received a write request.

Here is the line I used to launch mysql-proxy:
mysql-proxy --proxy-backend-addresses=192.168.1.245:3306 \
--proxy-read-only-backend-addresses=192.168.1.246:3306


Gerry

Options: ReplyQuote


Subject
Views
Written By
Posted
5819
July 30, 2007 04:54PM
2823
July 31, 2007 02:19PM
Re: R/W splitting
3178
July 31, 2007 09:10PM
2872
July 31, 2007 09:26PM
2959
July 31, 2007 10:03PM
2698
July 31, 2007 09:32PM
2660
July 31, 2007 10:11PM
3025
July 31, 2007 10:38PM
3186
July 31, 2007 11:04PM
2943
August 01, 2007 01:11AM
3179
August 01, 2007 09:05AM
2959
August 01, 2007 09:34AM
2734
August 01, 2007 09:45AM
2959
August 01, 2007 10:06AM
3007
August 01, 2007 10:16AM
2967
August 01, 2007 10:16AM
2883
August 02, 2007 01:05AM


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.