Migration to new Message Boards - Part two
By
Archy,
Posted on: 2009-07-23 20:17 in News, Events and Announcement Discussion
I'm ready!!
Its not down yet!!
pom poms of doom are ready!!
POM POMS DOOM ARE PINK!
Freaking.. 3 days? Thats long 
50)Sinergy X/(50)Mika.
(50)MaceX/(50)Encore
Sign the petition, dont let CoH go down! SIGN!
Posting to the last! Keep up the good work, folks, and see you on the other side.
Of course, according to the announcement we have until at least 3.00 this afternoon before it all goes off.
The wisdom of Shadowe: Ghostraptor: The Shadowe is wise ...; FFM: Shadowe is no longer wise.
; Techbot_Alpha: Also, what Shadowe said. It seems he is still somewhat wise 
; Bull Throttle: Shadowe was unwise in this instance...; Rock_Powerfist: in this instance Shadowe is wise.; Techbot_Alpha: Shadowe is very wise *nods*; Zortel: *Quotable line about Shadowe being wise goes here.*
Ooohh that is 4pm for me..
Enough time to write another doom post.
(lol my 3rd post again timeout)
50)Sinergy X/(50)Mika.
(50)MaceX/(50)Encore
Sign the petition, dont let CoH go down! SIGN!
[ QUOTE ]
I'm ready!!
Its not down yet!!
pom poms of doom™ are ready!!
POM POMS DOOM™ ARE PINK!
Freaking.. 3 days? Thats long
[/ QUOTE ]
Indeed. To "copy" all the mails they must be typing them out by hand again
Still, I'm off to be wed from today (or to run around like a headless chicken trying to organise everything) so good timing as far as I'm concerned.
So Avatea does the last person to post a mail in the old boards win a prize?
[ QUOTE ]
So Avatea does the last person to post a mail in the old boards win a prize?
[/ QUOTE ]
The 'i used a bot to randomly post untill the board went down' award? 
50)Sinergy X/(50)Mika.
(50)MaceX/(50)Encore
Sign the petition, dont let CoH go down! SIGN!
I'm looking forward to the new forums too, problem is for the next few days I might have to actually get on with some work at work..
[ QUOTE ]
[ QUOTE ]
Freaking.. 3 days? Thats long
[/ QUOTE ]
Indeed. To "copy" all the mails they must be typing them out by hand again
[/ QUOTE ]
Or [*] Effective merging of 2 reasonably large databases with re-assignment/re-mapping of key data (I'd guess at least user, post and PM IDs)[*] multiple backups for that little bit of extra defence against Mr [censored]-up[*] Testing/Verification[*] a little contingency time built in
Not exactly a business-critical change either - so no need to have people working 24hrs a day on it...
I wouldn't say 3 days was a particularly long time for it.
Look at it this way: Would 1 day be reasonable if it was just migrating EU boards to new software? If so then imagine that they've got 1 day for EU, 1 day for US and 1 day to sort out conflicts/clashes and test/check the merge.
Yeah it won't be quite split like that - but just showing that 3 days isn't unreasonable.
By my mohawk shall ye know me!
my toons
Funny: Ee-Ai-Ee-Ai-Oh! #3662 * The foul-mouthed Handyman! #1076 * City of Norms #132944
Serious: To Save A Single World (#83744) * Marketing Opportunity (#83747)
[ QUOTE ]
Or [*] Effective merging of 2 reasonably large databases with re-assignment/re-mapping of key data (I'd guess at least user, post and PM IDs)[*] multiple backups for that little bit of extra defence against Mr [censored]-up[*] Testing/Verification[*] a little contingency time built in
Not exactly a business-critical change either - so no need to have people working 24hrs a day on it...
I wouldn't say 3 days was a particularly long time for it.
Look at it this way: Would 1 day be reasonable if it was just migrating EU boards to new software? If so then imagine that they've got 1 day for EU, 1 day for US and 1 day to sort out conflicts/clashes and test/check the merge.
Yeah it won't be quite split like that - but just showing that 3 days isn't unreasonable.
[/ QUOTE ]
Pffft, you and your "facts" JD. This is the internet. Everyone knows that anything one doesn't know how to do is therefore really easy and takes seconds to do (although upgrading web applications is one of the few things I do know how to do).
I assume they also have to change database layouts as well as just merging, I can't imagine the two BB apps use the same db schema.
Whenever we have to do something along these lines at work, we take copies of all the DB's and run several tests, fine tuning the scripts on the copies until we KNOW it's working right. Then when it's time to do it live, the whole process is done in under an hour (and I assure you, our client's live databases are waaaaaaaaay bigger than these forum ones... )
@FloatingFatMan
Do not go gentle into that good night.
Rage, rage against the dying of the light.
[ QUOTE ]
I assume they also have to change database layouts as well as just merging, I can't imagine the two BB apps use the same db schema.
[/ QUOTE ]
But those who have an appreciation of what the work will probably entail already know this and hoi polloi would see it as technical gobbledegook - so nothing was gained by pointing this out.
Although I did actually allude to this sort of change in the phrase 'effective merging' rather than just straight 'merging'.
Done a fair bit of web work but last year I performed an 'effective merge' of 2 large financial reporting systems for a private health company. The board migration should be a smaller (and less business critical) task - but I don't really envy them.
By my mohawk shall ye know me!
my toons
Funny: Ee-Ai-Ee-Ai-Oh! #3662 * The foul-mouthed Handyman! #1076 * City of Norms #132944
Serious: To Save A Single World (#83744) * Marketing Opportunity (#83747)
[ QUOTE ]
Whenever we have to do something along these lines at work, we take copies of all the DB's and run several tests, fine tuning the scripts on the copies until we KNOW it's working right. Then when it's time to do it live, the whole process is done in under an hour (and I assure you, our client's live databases are waaaaaaaaay bigger than these forum ones... )
[/ QUOTE ]
Aye, but probably so are the dbservers they're served on 
And the forums are mainly text based so you've to regenerate full text indexes on everything which can take a while, especially on a slower machine running MySQL.
[ QUOTE ]
But those who have an appreciation of what the work will probably entail already know this and hoi polloi would see it as technical gobbledegook - so nothing was gained by pointing this out.
[/ QUOTE ]
I gained a +1 to my soon-to-be-deceased postcount. Plus it passes the time on my last day before hols since I'm not allowed to do any actual work in case I break something.
[ QUOTE ]
[ QUOTE ]
Whenever we have to do something along these lines at work, we take copies of all the DB's and run several tests, fine tuning the scripts on the copies until we KNOW it's working right. Then when it's time to do it live, the whole process is done in under an hour (and I assure you, our client's live databases are waaaaaaaaay bigger than these forum ones... )
[/ QUOTE ]
Aye, but probably so are the dbservers they're served on
And the forums are mainly text based so you've to regenerate full text indexes on everything which can take a while, especially on a slower machine running MySQL.
[/ QUOTE ]
Oh yes... We run on Multi-terabyte DB's running on AS/400 mainframes. But the principle is still the same... You run multiple tests on backups until you KNOW the scripts will work, and it should all be plain sailing when you finally do it live. That they're taking 3 days over it just kinda shows they've not done many/any dry runs.
@FloatingFatMan
Do not go gentle into that good night.
Rage, rage against the dying of the light.
[ QUOTE ]
[ QUOTE ]
But those who have an appreciation of what the work will probably entail already know this and hoi polloi would see it as technical gobbledegook - so nothing was gained by pointing this out.
[/ QUOTE ]
I gained a +1 to my soon-to-be-deceased postcount. Plus it passes the time on my last day before hols since I'm not allowed to do any actual work in case I break something.
[/ QUOTE ]
But...
If you can't do any work today (in case you break something before your hols) did you manage to not do any work yesterday (in case you broke something before today when you can't do any work (in case you break something before your hols))?
And if that's the case:
Did you manage to not do any work on Friday in case..?
By my mohawk shall ye know me!
my toons
Funny: Ee-Ai-Ee-Ai-Oh! #3662 * The foul-mouthed Handyman! #1076 * City of Norms #132944
Serious: To Save A Single World (#83744) * Marketing Opportunity (#83747)
For the database, both UBB and VBB have great migration tools to transfer the whole database and make it compatible with the new one.
But 3 days.. thats friday then. But same day Aion beta starts again! And today Fat princess is available on PSN, i got 2 TF's on the US, i can survive 3 days.. for now.
(and i hate TWIFFER!)
50)Sinergy X/(50)Mika.
(50)MaceX/(50)Encore
Sign the petition, dont let CoH go down! SIGN!
[ QUOTE ]
[ QUOTE ]
[ QUOTE ]
But those who have an appreciation of what the work will probably entail already know this and hoi polloi would see it as technical gobbledegook - so nothing was gained by pointing this out.
[/ QUOTE ]
I gained a +1 to my soon-to-be-deceased postcount. Plus it passes the time on my last day before hols since I'm not allowed to do any actual work in case I break something.
[/ QUOTE ]
But...
If you can't do any work today (in case you break something before your hols) did you manage to not do any work yesterday (in case you broke something before today when you can't do any work (in case you break something before your hols))?
And if that's the case:
Did you manage to not do any work on Friday in case..?
[/ QUOTE ]
Friday I had to do work to fix something I broke on Thursday, unfortunately. My plan was to do little, but I didn't get away with it.
In future I'll know not to do anything the day before the day before the day before my hols either. Lesson learned
[ QUOTE ]
Fat princess is available on PSN
[/ QUOTE ]
PS3 only, drat.
Was looking forward to bringing a fat princess with me on my honeymoon (anyone making jokes about my fiancee will be hunted down).
[ QUOTE ]
[ QUOTE ]
[ QUOTE ]
Whenever we have to do something along these lines at work, we take copies of all the DB's and run several tests, fine tuning the scripts on the copies until we KNOW it's working right. Then when it's time to do it live, the whole process is done in under an hour (and I assure you, our client's live databases are waaaaaaaaay bigger than these forum ones... )
[/ QUOTE ]
Aye, but probably so are the dbservers they're served on
And the forums are mainly text based so you've to regenerate full text indexes on everything which can take a while, especially on a slower machine running MySQL.
[/ QUOTE ]
Oh yes... We run on Multi-terabyte DB's running on AS/400 mainframes. But the principle is still the same... You run multiple tests on backups until you KNOW the scripts will work, and it should all be plain sailing when you finally do it live. That they're taking 3 days over it just kinda shows they've not done many/any dry runs.
[/ QUOTE ]
And yet, that is no guarantee for success.. I once upon a time was involved in a multi upgrade of several DB's that also exceeded the sanity borders in size. Dry runs were done, backups were abused time and again until they happily accepted their flogging and all would take little more than three hours.
And then we went on to live. And live was less willing. Live was stubborn, causing the entire process to take close to 72 hours eventually. We had no fun I can tell you. Oh and those 72 hours WERE end to end, no 8 hours on and then 16 off, we had a weekend and one holiday straight after to sort it. We used it all...
Dry runs that are flawless are no guarantee unfortunately...
You could say we did have a visitor back then.. Mr. Sod..
you guy's do know that, the more posts we make here, THE LONGER IT'S GONNA TAKE.
just had to say that.....
[ QUOTE ]
you guy's do know that, the more posts we make here, THE LONGER IT'S GONNA TAKE.
just had to say that.....
[/ QUOTE ]
Hee hee, never thought of that.
(There's another couple of milliseconds added)
To be honest, if we at this point decide to add only oneliners, we all put together will not ever reach GG's total amount of posts. Something tells me we won't make that much of an impact..
[ QUOTE ]
you guy's do know that, the more posts we make here, THE LONGER IT'S GONNA TAKE.
just had to say that.....
[/ QUOTE ]
I think this thread probably won't be moved over, as it'll be out of date by Friday
@Golden Girl
City of Heroes comics and artwork
According to VBulletin there is an automated conversion tool, but I think the delay will be the converted data merger and user name adjustments...
Also coming soon VBulletin V4 (I assume the forums will go down for that upgrade too.)
Nuff Said...
Coolio Wolfus leader of Coolio�s Crusaders on Union.
Tekna Logik leader of Tekna�s Tormentors on Defiant.
Creator of: Coolio's Tech Beacon Replacements
AE arc 402506, 'The Rise and Demise or Otherwise of Tekna Logik...'.
[ QUOTE ]
According to VBulletin there is an automated conversion tool, but I think the delay will be the converted data merger and user name adjustments...
Also coming soon VBulletin V4 (I assume the forums will go down for that upgrade too.)
[/ QUOTE ]
Oh [censored].. my username on the US side is SinergyX also.
I get a confict with my own identity!
OMG i'm skitsofrenic! Wich account is this? Who am i talking to? GET IT OUT OF MY HEAD!!!
Pink.. pom pom.. must.. DOOM!!!
50)Sinergy X/(50)Mika.
(50)MaceX/(50)Encore
Sign the petition, dont let CoH go down! SIGN!
[ QUOTE ]
90 minutes left
[/ QUOTE ]
If your looking at the forums when it gets brought down does the screen go black with the words
GAME OVER
on it?
@Damz Find me on the global channel Union Chat. One of the best "chat channels" ingame!
well I'm looking forward to the new forums, although I'll be quite sad to see the current ones go as they have served us well in the years past!!!
In-game and now on Twitter @Tsumiju Zero "The Nightmare of Dra'Gon"
"The flow of battle can only be influenced, not by realtime tactics, but by strategy."
Proud resident of the Union EU Server.
B.A.F. Trial Guide