Re: [Sqlrelay-discussion] reads from one database and writes to another.

[David M. <dav...@fi...>]

The code that's in CVS right now has this feature.  I've been working
hard to get it released, but I've been pretty busy taking care of
customer requests lately so it's been slow-going.  You could try the CVS
version though.  Make sure you check out the CVS version of rudiments as
well.  The feature is described as "query routing and filtering" in the
docs.  There are some limitations and they are discussed in the docs as
well, but it works in general.

David Muse
dav...@fi...

On Thu, 2006-10-26 at 00:40 -0700, elijah wrote:
> I see in the TODO that the feature 'reads from slave and writes to
> master' is under consideration for the future.
> 
> For what it is worth, I think this feature would be amazingly useful.
> Particularly in the case of mysql, a cluster has many drawbacks and it
> is often impractical or impossible to change an application to support a
> master/slave replication setup. This feature in sqlrelay would make it
> much easier to use a replicated database setup with existing open source
> applications.
> 
> Since I have started looking for something which could do this I have
> found dozens of posts from people asking the same question: can I send
> reads to one database and writes to another? The answer people give is
> always that you must rewrite your application to do this manually. It
> would be nice if sqlrelay could be the answer.
> 
> -elijah
> 
> 
> 
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>