February 2010
2 posts
Farmville on Web Scaling
This was a pretty good read, How FarmVille Scales to Harvest 75 Million Players a Month. The lessons learned are worth generalizing:
Interactive apps are write-heavy.
Design every component as a degradable service, and provide a mechanism to degrade services server-side during peak demand.
Cache incoming data - they cache everything coming in from Facebook
Usage spikes during new releases of...
De-columnize Regex
\s+\|\s*\n\|
This regular expression matches the pipes and spaces in mysql output like:
| $dq$$form |
| $dq$$module |
| $dq$$place |
| $dq$$site |
| $dq$$thing |
Sometimes it’s handy to extract just the values from a pasted query result.