Brad Fitzpatrick (bradfitz) wrote in lj_maintenance,
Brad Fitzpatrick
bradfitz
lj_maintenance

Software upgrade

The database has to be restarted sometime late tonight (probably about 1 or 2am PST). The restart will only take a few seconds, but a side effect is that the database's cache is destroyed and the site is slow for up to an hour after that. Which is why I have to do it at night.... normal load on a freshly started database will kill it. It needs its cache.

Anyway, if you're awake late tonight (or you're in Europe) and LJ is being a little slow for 15 minutes to a half hour, that's why.

This is a necessary upgrade of MySQL to get replication working reliably on Kenny so we can have backups, the directory, and more speed.

For the curious: the problem is that MySQL 3.23.33 adds to its binary change log for replication DROP TABLE statements on temporary tables, so then the query fails on the slave servers. It's since been fixed (3.23.37 is what I'm upgrading to), but I haven't wanted to stop the database.

Update: That didn't sound too optimistic. With luck, traffic will be low enough that the restart won't actually affect anything.
Subscribe

  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

  • 9 comments