iamcal.com Linklog

2006-07-31 13:47:33

Cal Henderson (http://www.iamcal.com/) — 2006-07-31T13:47:33Z

dathan's mysql blog is full of useful tips for people using mysql on a large scale. a kind of "advanced mysql hacks" book done right.

2005-07-02 12:40:13

Cal Henderson (http://www.iamcal.com/) — 2005-07-02T12:40:13Z

mike b pointed me to this bizarre article from IBM's daniel sabbah describes lamp as "going to have to grow up at some point". err, right. because lamp clearly doesn't scale. it's not like the biggest websites in the world use it. ryan tomayko's response is on the mark.

2005-01-21 15:10:36

Cal Henderson (http://www.iamcal.com/) — 2005-01-21T15:10:36Z

backed up for later - the innodb hot backup script. faster than restoring from a dump, but more prone to corruption.

2005-01-20 23:41:14

Cal Henderson (http://www.iamcal.com/) — 2005-01-20T23:41:14Z

gah. f was down for 5 hours after a routine database modification revealed massive innodb corruption which had somehow replicated to the slave. after splitting the cluster, our last backup was nine days old and a few million records short. eek. so a painstaking search and destroy for bad records was conducted. stupid mysql.

2005-01-12 01:23:54

Cal Henderson (http://www.iamcal.com/) — 2005-01-12T01:23:54Z

phpMyAdmin doesn't yet have support for NDB - looks like someone dropped the ball.

2005-01-12 01:15:36

Cal Henderson (http://www.iamcal.com/) — 2005-01-12T01:15:36Z

this is a good tutorial on mysql clustering. maybe when the new hardware arrives in the office we can give it a trial.