Our DBA is against these new fangled SQL alternatives...what should I tell her?

Comments

Owen Barton’s picture

Owen Barton CreditAttribution: Owen Barton commented
Title: ACID compliance » ACID compliance?
catch’s picture

catch
he/him
Primary language English
CreditAttribution: catch commented

Does the blackhole storage engine support transactions?

Owen Barton’s picture

Owen Barton CreditAttribution: Owen Barton commented

It appears that it is, as of MySQL 5.1.4 anyway. Probably you could make this useful somehow - perhaps something along the lines of writing CRUD operations to an intermediate server transaction log so that (non ACID) slaves can reflect the results right whilst the operations can be queued up for writing to a canonical master...hmmm...

catch’s picture

catch
he/him
Primary language English
CreditAttribution: catch commented

I think Barry Jaspan was talking about having write slaves for things like comments, so that the comment is posted, goes into a queue, then shows up later - with "your comment has been received and will be displayed shortly". Seems like the 'no storage but proper transaction log' might actually be useful for that - very fast initial write that gets properly dealt with later. Not sure how that kind of bizarre setup could actually be supported by the module though.