More Troubles with the Database

A word from our sponsor:

Printer-friendly version

Author: 

Taxonomy upgrade extras: 

You may have to login again and any posts or new logins since midnight 07/02/21 are probably lost. Other than that, it may be okay. Hope, hope, hope.

- Erin

Comments

Page counters screwed up

erin's picture

We lost all page counts between 1 am PST 07/02/21 an 9 am 07/02/22. Sorry about that, chief.

- Erin

= Give everyone the benefit of the doubt because certainty is a fragile thing that can be shattered by one overlooked fact.

Nightly shutdown

erin's picture

In an effort to prevent future database corruption, TopShelf will shut down each night at 12.59 A.M. to 1:20 A.M. Pacific Time for database maintenance. This is the very middle of the slowest time of the night so it shouldn't affect too many people too badly. People in Far Eastern timezones may be inconvenienced, a bit, sorry.

This is in additon to the 5 minute shut down at 3 AM Pacific for server maintenance.

- Erin

= Give everyone the benefit of the doubt because certainty is a fragile thing that can be shattered by one overlooked fact.

Breakfast shutdown!

Rachel Greenham's picture

butbutbut that's exactly when I'm doing my morning round of sites! How am I going to get myself into the wrong frame of mind for work now?

;-)

Presumably this is to get a nice clear SQL-dump backup without the data changing while you do it. I can guess that otherwise (eg: grabbing a copy of the data dir under the running site) can leave things in an internally inconsistent state.

Yup

erin's picture

That's exactly what it's for. We had to put two different backups together to get a stable restore this morning because of the problem of trying to do a backup on an active database. It's like trying to diaper a toddler on a teeter-totter! 1 a.m. here is 8 or 9 in Olde London and early evening in Melbourne but not a lot I can do about it. :-{

- Erin

= Give everyone the benefit of the doubt because certainty is a fragile thing that can be shattered by one overlooked fact.