>- see footer for list info -< All good suggestions, Russ, and to be honest I'm not 100% of what the setup with the rest of the organisation is. The MySQL we initially had on the same box as CF was moved to a dedicated db server, with other databases used by other parts of the group. For whatever reason, charges for bandwidth are high.... but the other parts use PHP and their implementation of memcached managed to reduce *their* part of the bandwidth considerably. Hence my interest in it for when we undoubtedly will have to move the MySQL back to its own box. Bloody clients!
But if they will make decisions without asking the ones who have used the system from the start, they'll have to pay for their errors..... I'll still try the memcached or ehcache options for scalability reasons in the future. So has anyone used ehcache (outside of CF9) ? 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:* Thu, 8 Oct 2009 15:54:14 +0100 > > It seems the only goal of this is reducing the bandwidth costs, there > is in > that case an easier solution than trying to code round it. > 1) Either they have their own db server, in which case they can > connect it > directly to the web server via local LAN (presuming the server has 2 > nics), > then there is no bandwidth going anywhere else except directly > between the 2 > servers, so there will be nothing for rackspace to monitor or charge > for. > 2)Or perhaps they are paying for a database on a shared server and > thus why > the bandwidth charges, in which case the solution would be obvious. > Get > their own dedicated db server which would be a lot cheaper than they > are > paying for bandwidth. Or go find another host who offers mysql > hosting for a > set monthly fee and get a database from them instead. > > 3)Running the db on the web server is of course not a great idea if > the db > is high traffic as it will affect performance, however it is possible > to get > away with this if the server is setup to cope with it. All you really > need > to do is install the databases, indexes etc onto a separate physical > hard > disk, as disk IOPS is the primary bottle neck in a single server > setup, this > will make a big difference and the cost of an extra disk should be > minimal. > If the server has multiple cpu's/core then the load can also be split > so > that MySQL gets 1 core and CF gets another for example. > > HTH > Russ > > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Terry Riley > Sent: 08 October 2009 15:21 > To: [email protected] > Subject: RE: [CF-Dev] memcached > > >- see footer for list info -< > No, not me - the client got into some crazy deal with R***Sp*** where > they have ended up with about a $500 monthly traffic bill! Hence the > move of the db server back to the CF server. As they (or their > alleged expert contractors) don't tend to ask my opinion on such > things....... > > I've got something working on a test rig, but in order to get it to > work with some degree of good application coverage, I'm going to have > to figure how to manage the same query with different params as > individual objects, which means.... lots of work for me! > > Cheers > Terry > (free event listings at http://www.confexdb.co.uk) > > ----- Original Message ----- > > > *From:* "snake" <[email protected]> > > *To:* "'Coldfusion Development'" <[email protected]> > > *Date:* Thu, 8 Oct 2009 13:49:59 +0100 > > > > >- see footer for list info -< > > You are being charged for traffic between the database and web > > server? If so > > then then they are ripping you off as you should not be charged for > > that and > > I have never heard of any host charging for traffic between hosted > > servers. > > > > Have u seen this. > > http://memcached.riaforge.org/ > > > > Russ > > -----Original Message----- > > From: [email protected] > > [mailto:[email protected]] On Behalf Of Terry Riley > > Sent: 08 October 2009 09:18 > > To: [email protected] > > Subject: RE: [CF-Dev] memcached > > > > >- 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 -< > > > > > > > > _______________________________________________ > > > > 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 > > > > _______________________________________________ > > 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 > _______________________________________________ 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 -<
