Posts tagged databases

21st January, 3:10 pm

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

20th January, 11:41 pm

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.