|
2020-11-15, 16:21
|
#12 |
"James Heinrich"
May 2004
ex-Northern Ontario
2·1,619 Posts |
Switched my brain back on, wrote a script to run through the 1080 .sql.gz files that need importing. Found the new server doesn't have PHP-cli installed, had to fight with that for a while, but now the import is going. This will take quite a few hours, no ETA yet.
|
|
|
|
2020-11-15, 18:36
|
#13 |
|
"James Heinrich"
May 2004
ex-Northern Ontario
323810 Posts |
Looking at the rough progress in terms of bytes processed per time, my ETA for importing the remaining data is currently 8 hours from now.
|
|
|
|
|
2020-11-15, 19:29
|
#14 | |
|
If I May
"Chris Halsall"
Sep 2002
Barbados
2×3×1,567 Posts |
Quote:
We all appreciated that a non-trivial amount of (volunteer) work is involved. A bit of down-time is not unreasonable for a once-every-few-years migration to better hardware. 
|
|
|
|
|
|
2020-11-15, 20:14
|
#15 |
|
"James Heinrich"
May 2004
ex-Northern Ontario
323810 Posts |
Pretty graphs, if anyone cares. Database import is highly CPU-limited (single-core), and you can see how the different data table structure affects IOPS: earlier it was doing very small rows (12 bytes/record I think) with a single key, right now when it's importing larger rows with multiple indexes. ETA says 3.9h
|
|
|
|
|
2020-11-15, 22:17
|
#16 |
|
6809 > 6502
"""""""""""""""""""
Aug 2003
101×103 Posts
9,181 Posts |
|
|
|
|
|
2020-11-16, 01:29
|
#17 |
|
"James Heinrich"
May 2004
ex-Northern Ontario
2×1,619 Posts |
That was fun... watching the graphs and all of a sudden I see disk free space tank at an alarming rate and no idea why, disk got up to 98% full before I found the enabled-by-default backup option in Plesk. Killed that, resuming import...
|
|
|
|
|
2020-11-16, 03:14
|
#18 |
|
"James Heinrich"
May 2004
ex-Northern Ontario
CA616 Posts |
Just finished importing the last database table. Now to try and plug everything together to get the site online again...
|
|
|
|
|
2020-11-16, 04:17
|
#19 |
|
"James Heinrich"
May 2004
ex-Northern Ontario
2·1,619 Posts |
And, no surprise, DNS is giving me grief...
|
|
|
|
|
2020-11-16, 05:30
|
#20 |
|
"James Heinrich"
May 2004
ex-Northern Ontario
2×1,619 Posts |
Apparently IONOS has a very strict default firewall policy, I had to manually open port 53 for DNS queries.
|
|
|
|
|
2020-11-16, 05:42
|
#21 |
Jun 2003
113528 Posts |
The site now renders. GIMPS Progress Visualization looks like needs to be generated for the first time in new server; presumably after the last couple of days' data is ingested, it will get generated.
|
|
|
|
2020-11-16, 05:51
|
#22 |
"/X\(‘-‘)/X\"
Jan 2013
24·3·61 Posts |
In the future, you can pipe the output of mysqldump to the mysql command on the remote server using nc. It's too late now, but something to keep in mind. And to do it encrypted you could forward a port using ssh. The only downside is that it's not a resumable process, so I would run the commands on both systems in screen or tmux.
|
|
|
|
 |
| 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 |
