mersenneforum.org  

Go Back   mersenneforum.org > Great Internet Mersenne Prime Search > Data > mersenne.ca

Reply
 
Thread Tools
Old 2020-11-13, 18:43   #1
James Heinrich
 
James Heinrich's Avatar
 
"James Heinrich"
May 2004
ex-Northern Ontario

1100011110012 Posts
Default mersenne.ca server migration and probable downtime (Nov 2020)

I will be moving mersenne.ca over to a new server this weekend (probably overnight Nov 14-15). I will be taking the site down before I start the migration to avoid getting data out of sync between the two. If everything goes well it'll only be a few hours of offline, but it might be longer. If you want assignments for tf1G or similar you should grab a few days extra supply now.

I'll post back here when I start the migration and when I think it should be finished and working again.
James Heinrich is offline   Reply With Quote
Old 2020-11-13, 23:17   #2
Ensigm
 
Aug 2020

3×5×7 Posts
Default

Thank you for sustaining the site and good luck with the migration.
Ensigm is offline   Reply With Quote
Old 2020-11-14, 06:09   #3
Xyzzy
 
Xyzzy's Avatar
 
"Mike"
Aug 2002

11110101110012 Posts
Default

Quote:
Originally Posted by Ensigm View Post
Thank you for sustaining the site and good luck with the migration.
+1

Xyzzy is offline   Reply With Quote
Old 2020-11-14, 13:15   #4
ET_
Banned
 
ET_'s Avatar
 
"Luigi"
Aug 2002
Team Italia

22×1,193 Posts
Default

Thank you James, and (no, I won't say it before you tell us the migration is complete).


Last fiddled with by ET_ on 2020-11-14 at 13:15
ET_ is offline   Reply With Quote
Old 2020-11-15, 03:46   #5
James Heinrich
 
James Heinrich's Avatar
 
"James Heinrich"
May 2004
ex-Northern Ontario

31·103 Posts
Default

Migration is started, but running into some snags. The Plesk Migrator is very handy, but unfortunately when copying databases it simply does a monolithic mysqldump of all tables, uncompressed and then copies that over. Which is fine for smaller sites, but mersenne.ca runs off 1138 (no THX) tables of a total size I haven't yet calculated, but the old server only had about 45GB free, even after I freed another 10GB that wasn't close to enough. So I'm going to have to manually migrate the database table-by-table, which is ok but takes more human-time than letting it run automated.

So downtime for mersenne.ca will be somewhat longer than expected, likely for at least the next 12h or more.
James Heinrich is offline   Reply With Quote
Old 2020-11-15, 04:11   #6
axn
 
axn's Avatar
 
Jun 2003

112668 Posts
Default

Is it possible to directly dump the backups into the new server (via shared folder)?

Last fiddled with by axn on 2020-11-15 at 04:11
axn is offline   Reply With Quote
Old 2020-11-15, 04:13   #7
James Heinrich
 
James Heinrich's Avatar
 
"James Heinrich"
May 2004
ex-Northern Ontario

C7916 Posts
Default

Probably, for someone who knows how, but that's beyond my knowledge. I'll just muddle along with what I know works.
James Heinrich is offline   Reply With Quote
Old 2020-11-15, 07:56   #8
James Heinrich
 
James Heinrich's Avatar
 
"James Heinrich"
May 2004
ex-Northern Ontario

31×103 Posts
Default

Quote:
Originally Posted by James Heinrich View Post
mersenne.ca runs off 1138 tables of a total size I haven't yet calculated, but the old server only had about 45GB free...
Turns out the total mysqldump filesize would be 97.3GB (and ~150GB actual disk used including indexes).
James Heinrich is offline   Reply With Quote
Old 2020-11-15, 08:20   #9
axn
 
axn's Avatar
 
Jun 2003

2·5·479 Posts
Default

Quote:
Originally Posted by James Heinrich View Post
Turns out the total mysqldump filesize would be 97.3GB (and ~150GB actual disk used including indexes).
I take it, the hard part (manual db dump) is complete?
axn is offline   Reply With Quote
Old 2020-11-15, 08:32   #10
James Heinrich
 
James Heinrich's Avatar
 
"James Heinrich"
May 2004
ex-Northern Ontario

31×103 Posts
Default

Manual DB dump is complete, I've now got a local backup of all the database files (17GB gzip'd) that I'm currently uploading to the new server while I sleep and then in the morning I'll manually import the missing large tables on the new server. Hopefully with Xeon+SSD that won't be as painfully slow as I've seen previously with Atom+HDD. Nevertheless, importing building ~140GB of database will take some time. I also need to attend to a couple other domains that share this server before I can plug it back in and turn it on. I'm hoping it can be online sometime later tomorrow (i.e. 12-18h from now) but we'll see how it goes. It's now 3:30am and my brain needs some off-time.
James Heinrich is offline   Reply With Quote
Old 2020-11-15, 09:08   #11
axn
 
axn's Avatar
 
Jun 2003

2×5×479 Posts
Default

Quote:
Originally Posted by James Heinrich View Post
It's now 3:30am and my brain needs some off-time.
axn is offline   Reply With Quote
Reply

Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Password recovery for v4 migration edr077 Information & Answers 1 2014-12-26 15:45
FactorDB is moving to another server this night -> some downtime Syd FactorDB 34 2012-02-03 19:18
Migration from Core 2 Quad to i7 965 Freightyard Hardware 30 2010-02-01 17:09
Planned downtime on GB servers mdettweiler No Prime Left Behind 35 2009-11-22 01:50

All times are UTC. The time now is 04:19.

Wed Dec 2 04:19:23 UTC 2020 up 83 days, 1:30, 1 user, load averages: 2.79, 2.50, 2.31

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.

This forum has received and complied with 0 (zero) government requests for information.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation.
A copy of the license is included in the FAQ.