MySQL Forums
Forum List  »  Router & Proxy

Re: Selecting backend based on the user connecting
Posted by: Jan Kneschke
Date: August 13, 2007 04:05AM

This is similar to the keepalive tutorial where we show read/write splitting.

The idea is:

* connect_server() builds a pool of connections to all backends and maintains it
* read_query() picks a backend based on the user, query, ...

This assumes that all servers share the same user + passwords.

http://svn.mysql.com/svnpublic/mysql-proxy/trunk/examples/tutorial-keepalive.lua

--
Jan Kneschke, MySQL Enterprise Tools

Options: ReplyQuote




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.