Friday night maintenance window for MySQL

As previously announced, we are proceeding with a maintenance window on Friday night between 10pm and 1am Arizona/Pacific time (1am and 4am Eastern, 5am and 8am UTC).

The primary purpose of this maintenance window will be to add RAM and CPU power to some of our MySQL servers. Just under 40% of member MySQL processes will be affected, and we estimate the total time affected will be about 30 – 45 minutes.

You can tell if you are likely to be affected if your MySQL @@hostname variable is “m2” or “m3.” However, while we don’t plan to move any MySQL processes between now and then, we do reserve the right to move them at any time for any reason if appropriate to maintain network stability and performance.

This upgrade will increase total RAM available to member MySQL processes by 60%, with a corresponding increase in CPU power. After the upgrade is complete, we will be able to finish the migration to FreeBSD 7 and the combined result will be better MySQL performance for all.

At the same time, we will be adding RAM and CPU cores to the hosting cluster, but that should not cause downtime since we can rotate the affected servers out of production prior to the upgrade and redistribute the load; there is plenty of spare capacity at that particular time.

As always, we appreciate your patience as we update and upgrade our network to make your hosting better, faster, and more reliable.

2 Comments

RSS feed for comments on this post.

1. Just because the internet hates everyone, you’ll probably get a DDoS attack at that time. 😛

   In fact, it might be better to not mention exact times in case people with malicious intent actually read this blog.

   We’re not going to alter our update schedule or public disclosure practices based on what hypothetical people might do. Our members need and deserve the best available information. If something bad happens, we’ll deal with it. -jdw

   Comment by Tyler — October 2, 2008 #

2. Which Friday?

   The Friday following the blog post. The maintenance has already been completed. -jdw

   Comment by Pat — October 8, 2008 #

Sorry, the comment form is closed at this time.