Tim Vasquez
EF5
- Joined
- Dec 4, 2003
- Messages
- 3,411
As of May 30, 2010 Stormtrack is currently on a new server at 64.150.187.170; this is an Intel Core i7 server, which is a big step up from the old Celeron we used from 2004 to 2010. This should help a lot with the slowdowns on big chase days.
Here a chronology of how this all went down.
5:30 pm CDT: Froze the old server and suspended the forum. Ran backups and FTPd 500 MB of files and SQL backups across to the new server.
7:00 pm CDT: Did configuring on the new server and set up DNS. Found that DNS will actually take hours or days to reconfigure and propagate across the Internet.
8:00 pm CDT: Restored all files and SQL.
8:30 pm CDT: Started making a few posts, immediately ran into some SQL "Duplicate Entry For Key" errors. Started doing some tests. Found the backup did not include auto-increment information.
9:00 pm CDT: Deleted the database and recreated it. Reinstalled database from evening backup, ran vbulletin fix for indexes. Errors seemed to go away.
8:00 am CDT Sunday: Found some problems in the Admin panels and the "thanks" buttons did not work (and were even missing). Spent a couple of hours doing testing and identified auto-increment data as missing from the SQL dump transfer.
10:55 am CDT Sunday: Restored from last night's backup with auto-increment data intact and brought the board back online.
Thanks for your patience with this move. We did lose some messages overnight and this morning due to the rollback, and I apologize for this, but it was necessary to get the site working and so that we didn't move forward on a potentially corrupt database. It does appear things are working correctly now.
Tim
Here a chronology of how this all went down.
5:30 pm CDT: Froze the old server and suspended the forum. Ran backups and FTPd 500 MB of files and SQL backups across to the new server.
7:00 pm CDT: Did configuring on the new server and set up DNS. Found that DNS will actually take hours or days to reconfigure and propagate across the Internet.
8:00 pm CDT: Restored all files and SQL.
8:30 pm CDT: Started making a few posts, immediately ran into some SQL "Duplicate Entry For Key" errors. Started doing some tests. Found the backup did not include auto-increment information.
9:00 pm CDT: Deleted the database and recreated it. Reinstalled database from evening backup, ran vbulletin fix for indexes. Errors seemed to go away.
8:00 am CDT Sunday: Found some problems in the Admin panels and the "thanks" buttons did not work (and were even missing). Spent a couple of hours doing testing and identified auto-increment data as missing from the SQL dump transfer.
10:55 am CDT Sunday: Restored from last night's backup with auto-increment data intact and brought the board back online.
Thanks for your patience with this move. We did lose some messages overnight and this morning due to the rollback, and I apologize for this, but it was necessary to get the site working and so that we didn't move forward on a potentially corrupt database. It does appear things are working correctly now.
Tim