Re: [Sqlrelay-discussion] reads from one database and writes to another.
Brought to you by:
mused
|
From: David M. <dav...@fi...> - 2006-10-26 20:06:13
|
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 > |