… memcached needs repeatability to be helpful.  I am still getting a really solid # of hits in memcached, but the # of writes… the vital stats for the game, be updated and stuffed back into the database. You would be surprised how many people…. Remember memcached needs repeatability to be helpful. I am still getting a really solid # of hits in memcached, but the # of writes in…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
… form of caching, ie memcache you end up reducing number of reads from database dramatically but writes still have to happen at… can’t easily tell it to perform certain action (ie write back to the database) when object is removed from the cache… efficiently pushing few updates back to MySQL server. If you rather use existing solutions you can use memcache + another mysql instance (or…
Post: Tokyo Tyrant -The Extras Part III : Write Bottleneck
November 12, 2009 By 3 Comments
… Can have only a single writer thread, bottlenecking performance When writing an application using Tokyo Cabinet only one connection can be… from multiple applications but it still single threads them when writing out to disk.  If you run several threads… idea about using the memcached client to distribute the data accross multiple TC database files in the back end. This should…
Post: Active Cache for MySQL
January 10, 2010 By 11 Comments
… means it only stores cached data. This means application using Memcache has to has to special logic to handle misses from…. Finally I think Active Cache could be very helpful handling write back scenarios. There are many cases when there is a lot…
Comment: State of MySQL Market and will Replication live ?
April 10, 2008 By 29 Comments
… would be awesome if there were something like memcached, only write-through rather than write-back. I will have to keep tabs on your… what average users wanted or thought. You had your CEO writing code and making decisions like “users won’t care if…
Comment: Should you move from MyISAM to Innodb ?
February 1, 2010 By 53 Comments
… issue. All DBs are fronted by memcached machines (64 instances). All applications are written to use memcache before hitting DB. We use RAID0 with multiple disks on all SLAVES. MASTER machines use RAID5. Ratio of reads-to-writes… of the slaves before switching it back to MASTER. Slaves are simply rebuilt and added back to the mix when their SYNC…
Comment: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 16, 2009 By 16 Comments
… identical #’s to the 2 million set. The point about memcached not always fixing issues, is you need to understand your… list at random, then doing something with them before stuffing back into a list. But I have worked on others a… into the system. Also you can use the memcached API to access and write to tyrant which allows you to distribute your…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
…and it would be great if we could write these as plugins instead of patches. 2. … anyway read stale data from the slave or memcached manually relaxing data consistence requirements. But honestly … Enterprise market and develop enterprise features pushing back a lot of features which Web users would…
Comment: Active Cache for MySQL
January 12, 2010 By 11 Comments
…’m sure, but it works great for us. Back to the original topic, I think that being… you’re supremely confident in your ability to write caching software at the database level. The hard… – retaining application control, and proximity to the data. – Memcached sits on the application side of the fence. -…
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
… and how complex replication topologies with multiple tiers filtering and writes to some intermediary slaves people use. For me simple is… using memcache or other caching option. Successful memcache implementations often report 90% cache hit ratio meaning 10 to 1 read ratio drop backs…
