iamcal.com Linklog

2010-09-28 23:08:25

nobody@domain.com (Cal Henderson) — Tue, 28 Sep 2010 23:08:25 +0000

jeremy cole has finally solved the mysql swapping-for-no-reason issue. very nice work [via ph]

2010-08-16 21:30:47

nobody@domain.com (Cal Henderson) — Mon, 16 Aug 2010 21:30:47 +0000

noting these down for later reference - two excellent answers on quora from adam d'angelo on why quora uses mysql instead of postgres or a nosql solution. he says everything i've been saying for the last few years, but more eloquently

2009-10-24 09:18:10

nobody@domain.com (Cal Henderson) — Sat, 24 Oct 2009 09:18:10 +0000

a couple of interesting alternatives to phpMyAdmin, both simpler: sqlbuddy looks like a really well done minimalist effort, while phpMiniAdmin like like PMA from 10 years ago.

2009-03-26 11:37:35

nobody@domain.com (Cal Henderson) — Thu, 26 Mar 2009 11:37:35 +0000

xtrabackup sounds like really good news for people backing up large innodb instances. streaming backups? yes pls

2006-07-31 13:47:33

nobody@domain.com (Cal Henderson) — Mon, 31 Jul 2006 13:47:33 +0000

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

nobody@domain.com (Cal Henderson) — Sat, 2 Jul 2005 12:40:13 +0000

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

nobody@domain.com (Cal Henderson) — Fri, 21 Jan 2005 15:10:36 +0000

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

nobody@domain.com (Cal Henderson) — Thu, 20 Jan 2005 23:41:14 +0000

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

nobody@domain.com (Cal Henderson) — Wed, 12 Jan 2005 01:23:54 +0000

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

2005-01-12 01:15:36

nobody@domain.com (Cal Henderson) — Wed, 12 Jan 2005 01:15:36 +0000

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