Sharding, and all that
nigel at turbo10.com
Fri Dec 19 06:34:07 GMT 2008
> It's nearly the new year and the time for new projects. On my project
> radar for next year is "consider (better) sharding our MySQL database."
I think it depends on your write/read ratio. If it is read heavy then
replication and/or memcache will probably do the trick - on the other hand
if you expect more writes than reads then I saw an interesting technique for
handling excess DB writes by using thousands of temporary MySQL MyISAM
Writing to MyISAM files is quick - but the downside is locking - by using
_lots_ of temporary MyISAM tables you can improve overall write capacity.
 These guys used 20,000+ MyISAM tables to scale writes
More information about the london.pm