3Ware RAID rebuilding
Monday, May 14. 2007
I've had the dubious honour of seeing some RAID failures and rebuilds lately. It's the kind of thing that doesn't get written about in the manuals very well, in particular what your RAID will report when it's having trouble. So, here are a couple of examples from a 3Ware RAID controller using tw_cli software. This is what tw_cli /c4 show displays when we have a dead drive:
Unit UnitType Status %RCmpl %V/I/M Stripe Size(GB) Cache AVrfy ------------------------------------------------------------------------------ u0 RAID-1 DEGRADED - - - 149.05 ON - Port Status Unit Size Blocks Serial --------------------------------------------------------------- p0 OK u0 149.05 GB 312581808 G2109NHG p1 DEGRADED u0 149.05 GB 312581808 G20X1BWGSo, we swap the drive, and it looks like this while rebuilding:
Unit UnitType Status %RCmpl %V/I/M Stripe Size(GB) Cache AVrfy ------------------------------------------------------------------------------ u0 RAID-1 REBUILDING 89 - - 149.05 ON - Port Status Unit Size Blocks Serial --------------------------------------------------------------- p0 OK u0 149.05 GB 312581808 G2109NHG p1 DEGRADED u0 149.05 GB 312581808 G209Y0HGand after a little while...
Unit UnitType Status %RCmpl %V/I/M Stripe Size(GB) Cache AVrfy ------------------------------------------------------------------------------ u0 RAID-1 OK - - - 149.05 ON - Port Status Unit Size Blocks Serial --------------------------------------------------------------- p0 OK u0 149.05 GB 312581808 G2109NHG p1 OK u0 149.05 GB 312581808 G209Y0HGThere are plenty of obvious strings to match in this output (though there are many other reports available), so it's a reasonable thing to base a monitoring script on. It's nice to see it actually work, and makes me extremely grateful that I bothered getting RAID n the first place. This would be a much unhappier post if I hadn't.
CakePHP hasManyAndBelongsTo relationship limitations
Monday, May 14. 2007
Cake has some nice support for modeling many to many relations using 'hasManyAndBelongsTo'. There's a simple example here.
Though this works well for simple connections between classes, you can't do much else. Taking the classic Blog-style Posts and Tags example, this approach will easily let you link multiple tags to multiple posts. But what if you want to track the date that a tag was applied to a post? If you add a date field to the join table, it seems pretty much impossible to retrieve it, and setting it is even harder. You can search on it by twiddling with the conditions on the relation, but that's ugly. I think in that case, you have no option but to model the relation explicitly with two pairs of hasMany/belongsTo relations linked through a PostTag model, and then you'll have to set your recursion deeper and get busy with unbindmodel in order to keep the number of queries down. Who knows, I might even write up an example and post it here...


