Comment on How FriendFeed uses MySQL to store schema-less dataparentComments−apgwoz17yEven in Oracle, we've had to schedule downtime for a single column schema change and population for 45 minutes. I would call Oracle "mature."Note: I wasn't involved in doing the update, so it's possible there was a better way to do it. The table is used by about 50 different applications.−fendale17yAlmost all major oracle operations can be done online ... Index rebuilds, table reorgs etc. Depends how much hardware you have how much it affects things ...
Comments
Even in Oracle, we've had to schedule downtime for a single column schema change and population for 45 minutes. I would call Oracle "mature."
Note: I wasn't involved in doing the update, so it's possible there was a better way to do it. The table is used by about 50 different applications.
Almost all major oracle operations can be done online ... Index rebuilds, table reorgs etc. Depends how much hardware you have how much it affects things ...