Update: OSGrid users – If you are reading this due to the twitter/osgrid notice, or the OSGrid news notice – the short of it is, we’ve converting the asset server. It’s going to take 24 hours, and we’re going to need to pull the grid down to do it. Downtime will begin approximately at 1AM Wednesday morning. It will take up to 24 hours to process the conversion – I’ll be posting information here on this blog as we proceed with updates.
For those just joining us on the OSGrid FragStore saga, read parts #1, and part #2 here.
Day 3: Conversion of the 1.5 million test assets has completed – and now we’ve got only the metadata in the table, I’m going to take some attempts at running queries. CAS storage eliminated slightly higher than my predicted 17% – coming in at around disk 23.49% savings on duplicated assets. Unfortunately the first bug has become apparent – creation date wasn’t preserved. I have patched the converter, so this will be filled when we do the final live conversion.
The following is the outputs of some queries I have run on this table, since it doesnt look like these take too long, we should be able to run these off the production server and update them in future. First, there are 15,957 groups of items with more than 5 objects using the same name in the system, of these, the top asset names are -
| Asset Name | Quantity |
|---|---|
| Primitive | 357829 |
| blank | 156314 |
| New Script | 48841 |
| Object | 27919 |
| New Hair | 10156 |
| New Shape | 10023 |
| plant | 9311 |
| New Shirt | 8767 |
| SI – UPLOAD ME – Extra Properties Restore | 7485 |
| New Pants | 7212 |
| New Skin | 5366 |
| New Eyes | 5352 |
Returning to a query I was running yesterday on the CAS%s, the following is the updated chart with 1.5 million test assets loaded.
Fig 1. OSGrid CAS Duplicates (Day 3)
And if you have ever been curious about the distribution of assets in terms of asset type – here is a little chart showing the breakdown.
Fig 2. OSGrid Asset Quantities by Type
Full Conversion Date Set
We’ve decided to go ahead with the switchover this coming Wednesday, at 1AM PST. To go ahead with this, we are going to be bringing the grid offline for up to 24 hours. This hopefully will be the last time we need to go offline for more than 15 minutes – and also represents a move from our old asset hardware “Chenobyl” to our new server “Hindenburg” (which has a much larger hard disk capacity).
Chernobyl, Hindenburg… really?
You must like tempting fate…
Tony
1 May 09 at 2:52 pm
Oh, it’s deliberate. We named all the OSGrid servers last night – Chenobyl is the oldest, followed by Titanic, TacomaNarrows and Hindenburg is the new one.
The basis is “we know this isn’t stable, so we’re damn well going to advertise this.”
Adam Frisby
1 May 09 at 3:11 pm
Sounds familiar – my old employer had all our servers named after man-made disasters. Chernobyl, ThreeMile, Valdez, Congress, Pruit-Igoe, HyattKC… not sure if we had a Hindenburg, definitely didn’t have a TacomaNarrows.
Buckaroo Mu
2 May 09 at 6:01 am
No way to thank you all properly for all you do…. but still, thanks. Love OSG.
LisaKathleen Kaligawa
2 May 09 at 6:20 am
It’s not stable??? OMG why didn’t you tell us this before!
/me runs and hides
Simon Probert
2 May 09 at 12:54 pm
Thankx for the update, although I don’t understand a WORD of it…LOL…no techie here, sorry–just have to trust those who walk THAT winding path…prayers are with you and your staff.
Schizm Neutra
3 May 09 at 12:37 pm
Well done guys for everything that you are doing.
I’m not a techie person either but i do enjoy everything that osgrid offers and will continue to do so.
Keep up the great work!
Darren Reiner
7 May 09 at 6:30 am