Problem with rw-splitting

[Lykana Jardon]

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.