Problem with rw-splitting
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.
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.