>- see footer for list info -< 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 -< _______________________________________________ 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 -<
