-- William Gibson, All Tomorrow's Parties
hdp noted that since our databases are now entirely InnoDBized (all the MyISAMisms have been ripped out), we no longer need to lock the entire database to get a consistant dump.
Others have written about MySQL backups, so I will just say that it makes me happy I no longer have to entirely rely on the validity of our replicas to get good backups. (Or lock the master for half an hour to get a dump.)
(Of course, all may not be light and fairies in the land of MySqueel, but if you've used it extensively for any period of time, I guess you know that already.)
And yes, it terrifies me to consider that the replicas are out of sync with the master, but errors definitely creep in. It saddens me.
In happier news, there is a new Slony-I site in the works, it seems.
< bda> I hate MySQL.
< confound> it crashed?
< confound> it crashed at 8:55
< confound> no idea why it was restarted at 9:55.
< bda> I don't think there are any scripts that know supervise.
< confound> I'm sure it wasn't that
< confound> it looks crash-related
< confound> it may even have been another crash at 9:55. it's hard to tell
< bda> Yeah, that looks likely. Or at least it came back up enough to be replicating.
< bda> (at 0855)
< bda> "You trust your data to that pile of junk? You're braver than I thought."
< bda> Sometimes MySQL can't make the jump to lightspeed, and you have to find a princess to get out and push...
I am pretty split on this. On one hand, it's a billion dollars. On the other, it's MySQL, which is a horrible little creature that seems to have permanently attached itself to my thigh and has been slowly suckling at my humours and spirits for years.
On the gripping hand, if anyone has a chance to fix the damn thing, it might be Sun's engineering (and even that isn't close to a sure thing, given some of the weird shit Sun has come up with over the years). But reading that, it doesn't seem as if that's the plan. At least not initially. Maybe in a few years we'll see enough integration that MySQL's odd engineering culture might get shifted around a bit.
And as Theo Schlossnagle noted not so long ago, MySQL doesn't actually own any of their engines.
Well. None of the ones that ... matter.
The other night I suggested the purchase might be justified if the new in-house MySQL engine is in fact a time machine of some sort.
Everyone seemed dubious at best.
Regardless of whether or not it was a good buy (Jonathan makes some excellent points), at the very least MySQL can't get any worse.
...for whatever that's worth.