MySQL Forums
Forum List  »  Router & Proxy

r/w splitting -- PHP Application
Posted by: Loulou Reykjavik
Date: August 21, 2007 07:19AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
r/w splitting -- PHP Application
3697
August 21, 2007 07:19AM
2277
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.