« Arrived at CAMP Shibboleth | Main | Adding hot-plug disk drives (use format, Solaris Disk Suite and newfs) »

June 28, 2004

Production Updated from MySQL 3.23.x to 4.0.20

One of the most nerve racking nights of my sysadmin career.

After many months of wanting to move up to the 4.0 branch we're finally there. Although it should have been a pretty simple process, it actually started on Thursday night at 10pm and completed around 5am Friday morning.

Our production MySQL was on an older box, which not only has all our production data, but also includes all user Unix shell accounts and home directories. The move involved going to a new machine, seamlessly moving shell accounts between machines and transferring the data which all sits on an A1000 hardware RAID array. We've had some bad bouts with the A1000, so I was prepared for the worse to happen and took 4 hours of extra downtime to make a complete copy of all the data before attempting to move everything to the new machine.

In the end it all went pretty smooth, but did take a long time to execute all the steps I had created in the few practice runs I made.

Posted by mike at June 28, 2004 12:42 AM