October 13, 2011 :: Tsunami scheduled MySQL maintenance

Jason · October 09, 2011, 05:49:58 PM

We will be performing some MySQL maintenance on Tsunami this coming Thursday evening: October 13, 2011 at approximately 11pm EST.

This maintenance should take approximately 30 minutes. During this time, the server will be online and services -- except for MySQL -- will not be impacted. Sites requiring MySQL connectivity to run (for example: forums, blogs, etc) will be impacted during the window.

Please let me know if you have any questions.

I will be emailing a link to this thread to all customers with current accounts on Tsunami within the next 10 minutes.

Thank you!

Regards,
Jason

Myron · October 09, 2011, 07:42:27 PM

Just want to confirm: EST, not EDT - no daylight savings? = GMT -5?

Jason · October 09, 2011, 08:42:18 PM

Quote from: Myron on October 09, 2011, 07:42:27 PM
Just want to confirm: EST, not EDT - no daylight savings? = GMT -5?

I believe daylight savings (Summer) goes until November 6 so the time would be GMT -4

http://wwp.greenwichmeantime.com/time-zone/usa/eastern-time/

I guess it's technically EDT

I call it EST all year regardless of daylight savings.

Jason · October 13, 2011, 10:05:53 AM

Tsunami is currently facing some mysql service restarts. If necessary, we will do the scheduled maintenance for tonight right now if that will address the issues. I will keep this thread updated.

Thanks,
Jason

Jason · October 13, 2011, 10:16:17 AM

We are doing this maintenance now. I was hoping to do this as scheduled later in the evening vs. this time of day but unfortunately the service is currently unstable.

I will update this thread once this is complete.

Thanks

Pam · October 13, 2011, 10:17:33 AM

Thanks Jason .... standing by ....

Pam · October 13, 2011, 11:11:01 AM

We appear to be back up and running, however we have lost some of our 'posts'. The last post is shown @ ~8:30 a.m. and there were several made following that time. It's not an issue really ... just curious?

Jason · October 13, 2011, 11:12:35 AM

The lengthy portion of the maintenance is done. Hopefully it should not be much longer.

I will keep you posted.

Jason · October 13, 2011, 12:01:09 PM

This should be complete as of approximately 30 minutes ago.

If you're seeing anything abnormal, please let me know.

The maintenance window for tonight will no longer be needed.

Thanks,
Jason

relaine · October 13, 2011, 12:05:57 PM

Jason, thank you for always being on top of things and keeping us up and running smoothly. All the members of my forum appreciate it so very much!!!

Jason · October 13, 2011, 12:13:11 PM

Quote from: Pam on October 13, 2011, 11:11:01 AM
We appear to be back up and running, however we have lost some of our 'posts'. The last post is shown @ ~8:30 a.m. and there were several made following that time. It's not an issue really ... just curious?

Unfortunately I can't explain that. I can understand if someone was typing something prior to the outages that it would be lost if it failed to write it to the the database when the service restarted but if you were able to view the posts and then they disappeared afterwards, that should not happen. The first mysql failure notice I received today was at 8:40am. They continued after that. So there was definitely some abnormal behavior around that time.

Quote from: relaine on October 13, 2011, 12:05:57 PM
Jason, thank you for always being on top of things and keeping us up and running smoothly. All the members of my forum appreciate it so very much!!!

I appreciate your understanding!

Pam · October 13, 2011, 12:21:06 PM

Quote from: Jason on October 13, 2011, 12:13:11 PM
Quote from: Pam on October 13, 2011, 11:11:01 AM
We appear to be back up and running, however we have lost some of our 'posts'. The last post is shown @ ~8:30 a.m. and there were several made following that time. It's not an issue really ... just curious?

Unfortunately I can't explain that. I can understand if someone was typing something prior to the outages that it would be lost if it failed to write it to the the database when the service restarted but if you were able to view the posts and then they disappeared afterwards, that should not happen. The first mysql failure notice I received today was at 8:40am. They continued after that. So there was definitely some abnormal behavior around that time.

No worries about our lost posts .. it just is what it is.

Like Relaine, we also appreciate all that you do to keep us up and running smoothly!

Thank you!

Jason · October 13, 2011, 08:28:50 PM

Quote from: Pam on October 13, 2011, 12:21:06 PM
No worries about our lost posts .. it just is what it is.

Like Relaine, we also appreciate all that you do to keep us up and running smoothly!

Thank you!

Thank you - I appreciate your support!

-Jason