ProSoundWeb Community

Please login or register.

Login with username, password and session length
Advanced search  
Pages: 1 [2]  All   Go Down

Author Topic: Nightly downtime  (Read 6804 times)

Ernie Black

  • SR Forums
  • Full Member
  • *
  • Offline Offline
  • Posts: 190
    • http://www.standingstone.com
Re: thanks Ernie
« Reply #10 on: June 09, 2008, 02:19:18 pm »

We're looking into options, Mac. As I say, I was unaware of this until I read Clayton's comments on May 28 (it's been ages since I was on the forum past 1 am). For one, I've requested that Rackspace reschedule the backup time to 3 am (still cocktail time somewhere, but better than midnight or 1 am). Beyond that, we're looking into the possibility of adding a mirrored database server, so that they can back up the mirror and not affect the primary. It takes about 1.25 hours on average to run the backup (over 7 GB of data in the forums, plus 456 tables and over 70 million records!).

Bear with us, now that we're aware of the situation. We'll come up with a solution (like: watch TV instead!! lol!!).
Logged
Ernie Black, Code Warrior
ProSoundWeb Forums Webmaster

John Schmidt

  • Full Member
  • ***
  • Offline Offline
  • Posts: 157
Re: thanks Ernie
« Reply #11 on: June 09, 2008, 03:00:22 pm »

Ernie Black wrote on Mon, 09 June 2008 11:19

...I've requested that Rackspace reschedule the backup time to 3 am...

That's still only midnite for those of us on the west coast. If you moved it a couple more hours, I still don't think it's likely those on the east coast would be affected, (unless they're pulling all-nighters!)  Rolling Eyes

Also, some types of backup software have "open-file" options, where you can check-mark if you want it to backup open files. Could that be an option?

John
Logged

Mac Kerr

  • SR Forums
  • Hero Member
  • *
  • Offline Offline
  • Posts: 10223
Re: thanks Ernie
« Reply #12 on: June 09, 2008, 03:17:50 pm »

Ernie Black wrote on Mon, 09 June 2008 14:19

Bear with us, now that we're aware of the situation. We'll come up with a solution (like: watch TV instead!! lol!!).
I was watching TV.   Laughing   And chatting, on the theater sound list, and playing solitaire. If we can't complain, what have we got?

Mac
Logged

Ernie Black

  • SR Forums
  • Full Member
  • *
  • Offline Offline
  • Posts: 190
    • http://www.standingstone.com
Re: thanks Ernie
« Reply #13 on: June 09, 2008, 10:03:24 pm »

John Schmidt wrote on Mon, 09 June 2008 15:00

Ernie Black wrote on Mon, 09 June 2008 11:19

...I've requested that Rackspace reschedule the backup time to 3 am...

That's still only midnite for those of us on the west coast. If you moved it a couple more hours, I still don't think it's likely those on the east coast would be affected, (unless they're pulling all-nighters!)  Rolling Eyes

Also, some types of backup software have "open-file" options, where you can check-mark if you want it to backup open files. Could that be an option?

John


But then there's the rest of the planet to consider. Argh, I hate time zones! I'll see what can be done.

Hey Mac, what's on the tube tonight?
Logged
Ernie Black, Code Warrior
ProSoundWeb Forums Webmaster

Ernie Black

  • SR Forums
  • Full Member
  • *
  • Offline Offline
  • Posts: 190
    • http://www.standingstone.com
Re: thanks Ernie
« Reply #14 on: June 10, 2008, 09:00:16 am »

New scheduled database backup time is 3 am. That's CST, btw, not EST, so it's 1 am west coast, which is better than midnight.
Logged
Ernie Black, Code Warrior
ProSoundWeb Forums Webmaster

Clayton Luckie

  • Hero Member
  • *****
  • Offline Offline
  • Posts: 989
Re: thanks Ernie
« Reply #15 on: June 11, 2008, 01:51:02 am »

Its 12:52AM CST now, and all is normal.  Thanks, Ernie!

cl
Logged

Philip Roberts

  • Sr. Member
  • ****
  • Offline Offline
  • Posts: 265
Re: thanks Ernie
« Reply #16 on: June 11, 2008, 03:16:35 am »

Thanks for working on this, 3am CDT is much better than midnight CDT. Another hour or two might be a tad better but not much.

That mirror DB server would be a big help. (It also extra redundancy).

Thanks again.

Philip

Ernie Black wrote on Tue, 10 June 2008 09:00

New scheduled database backup time is 3 am. That's CST, btw, not EST, so it's 1 am west coast, which is better than midnight.

Logged
Philip Roberts
Director of Media Engineering
Pioneer Memorial Seventh Day Adventist Church
Berrien Springs MI
Pages: 1 [2]  All   Go Up
 

Page created in 0.045 seconds with 20 queries.