MySQL will be upgraded to 5.0.51 tonight between the hours of 1 – 2 AM EST (-0500 GMT). One fix looks similar to the problem we have seen occur rarely in the past with deadlocking, such that a table has a mutually exclusive write lock on it and that lock trickles out to all other processes. Ultimately, this bug kills all read/write requests on all databases until our internal monitor catches and restarts the MySQL server, but that’s anywhere between 1 – 15 minutes depending upon traffic. I’ve personally handled roughly this situation 4 times in the past year, which has existed since the early days of 4.0 mind you, so it is extremely rare. Whether my suspicions are right or not… we’ll have to wait and see.
SSL certificates will also be updated tonight since we’re rapidly approaching one year since leaving EV1 and moving to Gnax. Given the previous post regarding the power outage I would say Gnax knows how to treat us well on our birthday.
Pingback:akalin.cx / Backwards day at akalin.cx