Tag Archives: scale

pmysql (multi-server mysql client)

Posted on 2010/08/12 by

To have more visibility of our systems I needed a method to quickly query large sets of MySQL servers. Though there are few methods like ‘xargs -P’ and dsh, they are overkill for the SQL-only job, and simply not fast … Continue reading →

Posted in facebook, mysql | Tagged , , | 21 Comments

to shard or not to shard

Posted on 2009/01/07 by

Though it involved DHH and Jeremy Zawodny writing walls of text about the topic, I could sum it up in two simple rules: If you have to shard, you have to shard. If you do not have to shard, you … Continue reading →

Posted in mysql | Tagged , , | 4 Comments

TCP tuning for your database

Posted on 2006/09/12 by

Lately lots of new fascinating technologies are used to build even more fascinating new solutions, and solutions nowadays even run on distributed environments, not just on single server. These servers usually communicate using TCP – standard, that has been here … Continue reading →

Posted in mysql | Tagged , , , | 1 Comment

Scaling talks at mysql users conference

Posted on 2006/05/21 by

I am already a bit late to write about my MySQL Users Conference impressions or input, but better later than never. My pet topic is scalability, or rather, how to build big cheap systems, and I’ve had many mixed thoughts … Continue reading →

Posted in mysql, wikitech | Tagged , , | 3 Comments