MySQL Forums
Forum List  »  Router & Proxy

Problem with rw-splitting
Posted by: Lykana Jardon
Date: October 31, 2007 08:26AM

Our proxy-system consists of: 1 MySQL-Proxy, 1 Master, 3 Slaves


We start the proxy (whithout space characters or linebrakes) with:
#mysql-proxy
--proxy-backend-addresses=***.***.***.*1:****
--proxy-read-only-backend-addresses=***.***.***.*2:****
--proxy-read-only-backend-addresses=***.***.***.*3:****
--proxy-read-only-backend-addresses=***.***.***.*4:****
--proxy-lua-script=/PATH/mysql-proxy/rw-splitting.lua
--daemon
--pid-file=/pidFile.pid


All databases on master and slave servers are identic, the synchronisation works correctly.



Mostly we get the follwoing errors (on the websites):

SELECT Statement
----------------

Anfrage: SELECT COUNT(*) AS strike, MAX(time) AS lasttime FROM strikes WHERE ip = '**.***.**.10'
MySQL meldet: can't change DB forum to on slave ***.***.***.*2:****

Anfrage: SELECT COUNT(*) AS strike FROM strikes WHERE ip = '**.***.**.10' AND username = 'username'
MySQL meldet: can't change DB forum to on slave ***.***.***.*3:****


the same error occures with:

INSERT Statement
----------------

Anfrage: INSERT INTO strikes (time, ip, username) VALUES (1193123553, '**.***.**.10', 'username')
MySQL meldet: can't change DB forum to on slave ***.***.***.*3:**** Anmeldung fehlgeschlagen! Benutzername und Passwort stimmen nicht überein!



The console output writes (e.g.):

server default db: database1
client default db: database2
syncronizing

We think, both databases should be the same and that's probably why we get these errors.

Options: ReplyQuote


Subject
Views
Written By
Posted
Problem with rw-splitting
4005
October 31, 2007 08:26AM
3333
November 02, 2007 03:07AM
2803
November 08, 2007 07:56AM
2586
November 10, 2007 03:59AM


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.