Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
Our DBA is against these new fangled SQL alternatives...what should I tell her?
Comments
Comment #1
Owen Barton CreditAttribution: Owen Barton commentedComment #2
catchDoes the blackhole storage engine support transactions?
Comment #3
Owen Barton CreditAttribution: Owen Barton commentedIt 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...
Comment #4
catchI 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.