replication

False assumptions with MySQL

Posted by cafuego on Friday 19 June 2009. In categories &mysql &replication &drupal

I spent far too much time this past week trying to find out why a Drupal was not assigning authenticated user permissions to users who clicked on the validation link they were emailed. Instead, it would simply remove the temporary unverified user permission.

It's supposed to do the latter, but then also follow it up with the former. It turns out the problem was a Drupal bug that was triggered by my MySQL setup.

replicants

Posted by cafuego on Thursday 5 June 2008. In categories &backup &debian &openssl &mysql &replication

I found myself with some spare time the other day and decided that my current mysql backup strategy is not the best in the world. The mysql server is a virtual machine in a Brisbane datacenter and it's backed up via a script that calls mysqldump on each installed database and dumps the content to (compressed) files. These files then get sucked down via rdiff-backup.

This is fine in principle, but does mean it's possible for me to lose 24 hours worth of data due to an accidental '--; DROP table students.