>- see footer for list info -< I'll probably not go for that option, Rich. It is bad enough administering the databases we alsready have; adding another set seems like too much like hard work!
If I can get to work with the memcached (or as suggested, the ehcache used in CF9) at least it will scale well when the database HAS to go back onto its own server...... Cheers Terry (free event listings at http://www.confexdb.co.uk) ----- Original Message ----- > *From:* Rich Wild <[email protected]> > *To:* [email protected], Coldfusion Development > <[email protected]> > *Date:* Thu, 8 Oct 2009 15:27:19 +0100 > > No in the same way that we're suggesting here, but I've used it for > abitrary > datastores here and there. Easy to setup and administer, and I've > found it > plenty fast. > > Rich > > On Thu, Oct 8, 2009 at 3:21 PM, Terry Riley <[email protected]> wrote: > > > >- see footer for list info -< > > Thanks for the suggestion, Rich. It wasn't one I had even thought > > of - > > have you had occasion to use it? > > > > Cheers > > > > Terry > > (free event listings at http://www.confexdb.co.uk) > > > > ----- Original Message ----- > > > > > *From:* Rich Wild <[email protected]> > > > *To:* [email protected], Coldfusion Development > > > <[email protected]> > > > *Date:* Thu, 8 Oct 2009 09:34:00 +0100 > > > > > > Could you use an Apache Derby database as an interstitial > > > datastore, > > > taking > > > weight off your mySQL server? > > > > > > Rich > > > > > > On Thu, Oct 8, 2009 at 9:18 AM, Terry Riley <[email protected]> > > > > wrote: > > > > > > > >- see footer for list info -< > > > > Yes, Russ, I know! We had already done some CF query caching, > > > > but > > > > the > > > > site is fairly data-sensitive and any caching is going to be > > > > short-lived. > > > > ( view http://www.football.mitoo.co.uk and you'll see what I > > > > mean ) > > > > > > > > Using MySQLs cache at least ensured that the data was > > > > up-to-date, > > > > with > > > > MySQL dropping any query from cache related to a changed data > > > > table. > > > > > > > > CFs query cache has no way to detect the changed data, and even > > > > if > > > > you > > > > could tie a data change to a set of particular queries, there's > > > > no > > > > way > > > > in CF to drop that related set of queries from cache (without > > > > running > > > > them all again with a 0 timeout - which seems pointless. > > > > > > > > At least, if I understand it right, with memcached we could > > > > cache a > > > > query (each one having an individual key) and if a related > > > > table is > > > > changed with an SQL update/delete/insert in our code, we can > > > > designate > > > > an immediate dropping of the named/related cached query. That > > > > way > > > > it is > > > > ready to be recreated the next time it is called for. > > > > > > > > One of the main reasons I'd like to try memcached is one you > > > > mentioned - > > > > using memory outside of that generally used for CF, and being > > > > able > > > > to > > > > distribute the cache over 4 or 5 servers. > > > > > > > > I'd still like to find a source of good instructions for a CF > > > > client, > > > > though. In order to cut down on traffic charges (like upwards of > > > > 55GB/day) we have moved the MySQL server back onto the same box > > > > as > > > > the > > > > CF app/servers - with added memory. > > > > > > > > Thanks for the help. > > > > > > > > Cheers > > > > Terry > > > > (free event listings at http://www.confexdb.co.uk) > > > > > > > > ----- Original Message ----- > > > > > > > > > *From:* "snake" <[email protected]> > > > > > *To:* <[email protected]>, "'Coldfusion Development'" > > > > > <[email protected]> > > > > > *Date:* Wed, 7 Oct 2009 21:04:52 +0100 > > > > > > > > > > Not personally but I worked for a client that used it and they > > > > > said > > > > > it was > > > > > great. I believe in their case they were using it to share > > > > > memory > > > > > between > > > > > multiple cf servers. > > > > > just caching your cfqueries would reduce the traffic to your > > > > > mysql > > > > > server, > > > > > so perhaps some application tuning is required. > > > > > > > > > > Russ > > > > > > > > > > -----Original Message----- > > > > > From: [email protected] > > > > > [mailto:[email protected]] On Behalf Of Terry > > > > > Riley > > > > > Sent: 07 October 2009 18:03 > > > > > To: [email protected] > > > > > Subject: [CF-Dev] memcached > > > > > > > > > > >- see footer for list info -< > > > > > Has anyone here implemented memcached on their CF8 server(s)? > > > > > Has > > > > > it > > > > > been worthwhile? What pushed you in that direction? > > > > > > > > > > I'm being pushed by client management to do something to > > > > > alleviate > > > > > the traffic with the MySQL server, by caching on the CF server > > > > > instead of relying on MySQL's query cache. > > > > > > > > > > Only solution I can see is something like memcache, but I > > > > > find the > > > > > information on setup/usage of the Java/CF client (not the > > > > > memcached > > > > > server) very sparse indeed. Are there resources out there > > > > > that I'm > > > > > just not finding? > > > > > > > > > > I understand that CF9 has all sorts of improvements in > > > > > caching, > > > > > but > > > > > we can't afford to go that route. > > > > > > > > > > Cheers > > > > > Terry > > > > > (free event listings at http://www.confexdb.co.uk) > > > > > > > > > > _______________________________________________ > > > > > > > > > > For details on ALL mailing lists and for joining or leaving > > > > > lists, go > > > > > to > > > > > http://list.cfdeveloper.co.uk/mailman/listinfo > > > > > > > > > > -- > > > > > CFDeveloper Sponsors:- > > > > > >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< > > > > > >- Lists hosted by www.Gradwell.com -< > > > > > >- CFdeveloper is run by Russ Michaels, feel free to volunteer > > > > > your > > > > > help -< > > > > > > > > > > No virus found in this incoming message. > > > > > Checked by AVG - www.avg.com > > > > > Version: 8.5.420 / Virus Database: 270.14.5/2418 - Release > > > > > Date: > > > > > 10/06/09 18:34:00 > > > > > > > > > > > > > _______________________________________________ > > > > > > > > For details on ALL mailing lists and for joining or leaving > > > > lists, > > > > go to > > > > http://list.cfdeveloper.co.uk/mailman/listinfo > > > > > > > > -- > > > > CFDeveloper Sponsors:- > > > > >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< > > > > >- Lists hosted by www.Gradwell.com -< > > > > >- CFdeveloper is run by Russ Michaels, feel free to volunteer > > > > your > > > > help -< > > > > > > > > > > No virus found in this incoming message. > > > Checked by AVG - www.avg.com > > > Version: 8.5.421 / Virus Database: 270.14.7/2421 - Release Date: > > > 10/07/09 20:49:00 > > > > > > > > > -- > > > *Included Files:* > > > am2file:001-HTML_Message.html > > > > _______________________________________________ > > > > For details on ALL mailing lists and for joining or leaving lists, > > go to > > http://list.cfdeveloper.co.uk/mailman/listinfo > > > > -- > > CFDeveloper Sponsors:- > > >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< > > >- Lists hosted by www.Gradwell.com -< > > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your > > help -< > > > > No virus found in this incoming message. > Checked by AVG - www.avg.com > Version: 8.5.421 / Virus Database: 270.14.7/2421 - Release Date: > 10/07/09 20:49:00 > > > -- > *Included Files:* > am2file:001-HTML_Message.html _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
