r/w splitting -- PHP Application
Hello and first of all, thanx for your tool, it is greaaaaaat!
I'd like to be sure that I can do what I want to do with replication & MySQL-Proxy & your LUA script. Here is my conf :
3 servers :
1 MASTER MySQL 192.168.1.1 with mysql-proxy installed here
1 SLAVE MySQL 192.168.1.2
1 SLAVE MySQL 192.168.1.3
I would like my php application to connect on 192.168.1.1:4040 and that the SELECT queries are balanced on the two slaves (if one is down it keeps running on the other..) and the others queries (UPDATE, INSERT, DELETE...) sent on the master server.
Is it possible with LUA script & MySQL-Proxy?
Thanx by advance for your answer
LM
Edited 2 time(s). Last edit at 08/21/2007 01:53PM by Edwin DeSouza.
Subject
Views
Written By
Posted
r/w splitting -- PHP Application
3787
August 21, 2007 07:19AM
2320
August 21, 2007 03:40PM
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.