General Asylum

General audio topics that don't fit into specific categories.

Return to General Asylum

Message Sort: Post Order or Asylum Reverse Threaded

Downtime Thursday, February 26, 9AM

204.94.81.82
Posted on February 25, 2015 at 13:35:54
Rod M
Web Geek

Posts: 16246
Location: So. California
Joined: March 1, 1999
Contributor
  Since: March 1, 1999
 It's time.

To complete the final move to the new servers, I'll need to take down the site for about 2 1/2 to 3 hours. In addition to syncing all the data from one server to another, I also need to dump and load the db which takes most of the time to deal with some issues with a newer version of MySQL.

I was hoping to do this in just a half hour, but upgrading the db just takes a while to load 8 million posts and it became clear that it was best to just do it and get it done now.

Once we're done and sure that everything is running as it should, then we'll have one more disruption the following week or next to actually move the new servers to a new data center. It's taken us nearly 5 months to complete this upgrade and I'm quite happy with the performance improvement. If you've used the Search app lately, you're seeing the new servers in action with a dedicated search db server. Using Solid State Drives has delivered a huge boost in performance.

Wish me well.

Thanks for the support.

-Rod

 

Hide full thread outline!
    ...
RE: Downtime Thursday, February 26, 9AM, posted on February 25, 2015 at 15:22:44
fantja
Audiophile

Posts: 15524
Location: Alabama
Joined: September 11, 2010
 Go for It! Rod-

 

RE: Downtime Thursday, February 26, 9AM, posted on February 25, 2015 at 15:56:40
Inmate51
 Excellent timing. I have a dental appointment Thursday morning.

:)

 

This equates to 4am on Friday 27th here in upside-down-land.... , posted on February 25, 2015 at 16:17:46
three_sox
 ...This is a convenient and acceptable time for me, Rod. I just thought you’d like to know.

Keep up the good work.

This site is saving the health care system millions!

Oh, good luck with your tinkering.

 

seconded, thanks Rod for the whole damn thing! , posted on February 25, 2015 at 17:12:06
Timbo in Oz
Audiophile

Posts: 23221
Location: Canberra - in the ACT - SE Australia
Joined: January 30, 2002
 :-)!


Warmest

Tim Bailey

Skeptical Measurer & Audio Scrounger


 

Thanks, Rod, posted on February 25, 2015 at 20:04:43
Jay Buridan
Audiophile

Posts: 10284
Location: Michigan
Joined: January 21, 2004
 I love Audio Asylum!

"Horse sense is the thing a horse has which keeps it from betting on people. "
― W.C. Fields

 

RE: Downtime Thursday, February 26, 9AM, posted on February 26, 2015 at 08:44:29
Inmate51
 Maybe you could set up the new version of the DB software, make a copy of the database, hose over the 8 million posts from the copy (so the live db is still functional), verify that it works, put the new server online, and then update the database with whatever new posts were made since the time you made the db copy.

Essentially, what I'm saying is to do as much prep offline as possible, so that downtime is minimized. I'm pretty sure that MySQL has a way to update a database with the changes which were made after the last backup copy, a process which is often known as "batch processing", "batch updaing" or "syncronizing". It'd be too bad if you have to take down the site for three hours, bring up the new version, and discover that something is wrong and it'll be two more days before it works.

Having said that, whenever I release a new version of my db app, I tell clients to go offline during the update.

Good luck!

:)

 

RE: Downtime Thursday, February 26, 9AM, posted on February 26, 2015 at 08:53:59
Rod M
Web Geek

Posts: 16246
Location: So. California
Joined: March 1, 1999
Contributor
  Since: March 1, 1999
 Yeah, if it was only the db, perhaps, but I need to convert the character sets which can only be done by dropping the db and the creating it and loading the data. I've tried every other option. Since the two versions are incompatible, a db slave won't update with the data from the old db. I tried that too.

In addition, I have to sync the new server with all the cached html files and new image uploads which takes a while too. There's just no good way to have people posting and getting stuff updated in 2 places.


-Rod

 

Page processed in 0.037 seconds.

[ Top Top of Page ] [ Contact Us ] [ Support/Wish List ] [ Copyright © 2024, Audio Asylum, all rights reserved ]
[ General ] [ Speakers ] [ Tubes ] [ Vinyl ] [ Digital ] [ Hi-Rez ] [ Video Asylum ] [ Cables ] [ Tweaks/DIY ] [ Music ] [ Films ]